JavaWeb课程设计_宿舍管理系统02

最新推荐文章于 2024-06-14 23:07:01 发布

hoho_12

最新推荐文章于 2024-06-14 23:07:01 发布

阅读量4.9k

点赞数 5

分类专栏： JavaWeb综合设计文章标签： JavaWeb jsp Mysql数据库课程设计

本文链接：https://blog.csdn.net/hoho_12/article/details/50404801

版权

JavaWeb综合设计专栏收录该内容

13 篇文章 7 订阅

订阅专栏

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>