makebill.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.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.sun.corba.se.pept.protocol.ServerRequestDispatcher;

/**
 * Servlet implementation class for Servlet: member
 *
 */
 public class makeBill extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   String booktype,custype,query;
   private double price=0.0,discount=1.0; 
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public makeBill() {
		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("txt/html");
		PrintWriter out=response.getWriter();
		HttpSession session = request.getSession(true); //set session
		
		
		/*read data from request*/
		String billID=request.getParameter("billID");
		String resID=request.getParameter("resID");
		String payID=request.getParameter("payID");
		String price=request.getParameter("price");
		String date=request.getParameter("date");
		String fname=request.getParameter("fname");
		String lname=request.getParameter("lname");
		String dob=request.getParameter("dob");
		String contact=request.getParameter("contact");
		String username=request.getParameter("usern");
		
		getCurrentDate getcd=new getCurrentDate();
		String now=getcd.getDate();//output date
		
		userBean uber = (userBean)session.getAttribute("uber"); //get session bean
		if (uber == null) { uber = new userBean(); }//set a new bean object
		else ;
		
		resBean resb = (resBean)session.getAttribute("resb"); //get session bean
		if (resb == null) { resb = new resBean(); }//set a new bean object
		else ;
		
		payBean pb = (payBean)session.getAttribute("pb"); //get session bean
		if (pb == null) { pb = new payBean(); }//set a new bean object
		else ;
		
		ServletContext context = getServletContext();
		insert in=new insert();
		/*check customer type & book type*/
		String hisID="his"+dateRandString();
		try
		{
			query="insert into Bill (ID,booking_id,pay_id,dt,processor,price,status) values('"+billID+"','"+resID+"','"+payID+"','"+date+"','"+username+"','"+price+"','billed');";
	        in.update(query);
	        query="insert into History (ID,user_id,type,dt,processor,related_id) values ('"+hisID+"','"+uber.getId()+"','bill','"+now+"','"+uber.getUsername()+"','"+billID+"');";
	        in.update(query);
		}
		catch(Exception e)
		{
			out.println("Other1: Error occur!"+e.getCause());
            out.println("Details: "+e.getStackTrace());
            response.sendRedirect("/errorCenter");
		}
		 pb.setPrice(price);
		 pb.setUserID(uber.getId());
		 pb.setDate(date);
		 pb.setStatus("billed");
		 pb.setBillID(billID);
		 pb.setPayID(payID);
		 postMail pm=new postMail();
         pm.setSender("[e-mail]");
         pm.setReceiver(resb.getContact());
         pm.setReservation(uber.getUsername(), resID);
         pm.doSend(pm.getTto(), pm.getTtitle(), pm.getTcontent());
         response.sendRedirect("success.jsp");
		 
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
	String dateRandString()
	{
		getCurrentDate getcd=new getCurrentDate();
		String now=getcd.getDate();
		Die die=new Die();
		String dienum=die.getRandomString();
		String dateran=now.concat(dienum);
		return dateran;
	}
	public String hash(String i)
	{
		String hashed="";
		String key1="", key2="", key3="", key4="", key5="";
		
		
		//definition
		
		//token 1
		return hashed;
	}
}