<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Set conn= Server.CreateObject("ADODB.Connection")
conn.open "Provider=Sqloledb;User ID=sa;Password=sa;Data Source=local;database=;}"
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from tablename"
rs.open sql,conn,1,1
page=request.QueryString("page")
if IsNumeric(page) then
page=cint(page)
if page<1 then page=1
else
page=1
end if
everypage=10
rs.pagesize=everypage
if rs.bof and rs.eof then
response.Write("没有数据")
else
page_count=rs.pagecount
rs.AbsolutePage=page
do while not rs.eof and j<rs.pagesize
response.Write(rs("hotel_name")&"<br>")
j=j+1
rs.movenext
loop
end if
%>
<%
if page=1 then
Response.Write"首页 上一页"
else
Response.Write"<a href=index3.asp?page=1>首页</a> "
Response.Write"<a href=index3.asp?page="&page-1&">上一页</a>"
end if
%>
<%for j=page-4 to page-1%>
<%if j>0 then%>
<a href="index3.asp?page=<%=j%>"><%=j%></a>
<%end if%>
<%next%>
<%
for j=page to page+4
%>
<% if j<=page_count then%>
<%if j=page then%>
<a href="index3.asp?page=<%=j%>">[<%=j%>]</a>
<%else%>
<a href="index3.asp?page=<%=j%>"><%=j%></a>
<%end if%>
<%end if%>
<% next
%>
<%if page<page_count then%>
<a href="index3.asp?page=<%=page+1%>">下一页</a>
<%else%>
下一页
<%end if%>
</body>
</html>
回复此帖
