📄 query_house.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<% import="java.util.*" %>
<% import="java.sql.*" %>
<jsp:useBean id="myconnect" scope="session" class="student.DBConnect"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%
//如果用户还未登录或者处于在线状态,提示用户先登录系统,并跳转至登录页面
if(session.getAttribute("login")==null)
out.print("<script>alert('请先登录!'); window.location.href='login.jsp' </script>");
%>
<%
String buildingid=request.getParameter("builkdigid"); //取出用户输入的楼号
String houseid=request.getParameter("houseid"); //取出用户输入的房号
String sqlText="";
//对查询条件的处理
//如果用户查询指定楼的信息即楼号不为空,见分晓在查询条件中进行设置
if((buildingid!=null) && (!buildingid.equals(""))) {
sqlText+="and room="+houseid;
}
} else {
//如果相应的楼号为空而房号信息不为空,则在查询条件中只设置固定房号的查询条件
if((houseid!=null) && (!houseid.equals(""))) {
sqlText="room="+houseid;
}
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>查询房间</title>
<link href="css/mycss.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#CFE3CA" text="#004080">
<p>
</p>
<form name="form1" method="post" action="query_house.jsp">
<table width="33%" border="1" align="center" bordercolor="#004080" bgcolor="#cccccc">
<tr>
<td colspan="2" height="56">
<div align="center">
<strong><font size="5">房间信息查询</font></strong>
</div>
</td>
</tr>
<tr>
<td width="35%" height="30">
<div align="center">
楼号
</div>
</td>
<td width="65%">
<input name="buildingid" type="text" size="20">
</td>
</tr>
<tr>
<td height="34">
<div align="center">
房号
</div>
</td>
<td>
<input name="houseid" type="text" size="20">
</td>
</tr>
<tr>
<td height="47" colspan="2">
<div align="center">
<input type="submit" name="Submit" value="查 询">
</div>
</td>
</tr>
</table>
</form>
<%
//根据指定条件进行查询
ResultSet rsroom;
//如果sqlText 不为空说明用户希望查找指定条件的房间信息
if((sqlText!=null) && (!sqlText.equals(""))) {
sqlText="select *from room where"+sqlText;"
}
//如sqlText为空说明用户希望查找所有房间信息
else {
sqlText="select * from room";
}
rsroom=myconnect.DBQuery(sqlText);
%>
<table width="85%" border="1" height="60" align="center" bordercolor="#004080" bgcolor="#cccccc">
<tr>
<td width="15%" height="30">
<div align="center">
楼号
</div>
</td>
<td width="15%">
<div align="center">
房号
</div>
</td>
<td width="25%">
<div align="center">
入住性别
</div>
</td>
<td width="25%">
<div align="center">
可入住人数
</div>
</td>
<td width="20%">
<div align="center">
费用
</div>
</td>
<%
while(rsroom!=null && rsroom.next()) { //这里有一个陌生的"{",哈哈,我知道了,对应最后的那个"<% } %>"
%>
<tr>
<td height="30">
<div align="center">
<%
String buildings=new String(rsroom.getString("building").getBytes("8859_1"),"gb2312");
%>
<%=buildings %>
</div>
</td>
<td>
<div align="center">
<%
String houses=new String(rsroom.getString("room").getBytes("8859_1"),"gb2312");
%>
<%=houses %>
</div>
</td>
<td>
<div align="center">
<%
String sexs=new String(rsroom.getString("sex").getBytes("8859_1"),"gb2312");
%>
<%=sexs %>
</div>
</td>
<td>
<div align="center">
<%=rsroom.getInt("amount") %>
</div>
</td>
<td>
<div align="center">
<%=rsroom.getFloat("expense") %>
</div>
</td>
</tr>
<%
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -