handleregister.java

JSP网上书店系统,jsp加SQL数据库,能完整运行

package myservlet.control;
import mybean.data.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HandleRegister 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)
   {   try{ byte bb[]=s.getBytes("iso-8859-1");
            s=new String(bb);
          }
       catch(Exception ee){} 
       return s;  
   }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   Connection con; 
        PreparedStatement sql; 
        Register reg=new Register(); 
        request.setAttribute("register",reg);
        String logname=request.getParameter("logname").trim(),
        password=request.getParameter("password").trim(),
        advertiseTitle=request.getParameter("advertiseTitle").trim(),
        email=request.getParameter("email").trim(),
        phone=request.getParameter("phone").trim(),
        message=request.getParameter("message");
         String uri="jdbc:sqlserver://192.168.1.222:1433;DatabaseName=Friend";
        if(logname==null)
           logname="";
        if(password==null)
           password="";
        boolean isLD=true;
        for(int i=0;i<logname.length();i++)
        {  char c=logname.charAt(i);
           if(!((c<='z'&&c>='a')||(c<='Z'&&c>='A')||(c<='9'&&c>='0'))) 
             isLD=false;
        } 
        boolean boo=logname.length()>0&&password.length()>0&&isLD;
        String backNews="";
        try{ con=DriverManager.getConnection(uri,"sa","sa");
             String insertCondition="INSERT INTO member VALUES (?,?,?,?,?,?,?)";
             sql=con.prepareStatement(insertCondition);
             if(boo)
             { sql.setString(1,handleString(logname));
               sql.setString(2,handleString(password));
               sql.setString(3,handleString(advertiseTitle));
               sql.setString(4,phone);
               sql.setString(5,email);
               sql.setString(6,handleString(message));
               sql.setString(7,"public.jpg");
               int m=sql.executeUpdate();
               if(m!=0)
                 {  backNews="注册成功";
                    reg.setBackNews(backNews);
                    reg.setLogname(logname);
                    reg.setPassword(handleString(password));
                    reg.setAdvertiseTitle(handleString(advertiseTitle));
                    reg.setEmail(handleString(email));
                    reg.setPhone(phone);
                    reg.setMessage(handleString(message));
                 }
              }
             else
              {  backNews="信息填写不完整或名字中有非法字符";
                 reg.setBackNews(backNews);  
              }
             con.close();
           }
        catch(SQLException exp)
          {  backNews="该会员名已被使用，请您更换名字"+exp;
             reg.setBackNews(backNews); 
          }
        RequestDispatcher dispatcher= 
request.getRequestDispatcher("showRegisterMess.jsp");//转发
        dispatcher.forward(request, response);
    }
   public  void  doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
    {   doPost(request,response);
    }
}