4、query_house.jsp
查询房间信息,可以通过楼号和房间号查询。
<jsp:useBean id="myconnect" scope="session" class="student.DBConnect" />
<%
if (session.getAttribute("login") == null)
out.print("<script>alert('请先登录!');window.location.href='login.jsp'</script>");
%>
<!-- 查询条件 -->
<%
String buildingid = request.getParameter("buildingid");
String houseid = request.getParameter("houseid");
String sqlText = "";
if ((buildingid != null) && (!buildingid.equals(""))) {
sqlText = "select*from room where building='" + buildingid + "'";
if ((houseid != null) && (!houseid.equals(""))) {
sqlText = "select * from room where building='" + buildingid + "' and room='" + houseid + "'";
}
} else {
if ((houseid != null) && (!houseid.equals(""))) {
sqlText = "select * from room where room='" + houseid + "'";
}
}
%>
<body bgcolor="#CFE3CA" text="#004080">
<p> </p>
<form id="form1" name="form1" method="post" action="query_house.jsp">
<table width="37%" border="1" cellspacing="2" cellpadding="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 name="Submit" type="submit" value="查询" />
</div>
</td>
</tr>
</table>
</form>
<%
ResultSet rsroom;
if ((sqlText != null) && (!sqlText.equals(""))) {
sqlText=sqlText;
} else {
sqlText = "select*from room ";
}
rsroom = myconnect.DBQuery(sqlText);
%>
<table width="96%" border="1" height="60" align="center"
bordercolor="#004080" bgcolor="#CCCCCC">
<tr>
<td height="30">
<div align="center">楼号</div>
</td>
<td>
<div align="center">房号</div>
</td>
<td>
<div align="center">入住性别</div>
</td>
<td>
<div align="center">可住人数</div>
</td>
<td>
<div align="center">费用</div>
</td>
</tr>
<%
while (rsroom != null && rsroom.next()) {
%>
<tr>
<td height="30">
<div align="center">
<%
String buildings = new String(rsroom.getString("building"));
%>
<%=buildings%>
</div>
</td>
<td>
<div align="center">
<%
String houses = new String(rsroom.getString("room"));
%>
<%=houses%>
</div>
</td>
<td>
<div align="center">
<%
String sexs = new String(rsroom.getString("sex"));
%>
<%=sexs%>
</div>
</td>
<td>
<div align="center">
<%=rsroom.getInt("amount")%>
</div>
</td>
<td>
<div align="center">
<%=rsroom.getFloat("expense")%>
</div>
</td>
</tr>
<%
}
%>
</table>
</body>
5、query_student.jsp
查询学生信息功能,可以根据学号、姓名和院系来进行查询。
<%
if (session.getAttribute("login") == null)
out.print("<script>alert('请先登录!');window.location.href='login.jsp'</script>");
%>
<!-- 根据输入的条件来进行查询 -->
<%
String studentid = request.getParameter("studentid");
String name = request.getParameter("name");
String department = request.getParameter("department");
String sqlText = "";
if ((studentid != null) && (!studentid.equals(""))) {
sqlText = "select * from student where id='" + studentid + "'";
if ((name != null) && (!name.equals(""))) {
sqlText = "select * from student where id='" + studentid + "' and name='" + name + "'";
if ((department != null) && (!department.equals("0"))) {
sqlText = "select * from student where id='" + studentid + "' and name='" + name
+ "' and department='" + department + "'";
}
} else {
if ((department != null) && (!department.equals("0"))) {
sqlText = "select * from student where id='" + studentid + "' and department='" + department
+ "'";
}
}
} else {
if ((name != null) && (!name.equals(""))) {
sqlText = "select * from student where name='" + name + "'";
if ((department != null) && (!department.equals("0"))) {
sqlText = "select * from student where name='" + name + "' and department='" + department + "'";
}
} else {
if ((department != null) && (!department.equals("0"))) {
sqlText = "select * from student where department='" + department + "'";
}
}
}
%>
<body bgcolor="#CFE3CA" text="#004080">
<p> </p>
<form id="form1" name="form1" method="post" action="query_student.jsp">
<table width="42%" border="1" align="center" bordercolor="#004080"
bgcolor="#CCCCCC">
<tr>
<td width="100%" height="40" colspan="2">
<div align="center">
<strong><font size="4">学生信息查询</font></strong>
</div>
</td>
</tr>
<tr>
<td width="32%" height="30">
<div align="center">学号</div>
</td>
<td width="68%" height="30"><input name="studentid" type="text"
size="20" /></td>
</tr>
<tr>
<td height="30">
<div align="center">姓名</div>
</td>
<td height="30"><input name="name" type="text" size="20" /></td>
</tr>
<tr>
<td height="30">
<div align="center">院系</div>
</td>
<td height="30"><select name="department">
<option value="0" selected>请选择</option>
<option value="计算机系">计算机系</option>
<option value="化工学院">化工学院</option>
<option value="经管学院">经管学院</option>
<option value="文学院">文学院</option>
<option value="外国语学院">外国语学院</option>
</select></td>
</tr>
<tr>
<td height="40" colspan="2">
<div align="center">
<input type="submit" name="Submit" value="查询" />
</div>
</td>
</tr>
</table>
</form>
<%
ResultSet rsstudent;
if ((sqlText != null) && (!sqlText.equals(""))) {
//sqlText="select*from student where "+sqlText;
} else {
sqlText = "select*from student";
}
rsstudent = myconnect.DBQuery(sqlText);
if (rsstudent != null) {
%>
<table width="96%" border="1" height="60" align="center"
bordercolor="#004080" bgcolor="#CCCCCC">
<tr>
<td height="30" width="14%">
<div align="center">学号</div>
</td>
<td width="14%">
<div align="center">姓名</div>
</td>
<td width="17%">
<div align="center">性别</div>
</td>
<td width="16%">
<div align="center">院系</div>
</td>
<td width="19%">
<div align="center">楼号</div>
</td>
<td width="19%">
<div align="center">房号</div>
</td>
</tr>
<%
while (rsstudent.next()) {
%>
<tr>
<td height="30" width="14%">
<div align="center">
<%
String studentids = new String(rsstudent.getString("id").getBytes("8859_1"), "UTF-8");
%>
<%=studentids%>
</div>
</td>
<td width="14%">
<div align="center">
<%
String names = new String(rsstudent.getString("name"));
%>
<%=names%>
</div>
</td>
<td width="17%">
<div align="center">
<%
String sexs = new String(rsstudent.getString("sex"));
%>
<%=sexs%>
</div>
</td>
<td width="16%">
<div align="center">
<%
String departments = new String(rsstudent.getString("department"));
%>
<%=departments%>
</div>
</td>
<td width="19%">
<div align="center">
<%
int buildings = rsstudent.getInt("building");
%>
<%=buildings%>
</div>
</td>
<td width="19%">
<div align="center">
<%
int rooms = rsstudent.getInt("room");
%>
<%=rooms%>
</div>
</td>
</tr>
<%
}
} else
out.println("没有符合查询条件的数据,请重新输入查询数据!");
%>
</table>
</body>