這是asp分頁列表生成靜態頁面得asp小程序腳本
複製代碼代碼如下:
<!--#includefile="conn.asp"-->
<html><head><TITLE>分頁測試</TITLE><LINKhref="inc/style.css"type=text/cssrel=stylesheet></head>
<%strHead=strHead&"<html>"
strHead=strHead&"<head>"
strHead=strHead&"<TITLE>分頁測試</TITLE>"
strHead=strHead&"<LINKhref=""inc/style.css""type=text/cssrel=stylesheet>"
strHead=strHead&"</head>"
%>
<%
sql="select*fromnews"
setrs=server.createObject("ADODB.Recordset")
rs.opensql,conn,1,1
%><%
rs.pagesize=2
totalpage=rs.pagecount
rs.close
setrs=nothing
forj=1tototalpage
sql="select*fromnews"
setrs=server.createObject("ADODB.Recordset")
rs.opensql,conn,1,1
whichpage=j
rs.pagesize=2
totalpage=rs.pagecount
rs.absolutepage=whichpage
howmanyrecs=0
%><%
str0=""
str0=str0&"</p>"
str0=str0&"<tablebgcolor=#cecfcealign=centerborder=0width=800cellpadding=2cellspacing=1>"
%><%
dowhilenotrs.eofandhowmanyrecs<rs.pagesize
%><%
str0=str0&"<trbgcolor=#f7f7f7>"
str0=str0&"<tdbgcolor=#f7f7f7align=""center"">"&rs(0)&"</td>"
str0=str0&"<tdbgcolor=#f7f7f7align=""center"">"&rs(1)&"</td>"
str0=str0&"<tdbgcolor=#f7f7f7align=""center"">"&rs(2)&"</td>"
str0=str0&"<tdbgcolor=#f7f7f7align=""center"">"&rs(3)&"</td>"
str0=str0&"</tr>"
%><%
rs.movenext
howmanyrecs=howmanyrecs+1
loop
rs.close
setrs=nothing
%><%str0=str0&"</table>"
%><%
'分頁部分
ref=""
ref=ref&"<br>"
ref=ref&"<tablebgcolor=#cecfcealign=centerborder=0width=800cellpadding=0cellspacing=1>"
ref=ref&"<trbgcolor=#f7f7f7>"
ref=ref&"<td>"
ref=ref&"<b>Pages："&j&"/"&totalpage&"</b>"
ref=ref&"</td>"
ref=ref&"<td>"
ref=ref&"<ahref=list_1.html"&">"&"<FONTface=Webdings>9</FONT>"&"</a>"
ifwhichpage=1then
ref=ref&"<FONTface=Webdings>7</FONT>"