?? admin_booktype.asp
字號:
<!-- #include file="conn.asp" -->
<!-- #include file="cookies.asp" -->
<%'分頁
set rs=server.createobject("adodb.recordset")
sql="select * from book"
rs.open sql,conn,1,1
page=Request("page")
if page=0 then
page=1
end if
RecordCount = 0
do while not rs.Eof
RecordCount = RecordCount +1
rs.MoveNext
loop
if not RecordCount=0 then
rs.MoveFirst
end if
pageCount=RecordCount/10
pageCount=int(pageCount)
if (RecordCount mod 10)>0 then
PageCount=PageCount +1
end if
rs.close
set rs=nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>80秀傳媒設計資訊中心 || 網(wǎng)站作品展示 || 后臺管理</title>
<link href="style.css" type="text/css" rel="stylesheet">
</head>
<body bgcolor="#666666" text="#000000">
<div align="center">
<p><font color="#FFFFFF">|<a href="admin_booktype.asp">全部文章</a>|
<%
set rs=server.createobject("adodb.recordset")
sql="select * from type"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.redirect "error.asp?err_on=4"
else
rs.movefirst
for i=1 to rs.recordcount
%>
<a href="admin_booktype1.asp?id=<%=rs("id")%>"><%=rs("typename")%> </a>|
<%
rs.movenext
next
rs.close
set rs=nothing
end if
%>
</font>
</p>
<p> </p>
<center>
<table width="550" border="0" cellpadding="6" cellspacing="1" bgcolor="#393939" class="b" height="9">
<tr bgcolor="#5b5b5b" class="text">
<td width="250" style="letter-spacing: 1">共有文章<font color="#FF0000"><%=RecordCount%></font>篇，目前<font color="#ff0000"><%=page%>/<%=pageCount%></font>頁</td>
<td width="50" style="letter-spacing: 1" align="center">
<%if page=1 then
%>
首頁
<%else%>
<a href="booktype.asp">首頁</a>
<%end if%>
</td>
<td width="75" style="letter-spacing: 1" align="center">
<%if page=1 then
%>
上一頁
<%else%>
<a href="booktype.asp?page=<%=page-1%>">上一頁</a>
<%end if%>
</td>
<td width="75" style="letter-spacing: 1" align="center">
<%if pagecount-page=0 then
%>
下一頁
<%else%>
<a href="admin_booktype.asp?page=<%=page+1%>">下一頁</a>
<%end if%>
</td>
<td width="50" align="center">
<%if pagecount-page=0 then%>
尾頁
<%else%>
<a href="admin_booktype.asp?page=<%=pagecount%>">尾頁</a>
<%end if%>
</td>
</tr>
</table>
</center>
<%
set rs=server.createobject("adodb.recordset")
sql="select id,title from book order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.redirect "error.asp?err_on=5"
else
%>
<table width="550" border="0" cellpadding="6" cellspacing="1" bgcolor="#393939" class="b" height="9">
<%do while pos<(page-1)*10
pos=pos+1
rs.moveNext
loop%>
<%x=0%>
<%do while x<10 and not rs.eof%>
<tr bgcolor="#5b5b5b" class="text">
<td width="50"><div align="center"><%=rs("id")%></div></td>
<td width="350"><%=rs("title")%></td>
<td width="50"><a href=admin_edit.asp?id=<%=rs("id")%>>
<div align="center">修改</div></a></td>
<td width="50"><a href=admin_del.asp?id=<%=rs("id")%>><div align="center">刪除</div></a></td>
</tr>
<%
x=x+1
rs.movenext
loop
rs.close
set rs=nothing
end if
conn.close
set conn=nothing
%>
</table>
<p> </p>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -