admin_index.asp

是运行在asp环境下寻梦书库管理系统

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="inc/conn.asp"-->
<!--#include file="inc/fun.asp"-->
<!--#include file="top.asp"-->
<!--#include file="chk.asp"-->
<style type="text/css">
<!--
.lz0 { 
    font-size: 12px; 
    color: #FF00C0; 
}
.lz1 { 
    font-size: 12px; 
    color: #AAAAAA; 
}
//-->
</STYLE>
<br><br>
<b>书籍列表</b>
<br><br>
<%
	on error resume next  '找不到站点资料时忽略错误

kindid=request("kindid")

sql="select bookid,bookname,zuozhe,tuijian,hit,lzai from book where kindid="&kindid&"  order by bookid desc"
set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open sql,conn,1,1
Rs.pagesize=16
page=Request("page")
if (page-Rs.pagecount) > 0 then
page=Rs.pagecount
elseif page = "" or page < 1 then
page = 1
end if
Rs.absolutepage=page
%>

<%
do while not Rs.eof
i = i + 1
if i > Rs.pagesize then
exit do
end if
%>

<table width=100% height=24 border=0 align="center" cellPadding=3 cellSpacing=0 style="border-collapse: collapse word-break:break-all">
  <tr>
<td colspan="2" style="word-break:break-all"  width="500">
  <%=Rs("zuozhe")%><a href="admin_bookread.asp?bookid=<%=Rs("bookid")%>"><b>《<%=Rs("bookname")%>》</a></b>  <a href="admin_edit2.asp?bookid=<%=rs("bookid")%>&bookname=<%=Rs("bookname")%>">[编辑]</a><a href="javascript:if(confirm('确定要删除此书吗？\n注意：一经删除无法恢复！')){ window.location='admin_del.asp?action=delbook&bookid=<%=rs("bookid")%>';}">[删除]</a><%if Rs("lzai")=0 then%><a href="admin_add.asp?bookid=<%=rs("bookid")%>">[添加文章]</a><a href="shenhe.asp?sh=4&kindid=<%=kindid%>&bookid=<%=rs("bookid")%>"><span class="lz0">完成</span></a>
<%else%><a href="shenhe.asp?sh=40&kindid=<%=kindid%>&bookid=<%=rs("bookid")%>"><span class="lz1">继续连载</span></a><%end if%></td>
<td width="270">
   推荐度：<%=encode1(rs("tuijian"))%>　　阅读<b><%=Rs("hit")%></b>次<br>
</td>
</tr></table>

<%
Rs.movenext
loop
%>

</td>
</tr>
</table>

<table border=0 cellpadding=0 cellspacing=1 width=640>
<tr><td align="center" style="line-height: 150%">
  <p>目前共收录此类书籍书籍<%=Rs.recordcount%>种&nbsp;<%=page%>/<%=Rs.pagecount%>页 跳到第
      <% for go=1 to Rs.pagecount
%>
      <a href=admin_index.asp?kindid=<%=kindid%>&page=<%=go%>><%=go%></a>
      <%next%>
      页&nbsp;
      <% if page=1 then %> 
      <%else%>
      <a href=admin_index.asp?kindid=<%=kindid%>&page=<%=page-1%>>上一页</a>&nbsp;
      <%end if%>
      <% if Rs.pagecount-page <> 0 then %>
      <a href=admin_index.asp?kindid=<%=kindid%>&page=<%=page+1%>>下一页</a>&nbsp;
      <%else%> 
      <%end if%>
</td></tr></table>
<br><br>