update.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 update extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   private String userid,fname,lname,password,password2,gender,dob,email,add,tel,day,mon,year,type,score;
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public update() {
		super();
	} 

	public void destroy() {
		// TODO Auto-generated method stub
		super.destroy();
	}   	

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}  	

	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();
		String query;
		if (rand.equals(inp)) {
            
		
		userid=request.getParameter("username");
		password=request.getParameter("password");
		password2=request.getParameter("password2");
        fname=request.getParameter("fname");
        lname=request.getParameter("lname");
        dob=request.getParameter("dob");
        email=request.getParameter("email");
        add=request.getParameter("address");
        tel=request.getParameter("tel");
        
        
        
      
           
            if (password.equals(password2) || password2.equals(null)) {
                uber.setMessage("New Password can not be the same!");
                response.sendRedirect("update.jsp");
            } else if (fname.length() == 0 || fname.equals("null")) {
                uber.setMessage("Please input your first name!");
                response.sendRedirect("update.jsp");
            }else if (lname.length() == 0 || lname.equals("null")) {
                uber.setMessage("Please input your last name!");
                response.sendRedirect("update.jsp");
                
            }
            else if(dob.equals(null)||dob.equals(" ")||dob.equals(null)||dob.equals(" "))
            {
            	uber.setMessage("Please input your Birthday!");
                response.sendRedirect("update.jsp");
            }
            else if (email.length() == 0 || email.equals("null")) {
                uber.setMessage("Please input your email address!");
                response.sendRedirect("update.jsp");
            } else if (tel.length() == 0 || tel.equals("null")) {
                uber.setMessage("Please input contact method!");
                response.sendRedirect("update.jsp");
            } else 
            {
            	
            }
            	
                    query="update User set password='"+password+"',fname='"+fname+"',lname='"+lname+"',dob='"+dob+"',email='"+email+"',address='"+add+"',tel='"+tel+"' where username='"+userid+"';";
                    in.update(query);
                    uber.setMessage("Success");
                    postMail pm=new postMail();
                    pm.setSender("[e-mail]");
                    pm.setReceiver(email);
                    pm.setUpdate(password);
                    pm.doSend(pm.getTto(), pm.getTtitle(), pm.getTcontent());
                    
                    response.sendRedirect("memberZone.jsp");
            
		}else {
            uber.setMessage("Wrong secure number!");
            response.sendRedirect("update.jsp");
        }
        
	}   	  	  

	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}