28,390
社区成员
发帖
与我相关
我的任务
分享
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>任务列表</title>
</head>
<body style="text-align: center">
<!--#include file= "conn.asp"-->
<%
sql_select ="select * from task order by task_id"
set rs=server.createobject("adodb.recordset")
rs.open sql_select,conn,1,1
rs.pagesize=4
epage=0
if request.querystring("page")<>""then
epage=request.querystring("page")
if request.querystring("page")>rs.pagecount then
epage=rs.pagecount
end if
if request.querystring("page")<1 then
epage=1
end if
else epage=1
end if
rs.absolutepage=epage
%>
<table border="1" width="31%" id="table1">当前为<%=epage%>页
<%for i=1 to rs.pagesize
if rs.bof or rs.eof then exit for
%>
<tr>
<td><a href ="<%=rs("task_url")%>"><%=rs("task_name")%></a> </td>
</tr>
<% rs.movenext
next %>
</table>
<p><a href="task_list.asp?page=<%=epage-1%>">上一页</a> <a href="task_list.asp?page=<%=epage+1%>">下一页</a>
<a href="task_list.asp?page=<%=rs.pagecount%>">最后一页</a> 共<%=rs.pagecount%>页 </p>
</body>
<%conn.close()%>
</html>