📄 welcome.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
if(session.getAttribute("rdlogin")!=null){
String adlogin = (String)session.getAttribute("rdlogin");
if(!adlogin.endsWith("yes")){
response.sendRedirect("./readerlogin.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("./readerlogin.jsp?errMsg=weidenglu" );
}
%>
<%
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 ='"+(String)session.getAttribute("readerno")+"'";
String stuNo = "";
String name = "";
String sex = "";
String age = "";
String xueyuan = "";
String zhuanye = "";
String readKind = "";
String maxReaderNo = "";
String yijieshu ="";
String usedata = "";
String beizhu ="";
ResultSet r=stmt.executeQuery(query);
while(r.next())
{
stuNo = r.getString("StuNo");
name = r.getString("name");
sex = r.getString("Sex");
age = r.getString("age");
xueyuan = r.getString("xueyuan");
zhuanye = r.getString("zhuanye");
readKind = r.getString("readerkind");
maxReaderNo = r.getString("maxreadno");
yijieshu =r.getString("yijieshu");
usedata = r.getString("usedata");
beizhu = r.getString("beizhu");
}
%>
<html>
<body>
<blockquote><h1>你的基本信息如下 </h1></blockquote>
<table width = 260 height = 80 >
<tr><td><a href = ./brbookdetail.jsp?id=<%=(String)session.getAttribute("readerno") %>>借书信息</a></td>
<td><a href = ./changepasswd.jsp?id=<%=(String)session.getAttribute("readerno") %>>修改密码</a></td>
<td><a href = ./search.jsp %>搜索书籍</a></td>
<td><a href = ./readerlogout.jsp %>退出</a></td></tr>
</table>
<table width = 200 height = 200 align = "left">
<tr><td><h3>阅览证号</h3></td><td><h3> <%=(String)session.getAttribute("readerno") %></h3></td></tr>
<tr><td><h3>姓名</h3></td><td><h3><%= name %></h3></td></tr>
<tr><td><h3>学号</h3></td><td><h3><%=stuNo %></h3></td></tr>
<tr><td><h3>专业</h3></td><td><h3><%=zhuanye %></h3></td></tr>
<tr><td><h3>类别</h3></td><td><h3><%=readKind %></h3></td></tr>
<tr><td><h3>最大借书数</h3></td><td><h3><%=maxReaderNo %></h3></td></tr>
<tr><td><h3>已借数量</h3></td><td><h3><%=yijieshu %></h3></td></tr>
<tr><td><h3>阅览证到期时间</h3></td><td><h3><%=usedata %></h3></td></tr>
<tr><td><h3>备注</h3></td><td><h3><%=beizhu %></h3></td></tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -