register.java

小型简单的旅馆预订系统. 客户:预定,更改,撤销,会员积分累积,查询预定,会员. 后台:会员更改,房间更改,预定更改,预定信息统计.

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import servlet.userBean;

import servlet.insert;

/**
 * Servlet implementation class for Servlet: login
 *
 */
 public class register extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   private String username,fname,lname,password,password2,gender,dob,email,add,tel,day,mon,year,type,score;
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public register() {
		super();
	} 
	
	/* (non-Javadoc)
	 * @see javax.servlet.Servlet#destroy()
	 */
	public void destroy() {
		// TODO Auto-generated method stub
		super.destroy();
	}   	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}  	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;");
        PrintWriter out=response.getWriter();
        HttpSession session=request.getSession(true);
        String rand = (String)session.getAttribute("rand");
        String inp = request.getParameter("rand");
        
        String pass=request.getParameter("password"); //get request password
		userBean uber = (userBean)session.getAttribute("uber"); //get session bean
		if (uber == null) { uber = new userBean(); }//set a new bean object
		else ;
		insert in=new insert();
		if (rand.equals(inp)) {
            
		
		username=request.getParameter("username");
		password=request.getParameter("password");
		password2=request.getParameter("password2");
        fname=request.getParameter("fname");
        lname=request.getParameter("lname");
        gender=request.getParameter("gender");
        day=request.getParameter("day");
        mon=request.getParameter("month");
        year=request.getParameter("year");
        dob=request.getParameter("day")+"/"+ request.getParameter("month")+"/"+request.getParameter("year");
        email=request.getParameter("email");
        add=request.getParameter("address");
        tel=request.getParameter("tel");
        type="1";
        score="100";
        
        String query;
        
        
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            String driver = "Driver={Microsoft Access Driver (*.mdb)}";
            String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
            String connectionString = "jdbc:odbc:"+driver+";"+dbq;
            Connection conn = DriverManager.getConnection(connectionString);
            Statement stmt = conn.createStatement();
            query = "SELECT * FROM User WHERE username = '" + username + "';";
            ResultSet rs = stmt.executeQuery(query);
            if (username.length()==0||username.equals("null")||username.equals("Temp")) {
                uber.setMessage("Please input your username!");
                response.sendRedirect("reg.jsp");
            } else if(username.equals("default")) {
            	uber.setMessage("Invaild user name!");
            	response.sendRedirect("reg.jsp");
            } else if (password.length()<8 || password.equals(null)) {
                uber.setMessage("Too short password!At least 8 characters!");
                response.sendRedirect("reg.jsp");
            }else if (!password.equals(password2) || password2.equals(null)) {
                uber.setMessage("Re enter your password!");
                response.sendRedirect("reg.jsp");
            } else if (fname.length() == 0 || fname.equals("null")) {
                uber.setMessage("Please input your first name!");
                response.sendRedirect("reg.jsp");
            }else if (lname.length() == 0 || lname.equals("null")) {
                uber.setMessage("Please input your last name!");
                response.sendRedirect("reg.jsp");
                
            }
            else if(year.equals(null)||year.equals(" ")||day.equals(null)||day.equals(" "))
            {
            	uber.setMessage("Please input your Birthday!");
                response.sendRedirect("reg.jsp");
            }
            else if (email.length() == 0 || email.equals("null")) {
                uber.setMessage("Please input your email address!");
                response.sendRedirect("reg.jsp");
            } else if (tel.length() == 0 || tel.equals("null")) {
                uber.setMessage("Please input contact method!");
                response.sendRedirect("reg.jsp");
            } else if (rs.next()) {
                if (rs.getString("username").equals(username)) {
                    uber.setMessage("Existed user!");
                    response.sendRedirect("reg.jsp");
                } else {
                    query="insert into User (username,password,type,fname,lname,gender,dob,email,address,tel,score,status) values ('".concat(username).concat("','").concat(password).concat("','").concat(type).concat("','").concat(fname).concat("','").concat(lname).concat("','").concat(gender).concat("','").concat(dob).concat("','").concat(email).concat("','").concat(add).concat("','").concat(tel).concat("','").concat(score).concat("','").concat("disactive").concat("');");
                    in.update(query);
                    uber.setMessage("Success");
                    session.removeAttribute("username");
                    session.removeAttribute("add");
                    session.removeAttribute("dob");
                    session.removeAttribute("email");
                    session.removeAttribute("fname");
                    session.removeAttribute("lname");
                    session.removeAttribute("gender");
                    session.removeAttribute("tel");
                    postMail pm=new postMail();
                    pm.setSender("[e-mail]");
                    pm.setReceiver(email);
                    pm.setWelcome(username, password);
                    pm.doSend(pm.getTto(), pm.getTtitle(), pm.getTcontent());
                    
                    response.sendRedirect("memberZone.jsp");
                }
            } else {
            	query="insert into User (username,password,type,fname,lname,gender,dob,email,address,tel,score,status) values ('".concat(username).concat("','").concat(password).concat("','").concat(type).concat("','").concat(fname).concat("','").concat(lname).concat("','").concat(gender).concat("','").concat(dob).concat("','").concat(email).concat("','").concat(add).concat("','").concat(tel).concat("','").concat(score).concat("','").concat("disactive").concat("');"); 
                in.update(query);
            	uber.setMessage("Success");
                session.removeAttribute("username");
                session.removeAttribute("add");
                session.removeAttribute("dob");
                session.removeAttribute("email");
                session.removeAttribute("fname");
                session.removeAttribute("lname");
                session.removeAttribute("gender");
                session.removeAttribute("tel");
                postMail pm=new postMail();
                pm.setSender("[e-mail]");
                pm.setReceiver(email);
                pm.setWelcome(username, password);
                pm.doSend(pm.getTto(), pm.getTtitle(), pm.getTcontent());
                response.sendRedirect("memberZone.jsp");
            }
            
            rs.close();
            stmt.close();
            conn.close();
        }
        catch(SQLException e)
        {
        	out.println("Database: Error occur!"+e.getCause());
            out.println("Details: "+e.getStackTrace());
        }
        catch (Exception e) {
            out.println("Other: Error occur!"+e.getCause());
            out.println("Details: "+e.getStackTrace());
        }
		}
		else {
            uber.setMessage("Wrong secure number!");
            response.sendRedirect("reg.jsp");
        }
        
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}