findout.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.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class for Servlet: login
 *
 */
 public class findout extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public findout() {
		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 score="0",disc="1.0";
        String sco="0";
        int sc=0;
        String username=request.getParameter("username");
        String fname=request.getParameter("fname");
        String lname=request.getParameter("lname");
        String password=request.getParameter("password");
		userBean uber = (userBean)session.getAttribute("uber");
		if (uber == null) { uber = new userBean(); }//set a new bean object
		else ;
		
		insert in=new insert();
		
		String query;
		query="select * from User where username='"+username+"';";
		String oldP=in.getQuery(query, "password");
		String oldfname=in.getQuery(query, "fname");
		String oldlname=in.getQuery(query, "lname");
		if (oldP.equals(null)||oldP==null)
		{
			uber.setMessage("No such User!");
			response.sendRedirect("forget.jsp");
		}
		else if(!password.equals(oldP))
		{
			uber.setMessage("Wrong Hashed Code!");
			response.sendRedirect("forget.jsp");
		}
		else if(!oldfname.equals(fname))
		{
			uber.setMessage("Wrong First Name!");
			response.sendRedirect("forget.jsp");
		}
		else if(!oldlname.equals(lname))
		{
			uber.setMessage("Wrong Last Name!");
			response.sendRedirect("forget.jsp");
		}
		else
		{
			uber.setUsername(in.getQuery(query, "username"));
			uber.setAdd(in.getQuery(query, "address"));
			uber.setDob(in.getQuery(query, "dob"));
			uber.setEmail(in.getQuery(query, "email"));
			uber.setFname(in.getQuery(query, "fname"));
			uber.setLname(in.getQuery(query, "lname"));
			uber.setGender(in.getQuery(query, "gender"));
			uber.setTel(in.getQuery(query, "tel"));
			response.sendRedirect("update2.jsp");
		}
       
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}