📄 queryresult.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'queryResult.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<jsp:useBean id="query" scope="session" class="db.DBCon" />
<body background="images/kite.gif">
<style type="text/css">
.class1{
BORDER-LEFT: #999999 ;
BORDER-RIGHT: #999999 ;
BORDER-TOP: #999999 ;
BORDER-BOTTOM: #999999 ;
line-height:120%;
font-size:11pt;
}
</style>
<BR>
<center>
<font size="5" color="#008000">查询结果</font>
<BR>
<br>
</center>
<%request.setCharacterEncoding("gb2312");
String sql = null;
ResultSet rs = null;
String text1 = request.getParameter("text1");
String text2 = request.getParameter("text2");
String text3 = request.getParameter("text3");
String text4 = request.getParameter("text4");
String text5 = request.getParameter("text5");
String list1 = request.getParameter("list1");
String list2 = request.getParameter("list2");
String list3 = request.getParameter("list3");
String list4 = request.getParameter("list4");
String list5 = request.getParameter("list5");
String list6 = request.getParameter("list6");
String list7 = request.getParameter("list7");
String list8 = request.getParameter("list8");
String list9 = request.getParameter("list9");
String check1 = request.getParameter("checkbox1");
String check2 = request.getParameter("checkbox2");
String check3 = request.getParameter("checkbox3");
String check4 = request.getParameter("checkbox4");
String check5 = request.getParameter("checkbox5");
if (check1 == null)
check1 = "=";
if (check2 == null)
check2 = "=";
if (check3 == null)
check3 = "=";
if (check4 == null)
check4 = "=";
if (check5 == null)
check5 = "=";
if (text1.length() != 0) {
sql = "SELECT roomno, class, name, sex, age, certificate, country, arridate, leftdate, guests.remarks, guests.price "
+ "FROM guests, countrycodes, room, roomclass "
+ " WHERE guests.roomcode=room.roomcode and guests.countryno =countrycodes.countryno and room.classno=roomclass.classno and ";
sql += list1 + " " + check1;
if (check1.equals("like"))
sql = sql + " '%" + text1 + "%' ";
else
sql += " '" + text1 + "' ";
if (text2.length() != 0) {
sql += list2 + " " + list3 + " " + check2;
if (check2.equals("like"))
sql += " '%" + text2 + "%' ";
else
sql += " '" + text2 + "' ";
if (text3.length() != 0) {
sql += list4 + " " + list5 + " " + check3;
if (check3.equals("like"))
sql += " '%" + text3 + "%' ";
else
sql += " '" + text3 + "' ";
if (text4.length() != 0) {
sql += list6 + " " + list7 + " " + check4;
if (check4.equals("like"))
sql += " '%" + text4 + "%' ";
else
sql += " '" + text4 + "' ";
if (text5.length() != 0) {
sql += list8 + " " + list9 + " " + check5;
if (check5.equals("like"))
sql += " '%" + text5 + "%' ";
else
sql += " '" + text5 + "' ";
}
}
}
}
else {
if (text5.length() != 0) {
sql += list2 + " " + list9 + " " + check5;
if (check5.equals("like"))
sql += " '%" + text5 + "%' ";
else
sql += " '" + text5 + "' ";
}
}
rs = query.excuteQuery(sql);
%>
<TABLE border="1" width="100%" cellpadding="0" cellspacing="0" class="class1">
<TR>
<TD bordercolor="#008040" bgcolor="#c0c0c0">
房间号
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
房间类型
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
姓名
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
性别
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
年龄
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
证件号
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
国家
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
到达日期
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
拟走日期
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
备注
</TD>
<TD bgcolor="#c0c0c0" bordercolor="#008040">
<P>
房间价格
</P>
</TD>
</TR>
<%while (rs.next()) {
%>
<TR>
<TD>
<%=rs.getString(1)%>
</TD>
<TD>
<%=rs.getString(2)%>
</TD>
<TD>
<%=rs.getString(3)%>
</TD>
<TD>
<%=rs.getString(4)%>
</TD>
<TD>
<%=rs.getString(5)%>
</TD>
<TD>
<%=rs.getString(6)%>
</TD>
<TD>
<%=rs.getString(7)%>
</TD>
<TD>
<%=rs.getString(8)%>
</TD>
<TD>
<%=rs.getString(9)%>
</TD>
<TD>
<%=rs.getString(10)%>
</TD>
<TD>
<%=rs.getString(11)%>
</TD>
</TR>
<%}
} else {
%>
<SCRIPT>
alert("请检查输入");
history.back();
</SCRIPT>
<%}
%>
</TABLE>
<form method="POST" action="combinQuery.jsp">
<P align="center">
<INPUT type="submit" name="button1" value="返回">
</P>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -