handleregister.java

jsp+javabean实现的会员管理系统

package myservlet.control;


import java.sql.*;
import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;

import mybean.data.Register;
public class HandleRegister extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request,response);
	}

	@Override
	protected 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(),
        sex=request.getParameter("sex").trim(),
        email=request.getParameter("email").trim(),
        phone=request.getParameter("phone").trim(),
        message=request.getParameter("message"),
        age=request.getParameter("age").trim();
        String uri="jdbc:mysql://localhost:3306/ComeHere";
        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,"root","wsy5201314");
        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(sex));
          sql.setString(4,age);
          sql.setString(5,phone);
          sql.setString(6,email);
          sql.setString(7,handleString(message));
          sql.setString(8,handleString("image/leg.jpg"));
          int m=sql.executeUpdate();
          if(m!=0)
            {  backNews="注册成功";
               reg.setBackNews(backNews);
               reg.setLogname(logname);
               reg.setPassword(handleString(password));
               reg.setAge(age);
               reg.setSex(handleString(sex));
               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);
	}

	@Override
	public void init(ServletConfig config) throws ServletException {
		super.init(config);
		try{Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public String handleString(String s){
		try{
			byte bb[] =  s.getBytes("iso-8859-1");
			s = new String(bb);
		}catch(Exception ee){}
		return s;
	}
}