www.pudn.com > Hotel.rar > searchclient_jsp.java

package org.apache.jsp; 
 
import javax.servlet.*; 
import javax.servlet.http.*; 
import javax.servlet.jsp.*; 
import java.sql.*; 
import myhotel.MyConn; 
import codechange.Codechange; 
 
public final class searchclient_jsp extends org.apache.jasper.runtime.HttpJspBase 
    implements org.apache.jasper.runtime.JspSourceDependent { 
 
  private static java.util.List _jspx_dependants; 
 
  public Object getDependants() { 
    return _jspx_dependants; 
  } 
 
  public void _jspService(HttpServletRequest request, HttpServletResponse response) 
        throws java.io.IOException, ServletException { 
 
    JspFactory _jspxFactory = null; 
    PageContext pageContext = null; 
    HttpSession session = null; 
    ServletContext application = null; 
    ServletConfig config = null; 
    JspWriter out = null; 
    Object page = this; 
    JspWriter _jspx_out = null; 
    PageContext _jspx_page_context = null; 
 
 
    try { 
      _jspxFactory = JspFactory.getDefaultFactory(); 
      response.setContentType("text/html; charset=gb2312"); 
      pageContext = _jspxFactory.getPageContext(this, request, response, 
      			"", true, 8192, true); 
      _jspx_page_context = pageContext; 
      application = pageContext.getServletContext(); 
      config = pageContext.getServletConfig(); 
      session = pageContext.getSession(); 
      out = pageContext.getOut(); 
      _jspx_out = out; 
 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("  
\r\n"); 
      out.write("     \r\n"); 
      out.write("     
\r\n"); 
      out.write("     \r\n"); 
      out.write("
\r\n"); 
      out.write("
 
\r\n"); 
      out.write("\r\n"); 
      out.write("  \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("  \r\n"); 
      out.write("  \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("
客人查询
 
查询条件：
\r\n"); 
      out.write("      
\r\n"); 
      out.write("        姓名：\r\n"); 
      out.write("            \r\n"); 
      out.write("            
\r\n"); 
      out.write("      
性别：  \r\n"); 
      out.write("        \r\n"); 
      out.write("        男\r\n"); 
      out.write("\t\t\r\n"); 
      out.write("      女
\r\n"); 
      out.write("      
抵达日期：
\r\n"); 
      out.write("      
房间号： \r\n"); 
      out.write("        \r\n"); 
      out.write("      
\r\n"); 
      out.write("    
\r\n"); 
      out.write("      \r\n"); 
      out.write("       \r\n"); 
      out.write("        \r\n"); 
      out.write("    
      
\r\n"); 
      out.write("\r\n"); 
      out.write("
\r\n"); 
      out.write(" "); 
 
  String name=request.getParameter("name"); 
  String sex=request.getParameter("sex"); 
 
   String arridate=request.getParameter("arridate"); 
    String roomcode=request.getParameter("roomcode"); 
  Codechange code=new Codechange(); 
  boolean suffix=false; 
 
      if(name==null&&sex==null&&arridate==null&&roomcode==null){ out.println("
请输入查询信息");} 
 
        else{ 
          
      
             out.print("您所查信息如下:"); 
             out.println("姓名:"+code.toGB(name)+" 性别:"+code.toGB(sex)+" 抵达日期:"+arridate+" 房间号:"+roomcode); 
      
 
      out.write("\r\n"); 
      out.write(" \r\n"); 
      out.write("  \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("    \r\n"); 
      out.write("  \r\n"); 
      out.write("\r\n"); 
      out.write("  \t\t"); 
	 
               MyConn conn=new MyConn(); 
               String sqlstr="select * from guests where "; 
               if(name.length()!=0) 
               { 
                sqlstr+="name like '"+code.toGB(name)+"'"; 
                suffix=true; 
               } 
           
              if(sex!=null) 
               { 
                 if(suffix)sqlstr+=" and sex='"+code.toGB(sex)+"'"; 
                 else{sqlstr+=" sex='"+code.toGB(sex)+"'";suffix=true;} 
               } 
                     if(arridate.length()!=0){ 
                //java.sql.Date ad=java.sql.Date.valueOf(arridate); 
                if(suffix)sqlstr+=" and arridate='"+arridate+"'"; 
                else{suffix=true; sqlstr+=" arridate='"+arridate+"'";} 
             } 
             if(roomcode.length()!=0){ 
                if(suffix)sqlstr+=" and roomcode='"+roomcode+"'"; 
                else {suffix=true;sqlstr+=" roomcode='"+roomcode+"'";} 
             } 
              if(suffix==false){} 
             else{ 
             ResultSet rs=conn.executeQuery(sqlstr); 
         
          // ResultSet rs=conn.executeQuery("select roomcode,name,sex,arridate,leftdate from guests where name like '%"+code.toGB(name)+"%';"); 
 	          
     		while(rs.next()){ 
      out.write("\r\n"); 
      out.write(" \t\t\t\t\r\n"); 
      out.write(" \t\t\t\r\n"); 
      out.write(" \t\t\t\t   \r\n"); 
      out.write(" \t\t\t\r\n"); 
      out.write("                  \r\n"); 
      out.write("                     \r\n"); 
      out.write("                    \r\n"); 
      out.write("                    \r\n"); 
      out.write("   \r\n"); 
      out.write("                              \r\n"); 
      out.write("                "); 
 }  
                rs.close(); 
                conn.close();}} 
      out.write("\r\n"); 
      out.write("\r\n"); 
      out.write("
房号
姓名
性别
抵达日期
拟走日期
"); 
      out.print(rs.getObject(1)); 
      out.write("
"); 
      out.print(rs.getObject(2)); 
      out.write("
"); 
      out.print(rs.getObject(3)); 
      out.write("
"); 
      out.print(rs.getObject(7)); 
      out.write("
"); 
      out.print(rs.getObject(8)); 
      out.write("
\r\n"); 
      out.write("\r\n"); 
      out.write(""); 
    } catch (Throwable t) { 
      if (!(t instanceof SkipPageException)){ 
        out = _jspx_out; 
        if (out != null && out.getBufferSize() != 0) 
          out.clearBuffer(); 
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); 
      } 
    } finally { 
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context); 
    } 
  } 
}