主题:  分页终结者(I)

wowomo

职务:普通成员
等级:1
金币:1.0
发贴:309
注册:2001/1/12 21:01:58
#12001/2/24 17:06:14
对ud提供的分页功能,我就不多说了,容易得很但是不是很方便,
而网上的插件功能估计也是有限,所以跟大家分享我的代码,希望
可以有帮助。欢迎指正,共同学习,共同进步!

为了大家用起来方便,我将代码写得很简单,轻松改一下就可以
用到你的网页上。

此贴算是对关于分页的几贴的回答,今天很忙,所以到现在才有时
间回答。

<%@language="VBSCRIPT"%>


<%


sqlstmt = "select * from mrzl order by adddate desc"

' get page size
pagesize = request("pagesize")
if pagesize = "" then
    pagesize = 10
end if

' get current page
currentpage = request("currentpage")
if currentpage = "" then
    currentpage = 1
end if

sqlquery = request("sqlquery")
if sqlquery = "" then
    sqlquery = sqlstmt
end if

set conn2 = server.createobject("Adodb.recordset")
set conn2.activeconnection = nothing
conn2.cursorlocation = aduseclient
conn2.cachesize = 5
conn2.open sqlquery,connstr

%>


两极哲理网站管理系统






















 








增加新哲理
| 旧哲理维护






<%
if conn2.bof or conn2.eof then
%>



<%
else
conn2.movefirst
conn2.pagesize = pagesize
allpage = CInt(conn2.pagecount)
maxrecs = CInt(conn2.recordcount)
conn2.absolutepage = currentpage
recshere = 0
%>













<%
' Now loop to out put all record in current page!
Do until conn2.eof or recshere >= Cint(pagesize)
%>







<%
conn2.movenext
recshere = recshere+1
LOOP
end if

conn2.close ' close the connection
set conn2 = nothing ' destroy it

sub PageNavBar()
pad = " "
code = request.servervariables("script_name")&"?"
response.write "
每日更新维护
No record Found!

<%=maxrecs%> entries/<%=allpage%> pages found.You are in page <%=currentpage%>

<%call PageNavBar%>
号码 内容 操作 状态 更新时间
<%=conn2(0)%> <%=left(conn2(1), 12)%>   <%=conn2(2)%> <%=conn2(3)%>
"
response.write ""
         response.write ""
         response.write "
"
if Cint(currentpage) < allpage then
code = request.servervariables("script_name")&"?"
link = "Next Page"
response.write "::"&link
end if

if currentpage > 1 then
code = request.servervariables("script_name")&"?"
link = "Prev Page"
response.write "::"&link
end if
response.write "
"
         response.write ""
if (currentpage mod pagesize) = 0 then
counterstart = currentpage - 9
else
counterstart = currentpage - (currentpage mod pagesize) + 1
end if

counterend = counterstart+9
if counterend > allpage then
counterend = allpage
end if

if counterstart <> 1 then
link = "first :: "
response.write link

link = "Prev"
response.write "::"&link
end if

response.write "["
for counter = counterstart to counterend
if counter >= 10 then pad = "" end if

if counter <> currentpage then

link = ""&pad&counter&""
else
link = ""&pad&counter&""
end if

response.write link

if counter <> counterend then
response.write " "
end if
next
response.write "]"

if counterend <> allpage then
link = "Next :: "
response.write link

link = "last"
response.write "::"&link
end if

response.write "
"
         response.write "
"
end sub
%>

<%call PageNavBar%>