?? books.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="sub/config.asp"-->
<!--#include file="sub/conn.asp"-->
<!--#include file="sub/getType2.asp"-->
<!--#include file="sub/inc.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="index.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!--#include file="top.asp"-->
<table width="780" height="4" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td background="images/index_11.gif"></td>
</tr>
</table><table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" rowspan="2"><img src="images/Lv2/lv2bookclass.gif" width="200" height="30" /></td>
<td height="29" colspan="3" align="center">
<marquee behavior=alternate onmouseover=stop() onmouseout=start() direction="center" scrollamount="1" scrolldelay="8" class="top" >
<font class="top"><%=ad1%></font>
</marquee> </td>
</tr>
<tr>
<td height="1" colspan="3" align="center" bgcolor="#FF9900"></td>
</tr>
<tr>
<td align="center" valign="top" bgcolor="#EEFFFF">
<table width="175" border="0" cellspacing="0" cellpadding="0">
<%
dim i
i = 1
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from bookclass"
RS.Open SQL, cn, 1,1,1
Do while not RS.EOF
if i mod 2 <> 0 then
%>
<tr>
<td width="90" height="20"><img src="images/indexdddd.gif" width="6" height="6" /> <a href="books.asp?class=<%=RS("class")%>"><%=RS("classname")%></a></td>
<% i = i + 1
else
%>
<td width="97" height="20"><img src="images/indexdddd.gif" width="6" height="6" /> <a href="books.asp?class=<%=RS("class")%>"><%=RS("classname")%></a></td>
</tr>
<% i = i + 1
end if
RS.movenext
Loop
set RS = nothing
if i mod 2 = 0 then
%>
<%
end if
%>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/websearch.gif" width="200" height="30" /></td>
</tr>
<tr>
<td align="center">
<% '調用全站搜索表單
'翱翔designz.cn制作
call websearch()%> </td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/Lv2/lv2dj.gif" width="200" height="30" /></td>
</tr>
<tr>
<td align="left">
<%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 "<br/>"
Response.Write " <img src='images/indexddd.gif' /> <a href='showbook.asp?id="&rs("id")&"'>"&rs("title")&"</a>"
rs.movenext
loop
rs.close
set rs=nothing%>
</td>
</tr>
</table>
</td>
<td width="431" valign="top">
<% '右框程序
if Request.QueryString("class")<>"" then
r1=Request.QueryString("class")
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from book where class="&r1&" 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 "<br/> [<a href='books.asp?class="&rs("class")&"'>"&getMemberDepict(cint(rs("class")))&"</a>] <a href='showbook.asp?id="&rs("id")&"'>"&rs("title")&"</a> <span class='date'>發布日期:"&rs("date")&"</span><br/>"
rs.movenext
next
else
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 "<br/> [<a href='books.asp?class="&rs("class")&"'>"&getMemberDepict(cint(rs("class")))&"</a>] <a href='showbook.asp?id="&rs("id")&"'>"&rs("title")&"</a> <span class='date'>發布日期:"&rs("date")&"</span><br/>"
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
%> </td>
<td width="1" valign="top" bgcolor="#FF9900"></td>
<td width="148" align="center" valign="top"><%=ad4%></td>
</tr>
</table>
<!--#include file="bottom.asp"-->
</body>
</html>
>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -