📄 books.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="sub/config.asp"-->
<!--#include file="sub/conn.asp"-->
<!--#include file="sub/inc.asp"-->
<!--#include file="sub/getType2.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><%=SiteName%></title>
<link href="img/dex.css" rel="stylesheet" type="text/css" />
<link href="img/dex2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!--TOP-->
<!--#include file="top.asp"-->
<!--TOP END-->
<div id="box">
<div id="boxleft">
<div id="dclass">
<ul><%
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from bookclass"
RS.Open SQL, cn, 1,1,1
Do while not RS.EOF%>
<li><a href="books.asp?class=<%=RS("class")%>"><%=RS("classname")%></a></li>
<% RS.movenext
Loop
set RS = nothing%>
</ul>
</div>
<!--新闻分类结束-->
<div id="wsearch">
<% call websearch() %>
</div>
<!--全站搜索结束-->
<div id="newstop">
<ul>
<%Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "Select top 10 * from book order by click desc"
rs.Open SQL, cn, 1,1
do while not rs.eof
Response.Write "<li><a href='showbook.asp?id="&rs("id")&"'>"&left(rs("title"),13)&"...</a></li>"
rs.movenext
loop
rs.close
set rs=nothing%>
</ul>
</div></div>
<!--点击排行结束-->
<div id="boxright">
<div id="ad1">
<%=ad4%>
</div>
<!--广告结束-->
<div id="newstitle">
<ul>
<% '右框程序
if Request.QueryString("class")<>"" then
Set rs1 = Server.CreateObject("ADODB.Recordset")
SQL1 = "Select classname from bookclass where class=" & Request.QueryString("class")
rs1.Open SQL1,cn,1,1
Session.Contents("classname")=rs1("classname")
set rs1 = nothing
Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL2 = "Select * from book where class=" & Request.QueryString("class")
rs2.Open SQL2,cn,1,1
Do while not rs2.eof
%>
<li><a href="showbook.asp?id=<%=rs2("id")%>"><font color="<%=rs2("color")%>"><%=rs2("title")%></font></a> ----发布日期: <%=rs2("date")%><br/></li>
<%
rs2.movenext
Loop
set rs2 = nothing
else
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from book order by date desc"
rs.open sql,cn,1,1
rs.PageSize=30
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
for i=1 to rs.pagesize
if rs.EOF then exit for
response.write("<li> <a href='book.asp?class="&rs("class")&"'>["&getMemberDepict(cint(rs("class")))&"]</a>")%>
<a href="showbook.asp?id=<%=rs("id")%>"><font color="<%=rs("color")%>"><%=rs("title")%></font></a> ----发布日期: <%=rs("date")%><br/></li>
<% rs.movenext
next%>
<br /><br />
<%if page=1 and not page=pagecount then%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="books.asp?page=<%=i%>"><%=i%></a> <%next%><a href="books.asp?page=<%=page+1%>">下一页</a> </div>
<%elseif page=pagecount and not page=1 then%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="books.asp?page=<%=i%>"><%=i%></a> <%next%><a href="books.asp?page=<%=page-1%>">上一页</a> </div>
<%elseif page<1 then%><div class="font" align="center"><font color=red>没有任何记录！</font></div>
<%elseif page>pagecount then%><div class="font" align="center"><font color=red>没有任何记录！</font></div>
<%elseif page=1 and page=pagecount then%>
<%else%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="books.asp?page=<%=i%>"><%=i%></a> <%next%><a href="books.asp?page=<%=page-1%>">上一页</a>
<a href="books.asp?page=<%=page+1%>">下一页</a> </div>
<%end if
end if
rs.close
set rs=nothing
%>
</ul>
</div>
</div>
</div>
<!--#include file="bottom.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -