searchmember.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;

/**
 * Servlet implementation class for Servlet: searchMember
 *
 */
 public class searchMember extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public searchMember() {
		super();
	}   	
	
	/* (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 userID=request.getParameter("userID");
        adminMemberBean admb = (adminMemberBean)session.getAttribute("admb"); //get session bean
		if (admb == null) { admb = new adminMemberBean(); }//set a new bean object
		else ;
		setMemberBean(userID,session);
		response.sendRedirect("MemberAdmin.jsp");
		insert in=new insert();
		String query="select count(ID) as total from User;";
		admb.setTotal(in.getQuery(query, "total"));
	}  
	
	public void setMemberBean(String userID,HttpSession session)
	{
		adminMemberBean admb = (adminMemberBean)session.getAttribute("admb"); //get session bean
		if (admb == null) { admb = new adminMemberBean(); }//set a new bean object
		else ;
		try{
				String query="select * from User where ID="+userID+"";
				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();
	            ResultSet rs=stmt.executeQuery(query);
	            if (rs.next())
	            {
	            	admb.setId(rs.getString("ID"));
	            	admb.setUsername(rs.getString("username"));
	            	admb.setPassword(rs.getString("password"));
	            	admb.setType(rs.getString("type"));
	            	admb.setFname(rs.getString("fname"));
	            	admb.setLname(rs.getString("lname"));
	            	admb.setGender(rs.getString("gender"));
	            	admb.setDob(rs.getString("dob"));
	            	admb.setEmail(rs.getString("email"));
	            	admb.setAdd(rs.getString("address"));
	            	admb.setTel(rs.getString("tel"));
	            	admb.setScore(rs.getString("score"));
	            	admb.setOperator(rs.getString("confirm_id"));
	            	admb.setLast_login(rs.getString("last_login"));
	            	admb.setStatus(rs.getString("status"));
	            }
	            rs.close();
	            stmt.close();
	            conn.close();
		}
		catch(SQLException e)
		{
			
		}
		catch(Exception e)
		{
			
		}
	}
}