searchsingle.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: member
 *
 */
 public class searchSingle 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 searchSingle() {
		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(true);
		
		userBean uber = (userBean)session.getAttribute("uber"); //get session bean
		if (uber == null) { uber = new userBean(); }//set a new bean object
		else ;
		roomBean rmb = (roomBean)session.getAttribute("rmb"); // get session
		bookBean bb=(bookBean)session.getAttribute("bb");// bean
		if (rmb == null) { rmb = new roomBean(); }// set a new bean object
		else ;
		if (bb == null) { bb = new bookBean(); }// 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 ;
		
		
		String ID=request.getParameter("ID");
		String username=request.getParameter("username");
		String type="default";
		String query="default";
		boolean flag=false;
		if (ID.substring(0, 3).equals("pay"))
		{
			type="Payment";
		}
		else if (ID.substring(0, 3).equals("rep"))
		{
			type="Report";
		}
		else if (ID.substring(0, 2).equals("bl"))
		{
			type="Bill";
		}
		else if (ID.substring(0, 2).equals("bk"))
		{
			type="Booking";
		}
		else response.sendRedirect("error.jsp");
		query="select related_id from History where processor='"+username+"' and related_id='"+ID+"'";
		insert in=new insert();
		String res=in.getQuery(query, "related_id");
		if (res.equals(null))
		{
			flag=false;
		}
		else flag=true;
		if (flag==false)
        {
        	response.sendRedirect("error.jsp");
        }
        else ;
		try{
			
        	int rowNum=0;
			query="select * from "+type+" where ID='"+ID+"';";
			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);
            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\"> 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("} td {text-align:center;width:25%;}i {text-decoration:inherit;table-layout:auto;}tr.title {font-size:18px;}");
				out.println("tr.column{font-size:16px;}.column{border-bottom-color:#990099;border-bottom-style:solid;}--></style>");
				out.println("</head>");
				out.println("<body>");
				out.println("<table style=\"width:100%;\">");
				out.println("<tr class=\"title\"><td colspan=\""+colNum+"\"><i>Result Details -- ID: "+data[1][0]+"</i></td></tr>");
				out.println("<tr class=\"column\">");
				
				for(int i=1;i<(colNum);i++)
				{
					out.println("<td>"+data[0][i]+"</td>");
				}
				out.println("</tr>");
				out.println("<tr><td colspan=\""+colNum+"\"><hr class=\"column\" /></td></tr><tr>");
				for (int i=1;i<(rowNum+1);i++)
				{
						for (int k=1;k<colNum;k++)
						{
							out.println("<td>");
							out.println(data[i][k]);
							out.println("</td>");
						}
						
						out.println("<td>");
						out.println("</td>");
						out.println("</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 information available...  ");
            out.println("<input type=\"button\" value=\"Back...\" onClick=\"history.back()\" />");
			out.println("</body></html>");
        }
        catch (Exception e) {
            out.println("Error!:  "+e.getCause()+"  |  "+e.getStackTrace()+"  |  "+e.getMessage());
            response.sendRedirect("error.jsp");
        }
		
		
		
	}   	  	  
	
	/* (non-Javadoc)
	 * @see javax.servlet.GenericServlet#init()
	 */
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}   
	public String hash(String i)
	{
		String hashed="";
		String key1="", key2="", key3="", key4="", key5="";
		
		
		//definition
		
		//token 1
		return hashed;
	}
}