查人人中国名人网三国志13名品给别人:熟悉asp的朋友,这种分页显示方法会带来什么后果?
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/10 10:11:53
<%
'Maybe we can find a better way
dim k, m
k = 1
do while (k < int(current_page_id))
m = 0
do while ((not rs.eof) and (m < recorder_num_per_page))
rs.movenext
m = m + 1
loop
k = k + 1
loop
m = 0
do while ((not rs.eof) and (m < recorder_num_per_page))
%>
显示请求页的每一项
<%
rs.movenext
loop
%>
'Maybe we can find a better way
dim k, m
k = 1
do while (k < int(current_page_id))
m = 0
do while ((not rs.eof) and (m < recorder_num_per_page))
rs.movenext
m = m + 1
loop
k = k + 1
loop
m = 0
do while ((not rs.eof) and (m < recorder_num_per_page))
%>
显示请求页的每一项
<%
rs.movenext
loop
%>
浪费速度,占用内存.
你应该这样比较节省点:
先得到每页多少条数据,
再得到要显示第几页,
然后得到总记录的条数,
通过上面几个数据,计算出来要显示的这页是第几条到第几条.
然后再用SQL去查询,查询的时候就直接查询出该页的所有记录
然后用循环全部输出即可.