📄 readerdetail.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
if(session.getAttribute("adlogin")!=null){
String adlogin = (String)session.getAttribute("adlogin");
if(!adlogin.endsWith("yes")){
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
%>
<html>
<body>
<%
String id = request.getParameter("id");
String name = "";
String stuno = "";
String xueyuan = "";
String zhuanye = "";
String age = "";
String sex = "";
String data = "";
String beizhu = "";
String maxno="";
String yijieshu ="";
String kind = "";
String passwd = "";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from reader where readerid = '"+id+"'";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
name=rs.getString("name");
stuno=rs.getString("StuNo");
xueyuan = rs.getString("xueyuan");
zhuanye = rs.getString("zhuanye");
age = rs.getString("age");
sex = rs.getString("sex");
data = rs.getString("usedata");
beizhu=rs.getString("beizhu");
maxno=rs.getString("maxreadno");
yijieshu =rs.getString("yijieshu");
kind = rs.getString("readerkind");
passwd = rs.getString("password");
//out.print(name+"<br>");
}
%>
<h1><blockquote>用户<%=id %>的信息如下</blockquote></h1>
<table width = 500 height = 500 Align = "left">
<tr><td>卡号</td><td><%=id %></td></tr>
<tr><td>姓名</td><td><%=name %></td></tr>
<tr><td>学号</td><td><%=stuno %></td></tr>
<tr><td>密码</td><td><%=passwd %></td></tr>
<tr><td>年龄</td><td><%=age %></td></tr>
<tr><td>性别</td><td><%=sex %></td></tr>
<tr><td>学院</td><td><%=xueyuan %></td></tr>
<tr><td>专业</td><td><%=zhuanye %></td></tr>
<tr><td>最大借书数</td><td><%=maxno %></td></tr>
<tr><td>已借书数</td><td><%=yijieshu %></td></tr>
<tr><td>类别</td><td><%=kind %></td></tr>
<tr><td>借阅证到期时间</td><td><%=data %></td></tr>
<tr><td>备注信息</td><td><%=beizhu %></td></tr>
<tr><td><a href = ./readsearchresult.jsp>返回</a></td><td><a href= ./changereader.jsp?id=<%=id %>>更改用户信息</a></td></tr>
<tr><td><a href = ./brbookdetail.jsp?id=<%=id %>>查看所借书籍</a></td><td><a href= ./deletereader.jsp?id=<%=id %>>删除用户</a></td></tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -