'打印每页记录
for page=1 to rs.pagesize
if not rs.eof then
response.write (rs("id")&rs("name")&"<br>")
rs.movenext
end if
next
%>
<P>共有<%=rs.pagecount%>页,当前页<%=request.QueryString("page")%>,共有<%=rs.recordcount%>条记录
,<%=request.QueryString("page")%>/<%=rs.pagecount%></p>
<%'判断是否为首页
if request.QueryString("page")<>1 then
'打印带连接的<< <符号%>
<a href=333.asp?page=1>首页</a>
<a href=333.asp?page=<%=request.QueryString("page")-1%>>上一页</a>
<%else
'否则打印不带连接的<< <符号
response.write("首页 上一页")
end if
'判断是否为尾页
if cint(request.QueryString("page"))=rs.pagecount then
'打印不带连接的> >>符号
response.write("下一页 尾页")
else
'否则打印带连接的> >>符号%>
<a href=333.asp?page=<%=request.QueryString("page")+1%>>下一页</a>
<a href=333.asp?page=<%=rs.pagecount%>>尾页</a>
<%end if
rs.close
conn.close%>
intCurPage=Cint(Request.QueryString("Page"))
if intCurPage=0 then intCurPage=1
set adoRec=Server.CreateObject("adodb.recordset")
adoRec.CursorLocation = adUseClient
adoRec.CursorType = adOpenStatic
adoRec.LockType = adLockOptimistic
strSQL="SELECT * FROM " & strTabName
adoRec.Open strSQL,strCnn,,,adcmdtext
If adoRec.Eof then Exit Sub
adorec.pagesize=intpagesize
adorec.absolutepage=intcurpage
intpagenum=adorec.pagecount
if intcurpage >= 1 then
Response.Write "<font class='tb1'>" & _
"「<a href='Edit_hbxw.asp?page=1&tb=" & strTabName & _
"'>首页</a>」</font>"
End if
if intcurpage > 1 then
Response.write "<font class='tb1'>「<a href='Edit_hbxw.asp?page=" & _
intcurpage - 1 & "&tb=" & strTabName & _
"'>上页</a>」</font>"
End if
if intcurpage < intpagenum then
Response.write "<font class='tb1'>「<a href='Edit_hbxw.asp?page=" & _
intcurpage + 1 & "&tb=" & strTabName & _
"'>下页</a>」</font>"
End if
if intcurpage <= intpagenum then
Response.write "<font class='tb1'>「<a href='Edit_hbxw.asp?page=" & _
intpagenum & "&tb=" & strTabName & "'>末页</a>」</font>"
End if
response.write "<font class='tb1'> 共" & adorec.recordcount & "条记录,第" & _
intcurpage & "/" & intpagenum & "页," & intPageSize & _
"条/页 </font>"
adorec.close