searchadminroom.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 searchAdminRoom extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public searchAdminRoom() {
		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 roomID=request.getParameter("roomID");
        adminRoomBean arb = (adminRoomBean)session.getAttribute("arb"); //get session bean
		if (arb == null) { arb = new adminRoomBean(); }//set a new bean object
		else ;
		setMemberBean(roomID,session);
		response.sendRedirect("RoomAdmin.jsp");
		insert in=new insert();
		
		
	}  
	
	public void setMemberBean(String roomID,HttpSession session)
	{
		adminRoomBean arb = (adminRoomBean)session.getAttribute("arb"); //get session bean
		if (arb == null) { arb = new adminRoomBean(); }//set a new bean object
		else ;
		String roomType=" ";
		String type=" ";
		try{
				String query="select * from Room where ID='"+roomID+"';";
				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())
	            {
	            	roomType=rs.getString("ID");
	            	arb.setRoomID(roomType);
	            	arb.setDt(rs.getString("dt"));
	            	arb.setItem(rs.getString("item"));
	            	arb.setAvailable(rs.getString("available"));
	            	arb.setStatus(rs.getString("status"));
	            	arb.setPrice(rs.getString("price"));
	            	arb.setClose_date(rs.getString("close_date"));
	            	
	            }
	            if(roomType.split("0")[0].equals("su"))
				{
					type="Superior";
				}
				else if(roomType.split("0")[0].equals("de"))
				{
					type="Deluxe";
				}
				else if(roomType.split("0")[0].equals("cp"))
				{
					type="Club Prestige";
				}
				else if(roomType.split("0")[0].equals("bs"))
				{
					type="1/2 Bedroom Suite";
				}
	            arb.setType(type);
	            rs.close();
	            stmt.close();
	            conn.close();
		}
		catch(SQLException e)
		{
			
		}
		catch(Exception e)
		{
			
		}
	}
}