📄 loanlist.asp
字号:
<!-- #include file="conn.asp" -->
<html>
<!--#include file="ADOFunctions.asp"-->
<%
if (session("username")="") then
response.Redirect("index.asp")
end if
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link rel="stylesheet" href="css/admin.css" type="text/css">
</head>
<%
Dim rs
Set rs=GetRecordset("BOOK.mdb","books")
%>
<body>
<br>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="595" height="49" align="left" valign="middle">
<p><font color="red"><%=session("username")%>
</font> ：欢迎您进入图书管理系统！ </p></td>
</tr>
<tr>
<td width="595" height="30" align="center"><font color="#000000" size="+1">图
书 借 出 信 息 列 表</font> </td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="73"><table height="12%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr align="center">
<td width="92" height="30" align="center" >书号</td>
<td width="149" height="27" align="center">书名</td>
<td width="115" align="center">卡号</td>
<td width="133">借阅日期</td>
<td width="133">期限</td>
</tr>
<%
Set rs=GetRecordset("BOOK.mdb","loans")
if not rs.bof and not rs.eof then
Page=request.QueryString("page")
if page="" then
page=1
else
page=CInt(page)
end if
rs.PageSize=10
rs.AbsolutePage=page
ShowPage=page
Dim I
I=rs.PageSize
do while not rs.eof and I>0
I=I-1
bookno=rs("bookno")
cardn=rs("cardno")
booktitle=rs("title")
bdate=rs("date")
Dim keepDays
maxLoanKeepDays=60
keepDays = maxLoanKeepDays - DateDiff("d",rs("date"),now())
if keepDays<0 then keepDays="<font color=red>超期"&ABS(keepDays)&"天</font>"
%>
<tr align="center">
<td height="30" align="center"><%= bookno %></td>
<td width="149" height="27" align="center"><%= booktitle %></a></td>
<td width="115" align="center"><%= cardn %></td>
<td width="114"><%=bdate %></td>
<td width="133"><%= keepDays %></td>
</tr>
<%
rs.movenext
loop
if rs.RecordCount<1 then
%>
<tr align="center">
<td height="27" colspan="8" class="title">对不起,目前还没有读者借书！</td>
</tr>
<%
end if
%>
</table></td>
</tr>
<tr>
<td width="76%" height="29" valign="middle">
<p align="right"><font color="#FFFFFF">
第<%= ShowPage %>页 共<%=rs.PageCount%>页 <%=rs. RecordCount %>条记录 </font> <font color="#FFFFFF">
<%if ShowPage>1then %>
<a href="loanlist.asp?blockid=<%= strBlockid %>&page=1">首页</a>
<%else%>
首页
<% end if %>
<%if ShowPage>1then %>
<a href="loanlist.asp?blockid=<%= strBlockid %>&page=<%=ShowPage-1%>">前页</a>
<%else%>
前页
<% end if %>
<% if ShowPage<rs.PageCount then %>
<a href="loanlist.asp?blockid=<%= strBlockid %>&page=<%=ShowPage+1%>">后页</a>
<%else%>
后页
<% end if %>
<%if ShowPage<rs.PageCount then %>
<a href="loanlist.asp?blockid=<%= strBlockid %>&page=<%=rs.PageCount%>">末页</a>
<%else%>
末页
<% end if %>
</font></td>
</tr>
<%
end if
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -