📄 borrow.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" );
}
%>
<%
String id = request.getParameter("id");
%>
<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 reader where readerid = '"+session.getAttribute("readerno")+"'";
ResultSet rs=stmt.executeQuery(query);
int number =0;
while(rs.next()){
number = Integer.parseInt(rs.getString("maxreadno"))-Integer.parseInt(rs.getString("yijieshu"));
}
%>
<%
query = "select * from booktitle where findid = '"+id+"'";
rs = stmt.executeQuery(query);
String isbn = "";
while(rs.next()){
isbn = rs.getString("isbn");
}
%>
<br><br>
<h1><blockquote>您还可以借<%=number %>本书</blockquote></h1>
<form action="servlet/brBookController" method="post">
<table width = 150 height = 150 Align = "left">
<tr><td> <input type = hidden name = "bookid" value = <%=id %> >
<input type = hidden name = "isbn" value = <%=isbn %> >
<input type = hidden name = "readerid" value = <%=session.getAttribute("readerno") %> >
<input type = submit value=" 确认借阅 " name = "de"> </td></tr>
<tr><td><a href = ./bookdetail.jsp?id=<%=id %>>返回</a></td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -