📄 guest2.asp
字号:
<HTML>
<HEAD>
<TITLE>查询结果</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<!-- #include file="adofunctions.asp" -->
<%
Sub ShowPage(objRS)
Response.Write "<TABLE BORDER=0 class='style3'>"
Data = "<TR><th>编号</th>"
For I = 0 To objRS.Fields.Count - 1
Data =Data & "<TH>" & objRS.Fields(I).Name & "</TH>"
Next
Response.Write Data
kk=1
while not objRS.eof
Data = "<TR><td>" & kk & "</td>"
For J = 0 To objRS.Fields.Count - 1
Data = Data & "<TD>" & objRS.Fields(J).Value & "</TD>"
Next
Response.Write Data
objRS.MoveNext
kk=kk+1
wend
Response.Write "</TABLE>"
End Sub
%>
<% dim tiaojian,tiaojianzhi,riqi1,riqi2
tiaojian=request.Form("shoushuotiaojian")
tiaojianzhi=request.Form("tiaojianzhi")
riqi1=request.Form("riqi1")
riqi2=request.Form("riqi2")
select case tiaojian
case "书号"
strsql="select * from 图书表 where 书号= '" & tiaojianzhi &"'"
case "书名"
strsql="select * from 图书表 where 书名= '" & tiaojianzhi &"'"
case "作者"
strsql="select * from 图书表 where 作者= '" & tiaojianzhi &"'"
case "出版社"
strsql="select * from 图书表 where 出版社= '" & tiaojianzhi &"'"
case "出版日期"
strsql="select * from 图书表 where 出版日期= '" & tiaojianzhi &"'"
case "单价"
strsql="select * from 图书表 where 单价= '" & tiaojianzhi &"'"
case "图书类型"
strsql="select * from 图书表 where 图书类型= '" & tiaojianzhi &"'"
case else
strsql="select * from 图书表 where 书名='五笔' "
end select
%>
<%Set objRS = GetSQLRecordset(strsql,"bookstore.mdb", "图书表")%>
<%if not objRS.eof then %>
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-family: "宋体";
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: normal;
font-variant: normal;
text-transform: capitalize;
}
.title {
color: #000000;
font-family: "方正姚体";
font-size: 20px;
font-style: normal;
line-height: normal;
font-weight: normal;
font-variant: normal;
text-transform: capitalize;
letter-spacing: 16px;
text-decoration: none;
}
.style3 {color: #000000; font-family: "宋体"; font-size: 12px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: capitalize; }
.style4 {color: #0066FF; font-family: "宋体"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: capitalize; }
-->
</style>
</HEAD>
<BODY scroll=no BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<!-- ImageReady Slices (用户操作平台.psd) -->
<%
if session("adminname")<>""and session("adminpassword")<>"" then
%>
<%end if%>
<TABLE WIDTH=1024 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD ROWSPAN=3>
<IMG SRC="images/userchaxun_1.jpg" WIDTH=91 HEIGHT=96 ALT=""></TD>
<TD COLSPAN=2 ROWSPAN=3>
<IMG SRC="images/userchaxun_2.jpg" WIDTH=137 HEIGHT=96 ALT=""></TD>
<TD COLSPAN=6>
<IMG SRC="images/userchaxun_3.jpg" WIDTH=796 HEIGHT=13 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=13 ALT=""></TD>
</TR>
<TR>
<TD COLSPAN=5 background="images/userchaxun_4.jpg"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="15%"> </td>
<td width="80%" valign="bottom"><span class="style1"><marquee class="style1">
当前位置—>用户操作平台—>图书续借 此页用于登记学生继续借书的情况
</marquee>
</span></td>
<td width="5%"> </td>
</tr>
</table></TD>
<TD ROWSPAN=2>
<IMG SRC="images/userchaxun_5.jpg" WIDTH=100 HEIGHT=83 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=21 ALT=""></TD>
</TR>
<TR>
<TD COLSPAN=2>
<IMG SRC="images/userchaxun_6.jpg" WIDTH=125 HEIGHT=62 ALT=""></TD>
<TD COLSPAN=2>
<IMG SRC="images/userchaxun_7.jpg" WIDTH=460 HEIGHT=62 ALT=""></TD>
<TD>
<IMG SRC="images/userchaxun_8.jpg" WIDTH=111 HEIGHT=62 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=62 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=6>
<IMG WIDTH=1 HEIGHT=328 ALT=""></TD>
<TD ROWSPAN=3>
<IMG SRC="images/userchaxun_10.jpg" WIDTH=109 HEIGHT=200 ALT=""></TD>
<TD COLSPAN=3>
<IMG SRC="images/userchaxun_11.jpg" WIDTH=153 HEIGHT=82 ALT=""></TD>
<TD COLSPAN=2>
<IMG SRC="images/userchaxun_12.jpg" WIDTH=460 HEIGHT=82 ALT=""></TD>
<TD ROWSPAN=3>
<IMG SRC="images/userchaxun_13.jpg" WIDTH=111 HEIGHT=200 ALT=""></TD>
<TD ROWSPAN=6>
<IMG SRC="images/userchaxun_14.jpg" WIDTH=100 HEIGHT=328 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=82 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=5>
<IMG SRC="images/userchaxun_15.jpg" WIDTH=28 HEIGHT=246 ALT=""></TD>
<TD COLSPAN=2>
<IMG SRC="images/userchaxun_16.jpg" WIDTH=125 HEIGHT=38 ALT=""></TD>
<TD COLSPAN=2 ROWSPAN=4 background="images/userchaxun_17.jpg"><form name="form1" method="post" action="admin_xvjiebook1.asp">
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td colspan="2"><div align="center" class="title">查询结果</div></td>
<td> </td>
</tr>
<tr>
<td><img name="img" src="" width="120" height="8" alt=""></td>
<td class="style3"><img name="img" src="" width="80" height="8" alt=""></td>
<td><img name="img" src="" width="80" height="8" alt=""></td>
<td><img name="img" src="" width="120" height="8" alt=""></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="4"><div align="center" class="style3"> <% ShowPage objRS %>
</div></td>
</tr>
</table>
</form></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=38 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=2>
<IMG SRC="images/userchaxun_18.jpg" ALT="" WIDTH=97 HEIGHT=145 border="0" usemap="#Map"></TD>
<TD ROWSPAN=4>
<IMG SRC="images/userchaxun_19.jpg" WIDTH=28 HEIGHT=208 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=80 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=3>
<IMG SRC="images/userchaxun_20.jpg" WIDTH=109 HEIGHT=128 ALT=""></TD>
<TD ROWSPAN=3>
<IMG SRC="images/userchaxun_21.jpg" WIDTH=111 HEIGHT=128 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=65 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=2>
<IMG SRC="images/userchaxun_22.jpg" WIDTH=97 HEIGHT=63 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=40 ALT=""></TD>
</TR>
<TR>
<TD COLSPAN=2 ROWSPAN=2>
<IMG SRC="images/userchaxun_23.jpg" WIDTH=460 HEIGHT=67 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=23 ALT=""></TD>
</TR>
<TR>
<TD ROWSPAN=2>
<IMG SRC="images/userchaxun_24.jpg" WIDTH=91 HEIGHT=149 ALT=""></TD>
<TD COLSPAN=4>
<IMG WIDTH=262 HEIGHT=1 ALT=""></TD>
<TD>
<IMG WIDTH=111 HEIGHT=1 ALT=""></TD>
<TD ROWSPAN=2>
<IMG SRC="images/userchaxun_27.jpg" WIDTH=100 HEIGHT=149 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=44 ALT=""></TD>
</TR>
<TR>
<TD>
<IMG SRC="images/userchaxun_28.jpg" WIDTH=109 HEIGHT=105 ALT=""></TD>
<TD COLSPAN=3>
<IMG SRC="images/userchaxun_29.jpg" WIDTH=153 HEIGHT=105 ALT=""></TD>
<TD>
<IMG SRC="images/userchaxun_30.jpg" WIDTH=187 HEIGHT=105 ALT=""></TD>
<TD>
<IMG SRC="images/userchaxun_31.jpg" WIDTH=273 HEIGHT=105 ALT=""></TD>
<TD>
<IMG SRC="images/userchaxun_32.jpg" WIDTH=111 HEIGHT=105 ALT=""></TD>
<TD>
<IMG SRC="images/spacer.gif" WIDTH=1 HEIGHT=105 ALT=""></TD>
</TR>
</TABLE>
<!-- End ImageReady Slices -->
<map name="Map">
<area shape="rect" coords="1,1,97,25" href="jieshu.asp">
<area shape="rect" coords="1,41,96,69" href="huanshu.asp">
<area shape="rect" coords="0,80,97,104" href="admin_xvjiebook.asp">
<area shape="rect" coords="0,121,95,143" href="guest.asp">
</map>
</BODY>
</HTML>
<%
objRS.close
set objRS=nothing
objConn.close
set objConn=nothing
%>
<%else%>
<html>
<head><title>查询失败</title></head>
<body text="#0000FF" bgcolor="#E0E1E2">
<div align="center class="style3">对不起，没找到你要的图书，请找管理员联系。</div><Br>
<a href="guest.asp">返回继续查询</a>
</body>
</html>
<%end if%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -