bookroom.java

酒店管理系统

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javabean.Customer;

import javax.servlet.ServletException;
import javax.servlet.http.*;

import database.connectDB;

public class BookRoom extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public BookRoom() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		response.setContentType("text/html;charset=GBK");
		PrintWriter out = response.getWriter();
		
		String roomID = request.getParameter("roomID");
		String orderMoney = request.getParameter("orderMoney");
		String orderTime = request.getParameter("orderTime");
		String arriveTime = request.getParameter("arriveTime");
		String lodgingTime = request.getParameter("lodgingTime");	
		
		HttpSession session = request.getSession();
		Customer customer = (Customer)session.getAttribute("customer");
        String identifierID = customer.getIdentifierID();
        if(roomID.equals("")){
        	out.print("<center>");
        	out.print("房间号不能为空！");
        }else {
        	connectDB con = new connectDB();
        	String sql2 = "select * from room where roomID ='"+roomID+"' and roomState='净房可用'";
        	con.excuteQuery(sql2);
        	if(!con.next()){
        		out.print("<center>");
            	out.print("房间不可用！");
        	}else{
        		try{
			//String sql = "insert into orderInfo values('111','301','50','2007-9-1','2007-9-2','3')";
			String sql="insert into orderInfo values('"+identifierID+"','"+roomID+"','"+orderMoney+"','"+orderTime+"','"+arriveTime+"','"+lodgingTime+"');";
			con.excuteUpdate(sql);
			
			String sql1 = "update room set roomState = '净房占用' where roomID = '"+roomID+"';";
			con.excuteQuery(sql1);
			out.print("<center>");
			out.print("预定成功！");
			}
		catch(Exception e)
		{e.printStackTrace();}} }
		out.print("<br>");
		out.println("<a href='room_list.jsp'>");
		out.println("如果没有跳转，请点击这里！");
		out.print("<meta http-equiv='refresh' content='2 url=/hotel/room_list.jsp' >");

	}

/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}

}