<%
dim n
n=6
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="Select * from sjrjv order by date DESC"
rs.open Sql,conn,3,2
rs.pagesize=6
if rs.Eof then
rs_total = 0
else
rs_total = rs.RecordCount
end if
getpageno = (Request("pageno"))
if(getpageno = "")then
pageno = 1
else
pageno = getpageno
End if
if(not rs.Eof)then
rs.AbsolutePage = pageno
%>
<%
do while not rs.eof
%>
| <%= rs("date") %>
|
 |
|
|
| "><%= rs("title") %>
|
|
<%n=n-1
if n<1 then exit do
rs.movenext
loop
%>
| [<%=pageno%>/<%=rs.PageCount%>] 每页<%=rs.PageSize%>条 共<%=rs_total%>条记录
<%
if(pageno <> 1)then
%>
首页
<%
End if
if(pageno <> 1)then
%>
上一页
<%
end if
if(instr(pageno,cstr(rs.pagecount)) = 0)then
%>
下一页
<%
end if
if(instr(pageno,cstr(rs.pagecount)) = 0)then
%>
尾页
<%
end if
rs.close
Set rs = Nothing
end if
%> |
|
|
|