28,391
社区成员
发帖
与我相关
我的任务
分享
'这里是页面开头时获取页数和rs记录位置的部分
const maxperpage=30
rs.pagesize=maxperpage
currentpage=request.querystring("pageid")
if currentpage="" then
currentpage=1
end if
if request.form("pid")<>"" then
currentpage=request.form("pid")
end if
if rs.recordcount mod maxperpage=0 then
n=rs.recordcount\maxperpage
else
n=rs.recordcount\maxperpage+1
end if
if not rs.eof then
rs.move(currentpage-1)*maxperpage
end if
'下面是最后"上一页""下一页"的代码
<form name="f3" method="post" action="">
<div align=center>
<%if currentpage<>1 then%>
<A href="index2.asp?pageid=1">首页</A>
<A href="index2.asp?pageid=<%=currentpage-1%>">上一页</A>
<%else%>
首页
上一页
<%end if%>
<%if n>0 and Cint(currentpage)<>Cint(n) then%>
<A href="index2.asp?pageid=<%=currentpage+1%>">下一页</A>
<A href="index2.asp?pageid=<%=n%>">尾页</A>
<%else%>
下一页
尾页
<%end if%>
跳转到第<input type="text" name="pid" size=3><input type="submit" name="B1" value="确定">
共<%=n%>页,目前是第<%=currentpage%>页
</div>
</form>
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 21 AND 40