regesitservlet.java

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

package myservlet.s;
import mybean.b.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class RegesitServlet 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 str){
   try{
     byte b[]=str.getBytes("ISO-8859-1");
     str=new String(b);
   }catch(Exception e){}
   return str;
 }
 
 public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
      Connection con;
      Statement sql;
      RegesitBean ff=new RegesitBean();
      request.setAttribute("regesitbean",ff);
      String susername=handleString(request.getParameter("username"));
      String suserpassword=request.getParameter("userpassword");
      String stelephone=request.getParameter("telephone");
      String semail=request.getParameter("email");
      String srealname=request.getParameter("realname");
      String querystr="SELECT * FROM users WHERE UserName='"+susername+"'";
      String insertstr="insert into users (UserName,UserPassword,RealName,Telephone,Email,Role) values('"+susername+"','"+suserpassword+"','"+srealname+"','"+stelephone+"','"+semail+"','"+0+"')";
      if(susername==null) susername="";
      if(suserpassword==null) suserpassword="";
      String backnews="";
      try{
          con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=shopping","shop","123");
          sql=con.createStatement();
          ResultSet rs=sql.executeQuery(querystr);
          boolean boo1=rs.next();
          boolean boo=susername.length()>0&&suserpassword.length()>0&&!boo1;
          if(boo){
              int m=sql.executeUpdate(insertstr);
              if(m!=0){
                backnews="注册成功!";
                ff.setBacknews(backnews);
                ff.setUsername(susername);
                ff.setUserpassword(suserpassword);
                ff.setTelephone(stelephone);
                ff.setEmail(semail);
                ff.setRealname(srealname); 
              }
              else{
                backnews="注册失败!";
                ff.setBacknews(backnews);
              }             
           }
           else{
               backnews="注册信息填写不完全或已经注册的用户名!";
               ff.setBacknews(backnews);
           }
           con.close();
       }catch(SQLException ee){backnews=""+ee;ff.setBacknews(backnews);}
       RequestDispatcher dispatcher=request.getRequestDispatcher("regesitResult.jsp");
       dispatcher.forward(request,response);
  } 
  public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
     doPost(request,response);
  } 
}