searchbook.asp

晴和教务管理系统

<!--#include file="../inc/top.asp"-->
<!--#include file="../inc/function.asp"-->
<!--1-->
<div align="center">
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr>
<!--left--> 
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="table-you">
<!--#include file="../loginout.asp"-->
<table width=100% border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td height="35" bgcolor="f1f1f1" background="/jw/images/menu_10.gif" align="right" valign="bottom">
软 件 搜 索&nbsp;&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr>
<td class="table-xia">
<table width="90%" border="0" cellspacing="0" cellpadding="2" align="center">
<form name="34" method="post" action="checkuserlogin.asp">
<tr> 
<td align="center"><font color="#999999">输入搜索内容所包含的关键字</font></td>
</tr>
<tr> 
<td align="center">关键字： 
<input type="text" class="wenbenkuang" name="username" size="14">
</td>
</tr>
<tr> 
<td align="center">搜索类别： 
<select size="1" name="D1">
	<option value="教务公告">教务公告</option>
	<option value="校园动态">校园动态</option>
</select></td>
</tr>
<tr> 
<td align="center" height="38"> 
<input class=go-wenbenkuang name="imageField" value="搜 索" type=submit onFocus="this.blur()">
<input class=go-wenbenkuang onclick="window.location='reg.asp'" type=reset value="重 新 输 入" name=Submit2>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>

</td>
<!--center-->
<td width="390" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-shangxia" bgcolor="#ffffff" height="35">
<img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href="/jw/index.asp">教学系统</a> &gt;&gt; &gt;&gt; 查询结果</td>
</tr>
<TR>
<td bgcolor="#ffffff" colspan="4">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<%
bookname=request("bookname")
zb=request("zb")
cbs=request("cbs")
jx=request("jx")
ys=request("ys")
isbn=request("isbn")
adddate=request("adddate")
set rs=server.CreateObject("adodb.recordset")
sql="select * from Jw_book where bookname like '%"& bookname &"%' and zb like '%"& zb &"%' and cbs like '%"& cbs &"%' and jx like '%"& jx &"%' and ys like '%"& ys &"%' and isbn like '%"& isbn &"%' order by adddate desc"
rs.open sql,conn,1,3
If rs.RecordCount>0 Then
%>
<TR>
<td  height="20" align="center" class="table-xia" colspan="4"><font color="#FF0000">共有<% =rs.recordcount%>条符合条件的搜索结果</font></td>
</tr>
<TR>
<td class="table-you" align="center" width="20%" height="22"><p class="table-xia">书名</p></td>
<td class="table-you" align="center" width="20%" height="22"><p class="table-xia">主编</p></td>
<td class="table-you" align="center" width="40%" height="22"><p class="table-xia">出版社</p></td>
<td align="center" width="20%" height="22"><p class="table-xia">详细资料</p></td>
</tr>
<%rs.PageSize =10 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount 
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif  page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if

For i=1 To x
%>
<TR>
<td class="table-you" align="center" width="20%" height="22"><p class="table-xia"><% =rs("bookname")%></p></td>
<td class="table-you" align="center" width="20%" height="22"><p class="table-xia"><% =rs("zb")%></p></td>
<td class="table-you" align="center" width="40%" height="22"><p class="table-xia"><% =rs("cbs")%></p></td>
<td align="center" width="20%" height="22"><p class="table-xia">
<a href="searchbook.asp?dispbook=1&bookid=<% =rs("bookid")%>">查看</a></p></td>
</tr>
<%
rs.movenext
next
rs.close
set rs=nothing
Else
%>
<TR>
<td bgcolor="#ffffff" height="25" width="100%" align="center" colspan="4"><font color="#FF0000">没有符合搜索条件的结果</font></td>
</tr>
<%
End If
%>
<TR>
<td bgcolor="#ffffff" height="25" align="center" colspan="4"><% call PageControl(iCount,maxpage,page,"border=0 align=center","<p align=center>")%></td>
</tr>
</table>

</td>
</tr>
</table>
</td>
<!--right-->
<td width="190" bordercolor="#FFFFFF" bgcolor="#FFFFFF"  valign="top" class="table-zuo">
<%
dispbook=request("dispbook")
bookid=request("bookid")
If dispbook = 1 Then
set rs=server.CreateObject("adodb.recordset")
sql="select * from Jw_book where bookid ="& bookid
rs.open sql,conn,1,3
%>
<table width=100% border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td class="table-shangxia" bgcolor="#ffffff" height="35"><img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle">详细资料</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr> 
<td align="center" height="5" colspan="2">
</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">书名：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("bookname")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">主编：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("zb")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">发行：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("jx")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">印刷：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("ys")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">出版社：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("cbs")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">定价：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("dj")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">ISBN：</td>
<td align="left" height="25" width="66%" valign="top"><% =rs("isbn")%></td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">购进时间：</td>
<td align="left" height="25" width="66%" valign="top"><%=year(rs("adddate"))&"年"&month(rs("adddate"))&"月"&day(rs("adddate"))&"日"%></td>
</tr>
<tr> 
<td align="left" width="34%" valign="top">内容提要：</td>
<td align="left" width="66%" valign="top"><% =rs("ty")%></td>
</tr>
</table>
</td>
</tr>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
Else 
%>
<table width=100% border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td class="table-shangxia" bgcolor="#ffffff" height="35"><img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle">推荐新书</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr> 
<td align="center" height="5" colspan="2">
</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">书名：</td>
<td align="left" height="25" width="66%" valign="top">结构力学</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">主编：</td>
<td align="left" height="25" width="66%" valign="top">李廉锟</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">发行：</td>
<td align="left" height="25" width="66%" valign="top">新华书店北京发行所</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">印刷：</td>
<td align="left" height="25" width="66%" valign="top">高等教育出版社印刷厂</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">出版社：</td>
<td align="left" height="25" width="66%" valign="top">高等教育出版社</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">定价：</td>
<td align="left" height="25" width="66%" valign="top">19.70</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">ISBN：</td>
<td align="left" height="25" width="66%" valign="top">7-04-005343-8</td>
</tr>
<tr> 
<td align="left" height="25" width="34%" valign="top">购进时间：</td>
<td align="left" height="25" width="66%" valign="top">2004年11月21</td>
</tr>
<tr> 
<td align="left" width="34%" valign="top">内容提要：</td>
<td align="left" width="66%" valign="top">结构力学内容提要</td>
</tr>
</table>
</td>
</tr>
</table>
<%
conn.close
set conn=nothing
End If
%>
</td>
<!--end-->
</tr>
</table>
</div>
<!--#include file="../inc/end.asp"-->