preparebuyservlet.java

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

package myservlet.s;
import mybean.b.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class PrepareBuyServlet 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{
     Connection con;
     Statement sql; 
     String swarename,sprice,scompany,spicurl,sintro; 

     String swareid=request.getParameter("wareid");

     PrepareBuyBean preparebuybean=new PrepareBuyBean();
     HttpSession session=request.getSession(true);
     session.setAttribute("preparebuybean",preparebuybean);


    try{
       StringBuffer sliuyan=new StringBuffer();
       con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=shopping","shop","123");
       sql=con.createStatement();
       String querystr1="select WareName,Company,Price,PicUrl,Intro from wares where WareID='"+swareid+"'";
       ResultSet rs1=sql.executeQuery(querystr1);
       if(rs1.next()){
         swarename=rs1.getString(1);
         scompany=rs1.getString(2);
         sprice=rs1.getString(3);
         spicurl=rs1.getString(4);
         sintro=rs1.getString(5);

         preparebuybean.setWarename(swarename);
         preparebuybean.setCompany(scompany);
         preparebuybean.setPrice(sprice);     
         preparebuybean.setPicurl(spicurl);
         preparebuybean.setIntro(sintro);
         preparebuybean.setWareid(swareid);
       }       
       String querystr2="select Content,UserName,CreateTime from words where WareID='"+swareid+"'";
       ResultSet rs2=sql.executeQuery(querystr2);
       while(rs2.next()){
          String scontent=rs2.getString(1);
          String susername=rs2.getString(2);
          String screatetime=rs2.getString(3);
          sliuyan.append("<h3>"+susername+":"+screatetime+"</h3>"+scontent);
       }
       preparebuybean.setLiuyan(sliuyan);
       con.close();
    }catch(Exception e){preparebuybean.setBacknews(""+e);}
       RequestDispatcher dispatcher=request.getRequestDispatcher("preparebuy.jsp");
       dispatcher.forward(request,response);
  }     
  public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
    doPost(request,response);
  }
}