zhuxiaoservlet.java

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

package myservlet.s;
import mybean.b.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ZhuXiaoServlet 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 ok=true;
     boolean boo=false;
     if(loginbean==null){
        ok=false;
        response.sendRedirect("index.html");
     }
     if(ok=true){
        boo=loginbean.getIssuccess();
     }
     if(boo==true){
        String loginname=loginbean.getLoginname();
        continueDoPost(request,response,session,loginname);
     }
   }
   public void continueDoPost(HttpServletRequest request,HttpServletResponse response,HttpSession session,String loginname) throws ServletException,IOException{
     Connection con;
     Statement sql;
     String delstr="delete from goods where UserName='"+loginname+"'";
     try{
       con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=shopping","shop","123");
       sql=con.createStatement();
       String querystr="select * from goods where UserName='"+loginname+"'";
       ResultSet rs=sql.executeQuery(querystr);
       if(rs.next()){
            int m=sql.executeUpdate(delstr);
       }
       session.invalidate();
     }catch(Exception e){}
     response.sendRedirect("index.html");
   }
   public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
      doPost(request,response);
   }
}