实现用户登陆的Servlet

最近一直忙着做毕业设计,虽然功能是实现了,但感觉做的很烂,很多东西都没考虑到,也管不了那么多了,先把学校应付过去再说吧!毕竟还是有点收获,对即将的工作有点益处吧!!

package shop;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.Collection;
import javax.sql.*;
import shop.User;

public class RegistServlet extends HttpServlet{
  
 public void init(ServletConfig conf) throws ServletException {
 
  super.init(conf);
 }
 
 public void doGet(HttpServletRequest request,
        HttpServletResponse response)throws IOException,ServletException{
         
        String username=request.getParameter("username");
        String password=request.getParameter("password");
        String realname=request.getParameter("realname");
        String address=request.getParameter("address");
        String mail=request.getParameter("mail");
        String email=request.getParameter("email");
        User user=check(username);
         if(user==null){
         if(regist(username,password,realname,address,mail,email)!=0){
          
              response.sendRedirect("/jsp/success.jsp");
            }else{
              response.sendRedirect("/jsp/regist_error.jsp");
            }
        }else{
           response.sendRedirect("/jsp/already_regist.jsp");
        }
                     

            
 }
    public void doPost(HttpServletRequest request,
        HttpServletResponse response)throws IOException,ServletException{
         
         doGet(request,response);
 }
 public static Connection connection(){
  
           Connection con=null;
     try{
      Class.forName("org.gjt.mm.mysql.Driver");
         con=DriverManager.getConnection("jdbc:mysql://localhost/store?user=root&useUnicode=true&characterEncoding=8859_1");
                                                           
     }catch(SQLException ex){
      
      ex.printStackTrace();
     }catch(ClassNotFoundException e){
      e.printStackTrace();
     }
      return con;
       
  
 }
 public static User check(String username){
  Connection con=null;
  Statement st=null;
  ResultSet rs=null;
  
     try{
      con=connection();
         st=con.createStatement();
         rs=st.executeQuery("select * from customer where username='"+username+"'");
               while(rs.next()){
       User user=new User();
       user.setName(rs.getString(2));
       user.setPass(rs.getString(3));
       user.setReal(rs.getString(4));
       user.setAddr(rs.getString(5));
       user.setMail(rs.getString(6));
       user.setEmail(rs.getString(7));
       return user; 
      } 
     }catch(Exception e){
      e.printStackTrace();
     }finally{
        try{
         con.close();
        }catch(Exception e){
         e.printStackTrace();
        }
       }
  return null;
 }
 public static int regist(String username,String password,String realname,String address,String mail,String email){
   
     Statement st=null;
     Connection con=null;
     ResultSet rs=null;
     int i=0;
          try{
             con=connection();
             st=con.createStatement();
          i=st.executeUpdate("insert into customer(username,password,realname,address,mail,email) values('"+
                          username+"','"+password+"','"+realname+"','"+address+"','"+mail+"','"+email+"')");  
                   return i;     
               }catch(SQLException ex){
          ex.printStackTrace();
      }finally{
        try{
         con.close();
        }catch(Exception e){
         e.printStackTrace();
        }
       }
       return i;
   }
}