<%set rsnews=server.CreateObject("adodb.recordset")
sqlnews="select * from t_news where n_tsid='"&n_tsid&"' order by n_fpath desc"
rsnews.open sqlnews,cnn,1,1
if rsnews.recordcount<>0 then
Page=clng(request("page"))
end if
if page<1 then
page=1
end if
if page>rsnews.pagecount then
page=rsnews.pagecount
end if
if request("page")<>"" then
rsnews.absolutePage=request("page")
end if
do while not rsnews.eof and rowcount > 0%>
这里是你想要显示的内容。
下面是分页连接。
<table width="85%" height="26" border="0" align="right" cellpadding="0" cellspacing="0" class="bod">
<tr bgcolor="#FFFFFF">
<td height="25"> 共<%=rsnews.recordcount%>条纪录</td>
<td>页数:<%=page%>/<%=rsnews.pagecount%></td>
<%if page=0 then
else
if page<>1 then %>
<td><a href="newslist.asp?page=1&n_tsid=<%=n_tsid%>">第一页</a></td>
<td><a href="newslist.asp?page=<%=page-1%>&n_tsid=<%=n_tsid%>">上一页</a></td>
<%end if
end if
if page<> rsnews.pagecount then %>
<td><a href="newslist.asp?page=<%=page+1%>&n_tsid=<%=n_tsid%>">下一页</a></td>
<td><a href="newslist.asp?page=<%=rsnews.pagecount%>&n_tsid=<%=n_tsid%>">最后一页</a></td>
<% rsnews.close
end if%>
</tr>
</table>
' 首先输出表头,这里是自动取出表的各个字段名称
dim howmanyfields,i,j
howmanyfields=rs.Fields.Count-1 '获取当前表的字段个数
response.write "<TABLE border=1 align=center>"
response.write "<tr>"
for i= 0 to howmanyfields
response.write "<TD><B>" & rs(i).name & "</B></TD>"
next
' 然后根据当前页面序号和页面大小输出范围内的每一条记录
i=0
do while not rs.eof and i<maxperpage
response.write "<tr align=middle>"
for j=0 to howmanyfields
response.write "<td>" & rs(j) & " </td>"
next
response.write "</tr>"
i=i+1
rs.movenext
loop
response.write "</TABLE>"
%>
<!-- 下面开始输出翻页链接,可以把HTML代码与asp命令混合使用,
也可以全部采用response.write输出,这里采用前者
-->
<P><center><hr width="70%">
<% if CurrentPage>1 then %>
[<b><a href='access-page.asp?page=1'>首页</a></b>]
[<b><a href='access-page.asp?page=<%=cstr(CurrentPage-1)%>'>上一页</a></b>]
<% else %>
[首页] [上一页]
<%
end if
if CurrentPage<rs.PageCount then
%>
[<b><a href='access-page.asp?page=<%=cstr(CurrentPage+1)%>'>下一页</a></b>]
[<b><a href='access-page.asp?page=<%=cstr(rs.PageCount)%>'>尾页</a></b>]
<% else %>
[下一页] [尾页]
<% end if %>
</center>
<hr width="70%">
</P>
<% ' 关闭数据库连接和记录集
rs.close
set rs=nothing
conn.close
set conn=nothing
%>