📄 admin_notreturn.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../ch.jsp" %>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="viewborrow" class="conndb.DbConnBean" scope="page" />
<%
String sql="select * from borrowBook";
int temp=-2;
int id=0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书借阅信息</title>
<style type="text/css">
<!--
body,td,th {
font-size: 13px;
}
body {
background-image: url(../images/R6C.GIF);
}
-->
</style></head>
<body>
<% if(temp==0){out.println("对不起,目前还没有师生来借书！");}else{ %>
当前图书借阅信息<%= now %>
<table width="95%" border="2" align="center" cellpadding="4" cellspacing="0" bordercolor="#CCCCFF">
<tr bordercolor="#009900" bgcolor="#CCFFCC">
<td width="6%" align="center"><strong>序号</strong></td>
<td width="8%" align="center"><strong>借书人</strong></td>
<td width="14%" align="center"><strong>借书证号</strong></td>
<td width="32%" align="center"><strong>图书名称</strong></td>
<td width="15%" align="center"><strong>图书编号</strong></td>
<td width="12%" align="center"><strong>借书时间</strong></td>
<td width="13%" align="center"><strong>还书截止日期</strong></td>
</tr>
<%
String sqll="select [user].name,book.title,borrowBook.bookID,borrowBook.begintime,borrowBook.endtime,borrowBook.borrowID from borrowBook inner join book on book.bookid=borrowbook.bookid inner join [user] on [user].borrowid=borrowbook.borrowid";
Connection conn=viewborrow.getConn();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sqll);
while(rs.next()){
id++;
String username=rs.getString(1);
String bookname=rs.getString(2);
String bookid=rs.getString(3);
String begintime=rs.getString(4).substring(0,10);
String returntime=rs.getString(5).substring(0,10);
String borrowid=rs.getString(6);
%>
<tr>
<td align="center"><%=id %> </td>
<td align="left"><%=username %> </td>
<td align="left"><%=borrowid %> </td>
<td align="left"><%=bookname %> </td>
<td><%=bookid %> </td>
<td><%=begintime %> </td>
<td><%=returntime%> </td>
</tr>
<%}} %>
<tr>
<td colspan="7"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -