cancel.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 cancel extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public cancel() {
		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();
        userBean uber = (userBean)session.getAttribute("uber"); //get session bean
		if (uber == null) { uber = new userBean(); }//set a new bean object
		else ;
		insert in=new insert();
        String id;
        String mess;
        if (request.getParameter("id")==null || request.getParameter("id").equals(null))
        {
        	id="0";
        }
        else 
        {
        	id=request.getParameter("id");
        }
        String sql;
        sql="select close_date from Room where ID IN (select room_id from Booking where ID='"+id+"');";
        
        
        	String room_id="0";
        	sql="select room_id from Booking where ID='"+id+"';";
        	room_id=in.getQuery(sql, "room_id");
        	
	        	sql="select email from User where username IN (select processor from History where related_id='"+id+"');";
	        	
	        	String email="0",name="0";
	        	email=in.getQuery(sql, "email");
	        	name=uber.getUsername();
	        	
	        	sql="delete from Booking where ID='"+id+"'";
	        	in.update(sql);
	        	
	        	sql="delete from History where related_id='"+id+"'";
	        	in.update(sql);
	        	
	        	sql="UPDATE Room SET status ='free' WHERE ID='"+room_id+"';";
	        	in.update(sql);
	        	
	        	postMail pm=new postMail();
	        	pm.setSender("[e-mail]");
	            pm.setReceiver(email);
	            pm.setCancel(id,name);
	            pm.doSend(pm.getTto(), pm.getTtitle(), pm.getTcontent());
	            response.sendRedirect("cancel.jsp");
			
        
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}