xujie.jsp

来自「学习jsp时做的一个书馆」· JSP 代码 · 共 45 行

JSP
45
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?