<%
flag="尚未处理"
set rs=server.createobject("adodb.recordset")
sqltext="select * from news Order BY id desc"
rs.open sqltext,conn,1,1
dim PerPage
PerPage=15
'假如没有数据时
If rs.eof and rs.bof then
call showpages
response.write "
还没任何新闻
"
response.end
End if
'取得页数,并判断用户输入的是否数字类型的数据,如不是将以第一页显示
text="0123456789"
Rs.PageSize=PerPage
for i=1 to len(request("page"))
checkpage=instr(1,text,mid(request("page"),i,1))
if checkpage=0 then
exit for
end if
next
If checkpage<>0 then
If NOT IsEmpty(request("page")) Then
CurrentPage=Cint(request("page"))
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > Rs.PageCount Then CurrentPage = Rs.PageCount
Else
CurrentPage= 1
End If
If not Rs.eof Then Rs.AbsolutePage = CurrentPage end if
Else
CurrentPage=1
End if
call showpages
call list
If Rs.recordcount > PerPage then
call showpages
end if
'显示帖子的子程序
Sub list()%>
<%
if not rs.eof then
do while not rs.eof
%>
"><%=rs("title")%> <%=rs("time")%>
<%if rs("time")=date() then%>
New
<%end if%>
<%
i=i+1
if i >= Perpage then exit do
rs.movenext
loop
end if
%>
<%
Response.write "-> 全部-"
Response.write "共" & "" & Cstr(Rs.RecordCount) & "" & "条新闻 "
Response.write "第" & "" & Cstr(CurrentPage) & "" & "/" & Cstr(rs.pagecount) & " "
If currentpage > 1 Then
response.write "<首页 "
Response.write "上一页 <"
Else
Response.write "上一页 "
End if
If currentpage < Rs.PageCount Then
Response.write "下一页 "
Response.write "尾页 "
Else
Response.write ""
Response.write "下一页 "
End if
'response.write "
"
'response.write "转到: "
'response.write " "
%>
<%
End sub
rs.close
%>
CopyRight 2000 All Rights Reserved 南通电熔爆股份有限公司
版权所有
地址:江苏省南通市任港路35号 电话:0513-3549162 传真:0513-3549128 3549185
建议分辨率:1024×768 技术支持:南通福创网络科技