28,390
社区成员
发帖
与我相关
我的任务
分享
<html>
<body>
<%
set conn=server.createobject("adodb.connection")
conn.open("DRIVER=Microsoft Access Driver (*.mdb);UID=admin;pwd=;dbq="&server.mappath("data.mdb"))
set rs=server.createobject("adodb.recordset")
sql="select * from student"
rs.open sql,conn,1,1
if rs.recordcount<>0 then
rs.pagesize=10
if request("page")<>"" then
epage=cint(request("page"))
if epage<1 then epage=1
if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
pagecount=rs.pagecount
pagesize=rs.pagesize
rs.absolutepage=epage
else
pagesize=1
epage=1
pagecount=1
end if
response.write rs.pagesize
%>
<table border="0" cellpadding="0" cellspacing="1" bgcolor="#0000FF" width="80%" align="center">
<tr bgcolor="#FFFFFF" align="center">
<th><%=rs(0).name%></th><th><%=rs(1).name%></th><th><%=rs(2).name%></th>
</tr>
<%
for i=0 to pagesize-1
if rs.bof or rs.eof then exit for
%>
<tr bgcolor="#FFFFFF" align="center">
<td><%=rs(0).value%></td><td><%=rs(1).value%></td><td><%=rs(2).value%></td>
</tr>
<%
rs.movenext()
next
%>
</table>
<p align="center">
<a href="test.asp">首页</a>
<%if epage=1 then%>上一页
<%else%><a href="test.asp?page=<%=epage-1%>">前一页</a>
<%end if%>
<%if epage=pagecount then%>下一页
<%else%><a href="test.asp?page=<%=epage+1%>">后一页</a>
<%end if%>
<a href="test.asp?page=<%=pagecount%>">末页</a>
<span>第<%=epage%>页 共<%=pagecount%>页</span>
<select id="name" name="page" size="1"
onchange="window.location='test.asp?page='+this.options[this.selectedIndex].value">
<%
for j=1 to pagecount
if j=epage then
%><option value="<%=j%>" selected>第<%=j%>页</option><%
else%><option value="<%=j%>">第<%=j%>页</option><%
end if
next%></select>
</p>
<%
rs.close
conn.close
%>
</body>
</html>
<a href=loans.asp?pagenum=1>