searchhistory.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.ResultSetMetaData;
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: searchroom
 * 
 */
 public class searchHistory extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   private String price="0",typ="default";
   private int  pr=0,dlp=0,ulp=0;
    /*
	 * (non-Java-doc)
	 * 
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public searchHistory() {
		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 {
		
	}  	
	
	/*
	 * (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(true);
        roomBean rmb = (roomBean)session.getAttribute("rmb");
        userBean uber = (userBean)session.getAttribute("uber");// get session
		bookBean bb=(bookBean)session.getAttribute("bb");	// bean
		if (rmb == null) { rmb = new roomBean(); }// set a new bean object
		else ;
		if (uber == null) { response.sendRedirect("memberZone.jsp"); }// set a new bean object
		else ;
		String userName=uber.getUsername();
		String userID=uber.getId();
		String query="default";
		typ=request.getParameter("type");
		price=request.getParameter("price");
		String commd=request.getParameter("cmd");
		String searchType="none";
		if (commd.equals("resH"))
		{
			searchType="booking";
		}
		else if (commd.equals("billH"))
		{
			searchType="bill";
		}
		else if (commd.equals("payH"))
		{
			searchType="payment";
		}
		else if (commd.equals("reportH"))
		{
			searchType="report";
		}
		else 
		{
			searchType="Other";
		}
		query = "select ID,dt,type,related_id from history where processor='"+userName+"' and type='"+searchType+"';";
		//determine search type: res,pay,bill,other...
		try
		{
			 int rowNum=0;
			 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.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	         ResultSet rs = stmt.executeQuery(query); //execute query
	         ResultSetMetaData   rm=rs.getMetaData(); 
	         int colNum=rm.getColumnCount();
	         int lp=1;
	         int lop=1;
	         if (!rs.wasNull())
	         {
	        	 if (rs.next())
	        	 {
	        		 for (rs.first(); !rs.isAfterLast(); rs.next())
	        		 {
	        			 rowNum++;
	        		 }// get row number
	        	 }
	         }//determine whether or not the result set is null
				String data[][]=new String[rowNum+2][colNum+1];
				
				
				for (int i=0;i<(colNum);i++)
				{
					data[0][i]=rm.getColumnName(i+1);
				}//get column name
				for (rs.first();!rs.isAfterLast();rs.next())
				{
					
					for (int i=0;i<(colNum);i++)
					{
								data[lop][i]=rs.getString(i+1);
								
					}
					
					lop++;
				}
				//get data from result set
				out.println("<html><head><title>Search Result</title>");
				out.println("<script src=\"inc/back.js\" type=\"text/javascript\"></script>");
				out.println("<link href=\"inc/1.css\" rel=\"stylesheet\" type=\"text/css\"><link href=\"inc/content.css\" rel=\"stylesheet\" type=\"text/css\">");
				out.println("</head>");
				out.println("<body>");
				out.println("<table style=\"width:100%;\">");
				out.println("<tr class=\"title\"><td colspan=\"4\"><i>History Details</i></td></tr>");
				out.println("<tr style=\"color:#FFFFFF;\" bgcolor=\"#990033\"><td><i>History ID</i></td><td><i>Date</i></td><td><i>History Type</i></td><td>Related ID</td><td></td></tr>");
				out.println("<tr><td height=\"10\" colspan=\"10\"></td></tr>");
				out.println("<tr><td colspan=\"4\"><hr class=\"column\"/></td></tr>");
				
				for (int i=1;i<(rowNum+1);i++)
				{
						out.println("<form action=\"viewHistory\" method=\"post\">");
						out.println("<tr><td>");
						out.println(data[i][0]);
						out.println("</td><td>");
						out.println(data[i][1]);
						out.println("</td><td>");
						out.println(data[i][2]);
						out.println("</td><td>");
						out.println(data[i][3]);
						out.println("</td>");
						out.println("<td>");
						out.println("<input type=\"hidden\" name=\"his_id\" value=\""+data[i][0]+"\" checked /> ");
						out.println("<input type=\"hidden\" name=\"date\" value=\""+data[i][1]+"\" checked /> ");
						out.println("<input type=\"hidden\" name=\"type\" value=\""+data[i][2]+"\" checked /> ");
						out.println("<input type=\"hidden\" name=\"rel_id\" value=\""+data[i][3]+"\" checked /> ");
						out.println("<input type=\"submit\" value=\"Details...\" /></td></tr>");
						out.println("<form action=\"viewHistory\" method=\"post\">");
						out.println("<tr><td colspan=\"4\"><hr class=\"column\"/></td></tr>");
				}//output all data
				out.println("</table>");
	            out.println("<input type=\"button\" value=\"Back...\" onClick=\"history.back()\" />");
	            out.println("</body></html>");
				//output page

	         rs.close();
	         stmt.close();
	         conn.close();
		}
		catch(SQLException e)
        {
        	out.println("<html><head><title>Search Result</title>");
			out.println("<script src=\"inc/back.js\" type=\"text/javascript\"></script>");
			out.println("<script language=\"javascript\" type=\"text/javascript\"> var bLoadComplete = false;window.onload = f_iframeResize;  </script>");
			out.println("<style type=\"text/css\"><!--body {font-family: Arial, Helvetica, sans-serif;font-size: 12px;");
			out.println("color: #0099FF;text-decoration: blink;background-color: transparent;border: none;");
			out.println("}--></style>");
			out.println("</head>");
			out.println("<body>");
			out.println("Sorry,there is no more History available...  ");
            out.println("<input type=\"button\" value=\"Back...\" onClick=\"history.back()\" />");
			out.println("</body></html>");
			//go to null result set page
        }
        catch (Exception e) {
            out.println("Other: Error occur!"+e.getCause());
            out.println("Details: "+e.getStackTrace());
        } //other error detector
        
		
	}   	  	  
	
	/*
	 * (non-Javadoc)
	 * 
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
}