?? search.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>
<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="149" height="27" align="center">卡號</td>
<td width="149" height="27" align="center">姓名</td>
<td width="115" align="center">所在院系</td>
<td width="114">照片</td>
<td width="114">操作</td>
</tr>
<%
dim keyword,rs
keyword = trim(Request("keyword"))
sql="select * from borrowers where cardno like '%"& keyword &"%' order by id desc"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,1,1
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
cardn=rs("cardno")
bname=rs("name")
bdept=rs("dept")
bpic=rs("picture")
%>
<tr align="center">
<td width="149" height="27" align="center"><%=cardn %></a></td>
<td width="149" height="27" align="center"><%=bname %></a></td>
<td width="115" align="center"><%= bdept %></td>
<td width="114"><a href="upload/<%= bpic %>" target="_blank">查看</a></td>
<form name="deluser" action="deluser.asp?id=<%=rs("cardno")%>" method="post">
<td width="114"><input name="submit" type=submit style="background:#ffffff" value="刪除"></td>
</form>
</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>
<%
' if rs. RecordCount>20 then
%>
<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="search.asp?page=1">首頁</a>
<%else%>
首頁
<% end if %>
<%if ShowPage>1then %>
<a href="search.asp?page=<%=ShowPage-1%>">前頁</a>
<%else%>
前頁
<% end if %>
<% if ShowPage<rs.PageCount then %>
<a href="search.asp?page=<%=ShowPage+1%>">后頁</a>
<%else%>
后頁
<% end if %>
<%if ShowPage<rs.PageCount then %>
<a href="search.asp?page=<%=rs.PageCount%>">末頁</a>
<%else%>
末頁
<% end if %>
</font></td>
</tr>
<%
end if
%>
</table>
<table width="600" height=20 border=0 align="center" cellpadding=0 cellspacing="1" >
<tr align="center">
<form action="search.asp" method="post">
<td height="20" > 搜索關鍵字：
<input name="keyword" size="30" maxlength="20" style="background-color:#ffffff; color:#8888AA; border: 1 double #B4B4B4" onMouseOver = "this.style.backgroundColor = '#E5F0FF'" onMouseOut = "this.style.backgroundColor = ''" value=<%=keyword%>>
<INPUT type=submit value=搜索 name=Submit>
搜索關鍵字[<font color=red><%=keyword%></font>] 共有：<font color="red" face="verdana"><%=Rs.recordcount%></font>個
<br>
<br>*支持精確查詢與模糊查詢,請輸入借閱者的卡號的若干位*
</td>
</form>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -