📄 multisearchclient_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 multisearchclient_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("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n");
out.write("<html xmlns=\"http://www.w3.org/1999/xhtml\">\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 {font-size: 24px}\r\n");
out.write("-->\r\n");
out.write("</style>\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("<p> </p>\r\n");
out.write("<form name=\"f\" method=\"post\" action=\"multisearchclient.jsp\">\r\n");
out.write("<table width=\"431\" height=\"357\" border=\"1\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#0000CC\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"133\" height=\"17\" bgcolor=\"#0066CC\"><div align=\"center\" class=\"STYLE1\"></div></td>\r\n");
out.write(" <td width=\"146\"><span class=\"STYLE1\">客人组合查询</span></td>\r\n");
out.write(" <td height=\"17\" bgcolor=\"#0066CC\"> </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"22\" colspan=\"3\">查询\r\n");
out.write(" <label>\r\n");
out.write(" <select name=\"select\">\r\n");
out.write(" <option value=\"selected\" selected=\"selected\">请选择</option>\r\n");
out.write(" <option value=\"name\">姓名</option>\r\n");
out.write(" <option value=\"sex\">性别</option>\r\n");
out.write(" <option value=\"arridata\">抵达日期</option>\r\n");
out.write(" <option value=\"leadata\">拟走日期</option>\r\n");
out.write(" </select>\r\n");
out.write(" <select name=\"select2\">\r\n");
out.write(" <option value=\"selected\">请选择</option>\r\n");
out.write(" <option value=\"=\">=</option>\r\n");
out.write(" <option value=\",\">,</option>\r\n");
out.write(" <option value=\"*\">*</option>\r\n");
out.write(" <option value=\"like\">like</option>\r\n");
out.write(" </select>\r\n");
out.write(" <input name=\"textfield\" type=\"text\" size=\"15\" />\r\n");
out.write(" <input name=\"Submit\" type=\"submit\" value=\"确定\" />\r\n");
out.write(" <input name=\"reset\" type=\"reset\" value=\"取消\" />\r\n");
out.write(" </label></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"179\" colspan=\"2\"><p>组合查询条件<br />\r\n");
out.write(" <br />\r\n");
out.write(" <textarea name=\"textarea\" cols=\"28\" rows=\"14\"></textarea>\r\n");
out.write(" \r\n");
out.write(" </p> </td>\r\n");
out.write(" <td width=\"130\"><label>\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <input name=\"（\" type=\"button\" value=\"(\" />\r\n");
out.write(" <input name=\"）\" type=\"button\" value=\")\" />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <input name=\"or\" type=\"button\" value=\"or\" />\r\n");
out.write(" <input name=\"and\" type=\"button\" value=\"and\" />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <input name=\"not\" type=\"button\" value=\"not\" />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <input name=\"reset2\" type=\"reset\" value=\"清空\" />\r\n");
out.write(" <input name=\"Submit8\" type=\"submit\" value=\"查询\" />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write(" </label></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"95\" colspan=\"3\">\r\n");
out.write(" <table width=\"400\" 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=\"40\"><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 ";
String select=request.getParameter("select");
if(select!=null&&select.compareTo("selected")!=0){
ResultSet rs=conn.executeQuery("select * from guests;");
// 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=\"40\" 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("</table></td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write("</form>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} 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 + -