buyservlet.java

本系统是一个具有交互功能的C2C类型的电子商务网站（客户与客户之间进行商品交易的平台）

package myservlet.s;
import java.text.SimpleDateFormat;

import mybean.b.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class BuyServlet extends HttpServlet{
  public void init(ServletConfig config) throws ServletException{
    super.init(config);
    try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    }catch(Exception e){}
  }
  public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{

       HttpSession session=request.getSession(true);
       LogInBean loginbean=(LogInBean)session.getAttribute("loginbean");
       boolean boo=true;
       if(loginbean==null){
         boo=false;
         response.sendRedirect("index.html");
       }
       if(boo==true){
         boolean issuccess=loginbean.getIssuccess();
         String loginname=loginbean.getLoginname();
         continueDoPost(request,response,loginname,issuccess);
       }
  }
  public void continueDoPost(HttpServletRequest request,HttpServletResponse response,String loginname,boolean issuccess) throws ServletException,IOException{
       Connection con;
       Statement sql;
       String backnews;
       BuyBean buybean=new BuyBean();
       request.setAttribute("buybean",buybean);

       String sbuynumber=request.getParameter("buynumber");
       String swareid=request.getParameter("wareid");    
   try{
       con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=shopping","shop","123");
       sql=con.createStatement();
       if(issuccess){
          SimpleDateFormat dd=new SimpleDateFormat("dd日hh时mm分");
          java.util.Date date=new java.util.Date();
          String screatetime="2008年01月"+dd.format(date)+"";

          String insertstr="insert into goods (BuyNumber,UserName,WareID,CreateTime) values('"+sbuynumber+"','"+loginname+"','"+swareid+"','"+screatetime+"')";
          int m=sql.executeUpdate(insertstr);
          if(m!=0){
             backnews="添加到购物车成功!";
             buybean.setBacknews(backnews);
             buybean.setBuynumber(sbuynumber);          
             buybean.setLoginname(loginname);      
             buybean.setCreatetime(screatetime);
             buybean.setWareid(swareid);
          }
          else{
             backnews="添加到购物车失败!";
             buybean.setBacknews(backnews);
          }
       }
       else{
            backnews="请使用正确帐号登陆!";
            buybean.setBacknews(backnews);
       }
       con.close();
    }catch(Exception ee){
       backnews=""+ee;
       buybean.setBacknews(backnews);       
    }
    RequestDispatcher dispatcher=request.getRequestDispatcher("addtocarresult.jsp");
    dispatcher.forward(request,response);    
  }
  public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
    doPost(request,response);
  }
}