📄 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("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<title>简单客人查询</title>\r\n");
out.write("<style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write(".style1 {\r\n");
out.write("\tfont-size: 16px;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write(".STYLE5 {font-size: 24px; font-weight: bold; }\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write("\r\n");
out.write("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write(" <td width=\"127\"> <form name=\"form1\" method=\"post\" action=\"index.jsp\">\r\n");
out.write(" <input type=\"submit\" name=\"Submit4\" value=\" 返回首页 \">\r\n");
out.write(" </form>\r\n");
out.write(" </td>\r\n");
out.write("<form name=\"form1\" method=\"post\" action=\"searchclient.jsp\">\r\n");
out.write("<p> </p>\r\n");
out.write("<table width=\"331\" height=\"218\" border=\"1\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#0000CC\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"110\" height=\"24\" bgcolor=\"#0066CC\"><div align=\"center\" class=\"STYLE5\"></div></td>\r\n");
out.write(" <td width=\"105\"><span class=\"STYLE5\">客人查询</span></td>\r\n");
out.write(" <td width=\"108\" height=\"24\" bgcolor=\"#0066CC\"> </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"190\" colspan=\"3\"><p>查询条件：<br>\r\n");
out.write(" <br>\r\n");
out.write(" 姓名：\r\n");
out.write(" <input type=\"text\" name=\"name\">\r\n");
out.write(" </p>\r\n");
out.write(" <p>性别： \r\n");
out.write(" <input type=\"radio\" name=\"sex\" value=\"男\">\r\n");
out.write(" 男\r\n");
out.write("\t\t<input type=\"radio\" name=\"sex\" value=\"女\">\r\n");
out.write(" 女</p>\r\n");
out.write(" <p>抵达日期：<input type=\"text\" name=\"arridate\"></p>\r\n");
out.write(" <p>房间号： \r\n");
out.write(" <input type=\"text\" name=\"roomcode\">\r\n");
out.write(" </p>\r\n");
out.write(" <p>\r\n");
out.write(" <input type=\"submit\" name=\"Submit\" value=\"提交\">\r\n");
out.write(" <input type=\"submit\" name=\"Submit\" value=\"退房\">\r\n");
out.write(" <input type=\"submit\" name=\"Submit\" value=\"换房\">\r\n");
out.write(" </p> </td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write("\r\n");
out.write("</form>\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("<hr>请输入查询信息");}
else{
out.print("您所查信息如下:");
out.println("姓名:"+code.toGB(name)+" 性别:"+code.toGB(sex)+" 抵达日期:"+arridate+" 房间号:"+roomcode);
out.write("\r\n");
out.write(" <table width=\"500\" border=\"1\" align=\"center\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"79\"><div align=\"center\">房号</div></td>\r\n");
out.write(" <td width=\"77\"><div align=\"center\">姓名</div></td>\r\n");
out.write(" <td width=\"67\"><div align=\"center\">性别</div></td>\r\n");
out.write(" <td width=\"80\"><div align=\"right\">抵达日期</div></td>\r\n");
out.write(" <td width=\"83\"><div align=\"center\">拟走日期</div></td>\r\n");
out.write(" </tr>\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<tr>\r\n");
out.write(" \t\t\t\r\n");
out.write(" \t\t\t\t <td width=\"79\" align=center>");
out.print(rs.getObject(1));
out.write("</td>\r\n");
out.write(" \t\t\t\r\n");
out.write(" <td width=\"77\"align=center>");
out.print(rs.getObject(2));
out.write("</td>\r\n");
out.write(" <td width=\"67\" align=center>");
out.print(rs.getObject(3));
out.write("</td>\r\n");
out.write(" <td width=\"80\"align=center>");
out.print(rs.getObject(7));
out.write("</td>\r\n");
out.write(" <td width=1\"83\" align=center>");
out.print(rs.getObject(8));
out.write("</td>\r\n");
out.write(" <tr>\r\n");
out.write(" \r\n");
out.write(" ");
}
rs.close();
conn.close();}}
out.write("\r\n");
out.write("\r\n");
out.write("</table>\r\n");
out.write("</body>\r\n");
out.write("</html>");
} 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);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -