fabiaoservlet.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 FaBiaoServlet extends HttpServlet{
  public void init(ServletConfig config) throws ServletException{
    super.init(config);
    try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    }catch(Exception e){}
  }
  public String handleString(String s){
     String ss="";
     try{
         byte bb[]=s.getBytes("ISO-8859-1");
         ss=new String(bb); 
     }catch(Exception e){}
     return ss;
  }
  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;
       FaBiaoBean fabiaobean=new FaBiaoBean();
       request.setAttribute("fabiaobean",fabiaobean);
       String swareid=request.getParameter("wareid");
       String scontent=request.getParameter("content");    
       scontent=handleString(scontent);
   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 words (WareID,Content,UserName,CreateTime) values('"+swareid+"','"+scontent+"','"+loginname+"','"+screatetime+"')";
          int m=sql.executeUpdate(insertstr);
          if(m!=0){
             fabiaobean.setWareid(swareid);          
             fabiaobean.setContent(scontent);      
             fabiaobean.setLoginname(loginname);
             fabiaobean.setCreatetime(screatetime);
          }  
       }
       con.close();
    }catch(Exception ee){}
    RequestDispatcher dispatcher=request.getRequestDispatcher("lookpreparebuyservlet");
    dispatcher.forward(request,response);    
  }
  public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
    doPost(request,response);
  }
}