regadv.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.Statement;

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

import servlet.insert;

/**
 * Servlet implementation class for Servlet: login
 *
 */
 public class regAdv 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;
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public regAdv() {
		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();
        String name=(String) session.getAttribute("username");
        String password=(String) session.getAttribute("password");
        
        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();
		
		username=request.getParameter("username");
		password=request.getParameter("password");
        
        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) {
                uber.setMessage("Please input your username!");
                response.sendRedirect("memberZone.jsp");
            } else if(username.equals("default")) {
            	uber.setMessage("Invaild user name!");
            	response.sendRedirect("memberZone.jsp");
            } else if (password.length()<8) {
                uber.setMessage("Too short password!At least 8 characters!");
                response.sendRedirect("memberZone.jsp");
            } else if (rs.next()) {
                if (rs.getString("username").equals(username)) {
                    uber.setMessage("Existed user!");
                    response.sendRedirect("memberZone.jsp");
                } else {
                    query="insert into User (username,password,type) values ('".concat(username).concat("','").concat(password).concat("','").concat("2").concat("');");
                    in.conn(query);
                    uber.setMessage("Success");
                    session.removeAttribute("password");
                    session.removeAttribute("username");
                    uber.setUsername(name);
                    response.sendRedirect("controlPanel.jsp");
                }
            } else {
                query="insert into User (username,password,type) values ('".concat(username).concat("','").concat(password).concat("','").concat("2").concat("');");
                in.conn(query);
                uber.setMessage("Success");
                session.removeAttribute("password");
                session.removeAttribute("username");
                uber.setUsername(name);
                response.sendRedirect("controlPanel.jsp");
            }
            
            
            rs.close();
            stmt.close();
            conn.close();
        }catch (Exception e) {
            out.println("Error 1st result set!"+e.getCause());
            
        }
        
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}