gouwucheservlet.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 GouwucheServlet 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;
       StringBuffer strb=new StringBuffer();
       GouwuBean gouwubean=new GouwuBean();
       request.setAttribute("gouwubean",gouwubean);
      

        
   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年1月"+dd.format(date)+"";

          String str="select WareName,Price,BuyNumber,CreateTime from goods,wares where goods.WareID=wares.WareID and goods.UserName='"+loginname+"'";
          ResultSet rs=sql.executeQuery(str);
          double sum=0.0,a,b;
         strb.append("<table border=1 bordercolor=#FFFF00 bgcolor=#66CCFF>");
         strb.append("<tr>");
              strb.append("<td width=170 height=44 align=center>商品名称</td>");
              strb.append("<td width=110 align=center>商品价格</td>");
              strb.append("<td width=110 align=center>购买数量</td>");
              strb.append("<td width=200 align=center>购买时间</td>");
              strb.append("</tr>");
         while(rs.next()){
              strb.append("<tr>");
              strb.append("<td align=center>"+rs.getString(1)+"</td>");
              strb.append("<td align=center>"+rs.getString(2)+"元</td>");
              strb.append("<td align=center>"+rs.getString(3)+"</td>");
              strb.append("<td align=center>"+rs.getString(4)+"</td>");
              strb.append("</tr>");
              a=Double.parseDouble(rs.getString(2));
              b=Double.parseDouble(rs.getString(3));
              sum=sum+a*b;
          }
         strb.append("</table>");
         con.close();
          gouwubean.setLoginName(loginname);
          gouwubean.setResult(strb);
          gouwubean.setSum(sum);
          
          }
}
catch(Exception e){strb.append(""+e);gouwubean.setResult(strb);}
          
    RequestDispatcher dispatcher=request.getRequestDispatcher("gouwuche.jsp");
    dispatcher.forward(request,response);    
  }
  public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
    doPost(request,response);
  }
}