📄 general.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page import="java.sql.*"%>
<html>
<head>
<base href="<%=basePath%>">
<title>index</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="general" scope="session" class="db.DBCon" />
<body background="images/kite.gif">
<jsp:useBean id="listDB" scope="session" class="db.DBCon" />
<P>
请选择入住房间类型：
<BR>
</P>
<%String sql_lst = "select class from roomclass";
ResultSet rs_lst = null;
listDB.connect("jdbc:odbc:restaurant");
rs_lst = listDB.excuteQuery(sql_lst);
%>
<form name="form1" method="post" action="general.jsp">
<SELECT name="list1" size="4" style="width:90">
<%while (rs_lst.next()) {
String value = rs_lst.getString(1);
%>
<option value="<%=value%>">
<%=value%>
</option>
<%}
rs_lst.close();
%>
</SELECT>
<P>
房间详细说明：
</P>
<TABLE border="1" width="600px">
<TR align="center" valign="middle" bgcolor="#F9F9FB">
<TD>
类型
</TD>
<TD>
房价
</TD>
<TD width="75px">
<P>
床位数
</P>
</TD>
<TD width="200px">
<P align="center">
备注
</P>
</TD>
<TD>
总房数
</TD>
<TD>
可租房数
</TD>
</TR>
<%String sql = "select class,price,beds,remarks from roomclass";
ResultSet rs = null;
try {
String action = null;
String select = null;
String temp1 = request.getParameter("action");
String temp2 = request.getParameter("list1");
if (temp1 != null)
action = new String(temp1.getBytes("iso-8859-1"), "gb2312");
if (temp2 != null)
select = new String(temp2.getBytes("iso-8859-1"), "gb2312");
if (action.equals("全部房类查询")) {
rs = listDB.excuteQuery(sql);
} else if (action.equals("选中房类查询")) {
if (select != null) {
sql += " where class='" + select + "'";
rs = listDB.excuteQuery(sql);
}
}
} catch (Exception e) {
}
if (rs != null) {
while (rs.next()) {
String roomclass=rs.getString(1);
%>
<TR align="center" valign="middle" bgcolor="#09F988">
<TD>
<%=roomclass%>
</TD>
<TD>
<%=rs.getString(2)%>
</TD>
<TD>
<%=rs.getString(3)%>
</TD>
<TD>
<%=rs.getString(4)%>
</TD>
<TD>
<%=general.roomclassnum(roomclass)%>
</TD>
<TD>
<%=general.emptyroomnum(roomclass)%>
</TD>
</TR>
<%}
rs.close();
listDB.close();
} else {
%>
<TR align="center" valign="middle" bgcolor="#F9F900">
<TD width="100%" colspan="6">
没有记录
</TD>
</tr>
<%}
%>
</TABLE>
<P>
<INPUT type="submit" name="action"
style="BACKGROUND-COLOR: #5971b4; BORDER-BOTTOM: #000875 1px solid; BORDER-LEFT: #9aa3ff 1px solid; BORDER-RIGHT: #000875 1px solid; BORDER-TOP: #9aa3ff 1px solid; COLOR: #efefef; HEIGHT: 18px" value="选中房类查询">
<INPUT type="submit" name="action"
style="BACKGROUND-COLOR: #5971b4; BORDER-BOTTOM: #000875 1px solid; BORDER-LEFT: #9aa3ff 1px solid; BORDER-RIGHT: #000875 1px solid; BORDER-TOP: #9aa3ff 1px solid; COLOR: #efefef; HEIGHT: 18px" value="全部房类查询">
</P>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -