28,391
社区成员
发帖
与我相关
我的任务
分享
<%response.Charset = "gb2312"%>
<!--#include file="Conn.asp"-->
<%
sub echo(str)
response.write str
response.flush
end sub
%>
<%
Set rs=Server.CreateObject("Adodb.Recordset")
sql="select * from Sorttwo"
rs.open sql,Conn,1,1
rs.pagesize = 5
CurPage = request("CurPage")
if CurPage = "" then CurPage = 1
rs.absolutepage = CurPage
for i = 1 to rs.pagesize
echo rs("Sorttwo_Name") & "<br>"
if not rs.eof then rs.movenext
if rs.eof then exit for
next
%>
<a href="?curpage=<%=rs.pagecount/rs.pagecount%>">首页</a>
<%
if CurPage = 1 then
echo "上一页"
else
echo "<a href='?curpage="&CurPage-1&" '>上一页 </a> "
end if
if rs.pagecount<CurPage+1 then
echo "下一页"
else
echo "<a href='?curpage="&CurPage+1&" '>下一页 </a>"
end if
echo "共"&rs.pagecount&"页 "
echo "当前第"&CurPage&"页"
%>
<a href="?curpage=<%=rs.pagecount%>">尾页</a>
<%
echo "<select onchange='javascript:location.href=/test.asp?hello= '>"
for i =1 to rs.pagecount
echo "<option><a href=' ?curpage="&i&" '>第"&i&"页</a></option>"
next
echo "</select>"
%>