📄 list.asp
字号:
<% Response.Buffer=True %>
<!--#include file="advoces.asp"-->
<% set rs=server.createobject("adodb.recordset")
sql="select * from bazhu order by id desc"
rs.open sql,conn,1,1
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
rs.pagesize=15
rs.AbsolutePage=pagecount%>
<html>
<head>
<title>更多房租信息!</title>
<!-- 霸猪乐园 E-mail：webmaster@bazhu.com 主页：http://www.bazhu.com QQ:309412-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>房地产频道</title>
<style>
<!-- Style definitions:
.big: biggest font (used on the home page for the date)
.cur: the current channel
.chn: the rest of the channels
.dir: search directories
.sub: search subdirectories
.hdr: headers for sections in outer columns
.itm: items for sections in outer columns
.eng: English text
-->
.big {font-family: Arial, Helvetica, 宋体; font-size: 13pt; font-weight: bold}
.cur {font-family: 宋体; font-size: 9pt; color: #ff0000}
.chn {font-family: 宋体; font-size: 9pt}
.dir {font-family: 宋体; font-size: 11pt; font-weight: bold}
.sub {font-family: 宋体; font-size: 9pt}
.hdr {font-family: 宋体; font-size: 11pt; font-weight: bold}
.itm {font-family: 宋体; font-size: 9pt}
.eng {font-family: Arial, Helvetica, 宋体; font-size: 9pt}
a.hover {color: red}
</style>
</head>
<body bgcolor="#ffffff" link="#000099" alink="#cc0000" vlink="#000099" topmargin="8">
<center>
<table border=0 cellpadding=0 cellspacing=0 height=5 width=700>
<tbody>
<tr>
<td>
<table border=0 cellpadding=0 cellspacing=0 width=700>
<tbody>
<tr>
<td valign=center width="150" height="70"><img src="images/bazhu.gif" width="150" height="78"></td>
<td valign=center width="550" height="70">
<div align="center"><a href="http://www.bazhu.com" target="_blank"><img src="images/guanggao.gif" width="400" height="80" border="0"></a></div>
</td>
</tr>
<tr bgcolor=#009900>
<td align=middle class=chn colspan=3 height=24 noWrap>
<div align="center"><a href="http://www.bazhu.com"
target=_blank>霸猪首页</a> § <a href="http://adidas.home.chinaren/hack/index.htm"
target=_blank>网络安全乐园</a> § <a href="http://adidas.home.chinaren.com/asp/index.htm"
target=_blank>猪家ASP</a> § <a href="http://adidas.home.chinaren.com/pig/index.htm">猪猪影视库</a>
§ <a href="http://adidas.home.chinaren.com/joke/index.htm">猪猪笑话</a>
§ <a
href="http://adidas.home.chinaren.com/loto/index.htm" target=_blank>彩票工具园</a>
§ <a href="http://bbs.6to23.com/1/default.asp?name=bazhu">给我留言</a>
§ </div>
</td>
</tr>
<tr bgcolor=#ccffcc>
<td align=middle class=chn
colspan=3 height=25 noWrap>
<table border=0 cellpadding=0 cellspacing=0 width="100%" height="20">
<tr>
<form action=http://www.es123.com/asp/bz/search.asp>
<td colspan=3 align=middle height="4">
<div align="center">
<input type="text" name="look_for">
<input type="submit" value="猪站检索" name="submit22" style="height : 20; width : 80;">
<a href="http://adidas.home.chinaren.com/addjs.htm">网站登陆</a><font color=#0000ff size=2>
</font></div>
</td>
</form>
</tr>
<tbody> </tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="2" cellspacing="0" width="700">
<tr>
<td>
<table border="0" cellpadding="2" cellspacing="0" width="100%" height="20">
<tr bgcolor="#EBEBEB">
<td width="100%" height="20">
<p class="itm"><a href="http://www.bazhu.com"><font color="#000099">首页</font></a>><font color="#000099"><a href="index.asp">房地产</a>><a href="search.asp">租房查询</a>>租房查询结果列示</font></p>
</td>
</tr>
</table>
<table border=0 cellspacing=3 width="100%">
<tbody>
<tr>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h1.gif" width=32>租房查询</td>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h2.gif" width=32>买商品房</td>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h3.gif" width=32>买二手房</td>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h4.gif" width=32>买房需求</td>
</tr>
</tbody>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
<tr class=chn bgcolor="#FEF0D1">
<td width="60%" height="20" class="itm" bgcolor="#FEF0D1"><b>总共查到<font color="#0000AE"><%=rs.recordcount%></font>条记录,
页次:<font color="#0000AE"><%=pagecount%></font>/<%=rs.pagecount%></b>(每页显示15条记录)</td>
<td width="40%" height="20" class="itm" align="right">按价格排序 按居室排序</td>
</tr>
<tr valign="top">
<td height="20" colspan="2">
<table border=0 width="100%">
<tr>
<td align=center width="67" class=chn bgcolor="#FFF9F0">时间</td>
<td align=center width="71" class=chn bgcolor="#FFF9F0">租金</td>
<td align=center width="93" class=chn bgcolor="#FFF9F0">户型</td>
<td align=center width="74" class=chn bgcolor="#FFF9F0">面积</td>
<td align=center width="157" class=chn bgcolor="#FFF9F0">地理位置</td>
<td align=center width="61" class=chn bgcolor="#FFF9F0">区位</td>
<td align=center width="48" class=chn bgcolor="#FFF9F0">城市</td>
<td align=center width="89" class=chn bgcolor="#FFF9F0">详细描述</td>
</tr>
<% do while not rs.eof %>
<tr>
<td align=center width="67" class=chn bgcolor="#FEF0D1"><%=rs("time")%></td>
<td align=center width="71" class=chn bgcolor="#FEF0D1"><%=rs("price_beg")%>-<%=rs("price_end")%><%=rs("unit")%></td>
<td align=center width="93" class=chn bgcolor="#FEF0D1"> <%=rs("living_room")%><%=rs("sitting_room")%><%=rs("toilet")%></td>
<td align=center width="74" class=chn bgcolor="#FEF0D1"><%=rs("con_beg")%></td>
<td align=center width="157" class=chn bgcolor="#FEF0D1"><%=rs("wlwz")%></td>
<td align=center width="61" class=chn bgcolor="#FEF0D1"><%=rs("district")%></td>
<td align=center width="48" class=chn bgcolor="#FEF0D1">
<% if len(rs("city"))>18 then%>
<%=left(rs("city"),15)%>...
<% else%>
<%=rs("city")%>
<%end if%>
</td>
<td align=center width="89" class=chn bgcolor="#FEF0D1"><a href="show.asp?id=<%=rs("id")%>" target="_blank">查看全部信息</a></td>
</tr>
<tr>
<td align=center width="67" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="71" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="93" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="74" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="157" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="61" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="48" class=chn bgcolor="#FFF9F0"> </td>
<td align=center width="89" class=chn bgcolor="#FFF9F0"> </td>
</tr>
<% n=n+1
rs.movenext
if n>=rs.pagesize then exit do
loop %>
<tr>
<td align=right colspan=8 valign=top class="itm" bgcolor="#FEF0D1">
<%if pagecount=1 and rs.pagecount<>pagecount then%><a href="list.asp?page=<%=cstr(pagecount+1)%>">
<font color="#000000">下一页</font><a>
<% end if %>
<% if rs.pagecount>1 and rs.pagecount=pagecount then %><a href="list.asp?page=<%=cstr(pagecount-1)%>">
<font color="#000000">上一页</font><a>
<%end if%>
<%if pagecount<>1 and rs.pagecount<>pagecount then%><a href="list.asp?page=<%=cstr(pagecount-1)%>">
<font color="#000000">上一页</font><a> <a href="list.asp?page=<%=cstr(pagecount+1)%>">
<font color="#000000">下一页</font><a>
<%end if%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border=0 cellpadding=0 cellspacing=3 width="100%">
<tr class="itm">
<td colspan="3" >
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr class="chn">
<td width="44%"> </td>
<td width="28%" align="center" bgcolor="#CCCCFF" >
<div align="center"><a href="javascript:window.close()"><b>关闭窗口</b></a></div>
</td>
<td width="28%" bgcolor="#CCCCFF" align="center"><b><a href="fb.asp">发布求租信息</a></b></td>
</tr>
</table><form action=search.asp method=post name=house onSubmit="return check()">
<tr>
<td colspan="3" class="itm" bgcolor="#FEF0D1"> <b>高级查询</b>
<tr>
<td align=right vlign=top width="37%" class="itm" bgcolor="#FFFDFB">
<b>城市-</b></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -