查询用户信息-CSDN博客

[b]问题：[/b]
需要查看图书管理系统某用户信息

[b]解决办法：[/b]


<%@ page language="java" import="java.util.*" import="java.sql.*"
	pageEncoding="GBK"%>
<%
	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>显示用户注册信息</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>

	<body>
		<table with="80%" class="default" align="center">
			<tr class="title">
				<td class="item">
					 用户名
				</td>
				<td class="item">
					密码
				</td>
				<td class="item">
					姓名
				</td>
				<td class="item">
					出生日期
				</td>
				<td class="item">
					性别
				</td>
				<td class="item">
					爱好
				</td>
				<td class="item">
					学历
				</td>
				<td class="item">
					简历
				</td>
			</tr>
			<%
				Connection conn = null;
				PreparedStatement ps = null;
				ResultSet rs = null;
				try {
					Class.forName("oracle.jdbc.driver.OracleDriver");
					String url = "jdbc:oracle:thin:@172.23.7.45:1521:netp";
					String user = "training";
					String password = "training";
					conn = DriverManager.getConnection(url, user, password);
					ps = conn
							.prepareStatement("select * from demo_users order by userid");
					rs = ps.executeQuery();
					while (rs.next()) {
			%>
			<tr>
				<td><%=rs.getString(2)%></td>
				<td><%=rs.getString(5)%></td>
				<td><%=rs.getString(7)%></td>
				<td><%=rs.getDate(3)%></td>
				<%
					if (rs.getInt(4) == 1) {
				%>
				<td>
					男
				</td>
				<%
					} else {
				%>
				<td>
					女
				</td>
				<%
					}
				%>
				<td><%=rs.getString(9)%></td>
				<td>
					<%
						switch (rs.getInt(8)) {
								case 1:
									out.println("高中");
									break;
								case 2:
									out.println("专科");
									break;
								case 3:
									out.println("本科");
									break;
								case 4:
									out.println("硕士");
									break;
								case 5:
									out.println("博士");
									break;
								default:
									out.println("更高");
								}
					%>
				</td>
				<td><%=rs.getString(6)%></td>
			</tr>
			<%
				}
				} catch (Exception e) {
					System.out.println(e);
				} finally {
					if (rs != null) {
						try {
							rs.close();
						} catch (Exception e) {
							System.out.println(e);
						}
					}
					if (ps != null) {
						try {
							ps.close();
						} catch (Exception e) {
							System.out.println(e);
						}
					}
					if (conn != null) {
						try {
							conn.close();
						} catch (Exception e) {
							System.out.println(e);
						}
					}
				}
			%>
		</table>
	</body>
</html>