📄 chaoqi.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.* ,java.util.Vector;"%>
<%
if(session.getAttribute("adlogin")!=null){
String adlogin = (String)session.getAttribute("adlogin");
if(!adlogin.equals("yes")){
response.sendRedirect("./login.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("./login.jsp?errMsg=weidenglu" );
}
%>
<html>
<head><title></title></head>
<body>
<br><br>
<h1><blockquote>所有超期还书的用户如下</blockquote></h1>
<br>
<table width = 400 height = 100 Align = "left">
<tr><th align= left>阅览证号</th></tr>
<%
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 fakuan";
ResultSet rs=stmt.executeQuery(query);
while(rs.next()){
%>
<tr><td><%=rs.getString("readerid") %></td><td><a href = ./readerdetail1.jsp?id=<%=rs.getString("readerid") %>>查看用户信息</a></td><td><a href = ./brbookdetail1.jsp?id=<%=rs.getString("readerid") %>>查看所借书籍</a></td></tr>
<%} %>
<tr><td><a href = ./welcome.jsp>返回</a></td></tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -