changeroom.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: searchMember
 *
 */
 public class changeRoom extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public changeRoom() {
		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();
        adminRoomBean arb = (adminRoomBean)session.getAttribute("arb"); //get session bean
		if (arb == null) { arb = new adminRoomBean(); }//set a new bean object
		else ;
		insert in=new insert();
        String score="0",disc="1.0";
        String sco="0";
        int sc=0;
        String roomID=arb.getRoomID();
        String addItem=request.getParameter("add");
        String qty=request.getParameter("qty");
        String item=addItem.concat("*").concat(qty);
        String available=request.getParameter("available");
        String status=request.getParameter("status");
        String price=request.getParameter("price");
        String close_date=request.getParameter("close_date");
        //set all variables
        String query="select * from Room where ID='"+roomID+"';";
        String oldItem=" ";
        if (in.getQuery(query, "item").equals("none"))
        {
        	
        }
        else oldItem=in.getQuery(query, "item");
        
        item=oldItem.concat("|").concat(item);
        
		query="update Room set item='"+item+"',available='"+available+"',status='"+status+"',price="+price+",close_date='"+close_date+"' where ID='"+roomID+"';";
		in.update(query);
		setRoomBean(roomID,session);
		response.sendRedirect("RoomAdmin.jsp");
	}  
	
	public void setRoomBean(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+"';";
				ServletContext context = getServletContext();
	        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
	        	String appDirRoot = context.getRealPath("/");
	        	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)
		{
			
		}
	}
}