📄 xujie.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*,java.util.*;"%>
<%
if(session.getAttribute("rdlogin")!=null){
String adlogin = (String)session.getAttribute("rdlogin");
if(!adlogin.equals("yes")){
response.sendRedirect("./readerlogin.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("./readerlogin.jsp?errMsg=weidenglu" );
}
%>
<%
String id = request.getParameter("id");
String bookid = request.getParameter("bookid");
%>
<html>
<head><title>续借</title></head>
<body>
<%
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 bookhavebr where findid = '"+bookid+"'";
ResultSet rs=stmt.executeQuery(query);
int time =0;
while(rs.next()){
time = Integer.parseInt(rs.getString("xujie"));
}
%>
<br><br>
<h1><blockquote>这本书您还可以续借<%=time %>次</blockquote></h1>
<form action="servlet/XujieController" method="post">
<table width = 150 height = 150 Align = "left">
<tr><td> <input type = hidden name = "id" value = <%=id %> >
<input type = hidden name = "bookid" value = <%=bookid %> >
<input type = hidden name = "time" value = <%=time %> >
<input type = submit value=" 续借 " name = "de"> </td></tr>
<tr><td><a href = ./brbookdetail.jsp?id=<%=id %>>返回</a></td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -