📄 admin_qiuzu_fy.asp
字号:
<!--#include file=../conn/adodb1.asp -->
<%
if session("cjuser")="" and session("pwdd")="" then
response.write"<SCRIPT language=JavaScript>alert('你没有登录，无权进入！');"
response.write"this.location.href='error.htm';</SCRIPT>"
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/main.css" rel="stylesheet" type="text/css">
</head>
<body link="#000000" vlink="#000000">
<table width="100%" border="0" align="center" cellspacing="0">
<tr>
<td height="10" align="center" >
<%
dim sql,rs
set rs=server.CreateObject("adodb.recordset")
sql=session("sql")
rs.open sql,db,1,1
if rs.recordcount >0 then
dim page_no '定义当前是第几页
if request.querystring("page_no")="" then
page_no=1
else
page_no=cint(request.querystring("page_no"))
end if
rs.pagesize=18
rs.absolutepage=page_no
%>
<table width="100%" border="0" cellpadding="0" cellspacing="1" >
<tr >
<td align="center" class="fenlei"><strong>房源编码</strong></td>
<td align="center" class="fenlei"><strong>房源类别</strong></td>
<td align="center" class="fenlei" ><strong>区域</strong></td>
<td align="center" class="fenlei"><strong>结构</strong></td>
<td align="center" class="fenlei"><strong>楼层</strong></td>
<td align="center" class="fenlei"><strong>价格</strong></td>
<td align="center" class="fenlei"><strong>地址</strong></td>
<td align="center" class="fenlei"><strong>发布时间</strong></td>
<td align="center" class="fenlei"><strong>查看</strong></td>
<td align="center" class="fenlei"><strong>删除</strong></td>
</tr>
<%
dim i
for i=1 to rs.pagesize
%>
<tr width="100%"
onmouseover="this.style.backgroundColor = '#F7FBFF'"
onmouseout="this.style.backgroundColor = '#FFFFFF'">
<td align="center" class="bordbg"><%=rs("fybm")%></td>
<td align="center" class="bordbg"><%=rs("fylb")%></td>
$ <td align="center" class="bordbg"><%=rs("qy")%></td>
<td align="center" class="bordbg"><%=rs("s")%>室<%=rs("t")%>厅<%=rs("w")%>卫</td>
<td align="center" class="bordbg"><%=rs("szc")%></td>
<td align="center" class="bordbg"><%=rs("jg")%> <%=rs("dw")%></td>
<td align="center" class="bordbg"><%=rs("jzmc")%></td>
<td align="center" class="bordbg"><%=rs("fbsj")%></td>
<td align="center" class="bordbg"><a href="ck_qiuzu.asp?id=<%=rs("id")%>" class="fontt" >查看</a></td>
<td align="center" class="bordbg"><a href="admin_qiuzu_del.asp?id=<%=rs("id")%>" class="fontt" >删除</a></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
%>
</table>
<br>
<tr>
<td height="20" align="center" class="font10" >
<%if page_no>1 then %>
<a href="admin_qiuzu_fy.asp?page_no=<%=page_no-1%>" class="font10">[上一页]</a>
<%end if%>
<%
for i=1 to rs.pagecount
if i=page_on then
response.write "["&i&"]"&" "
else
response.write "<a href='admin_qiuzu_fy.asp?page_no="&i&"'>" & i &"</a> "
end if
next
if page_no<rs.pagecount then
%>
<a href="admin_qiuzu_fy.asp?page_no=<%=page_no+1%>" class="font10">[下一页]</a>
<%
end if
%>
共:<%=rs.pagecount%>页
<%else
response.write "没有任何数据!"
end if
%> </td>
</tr></td>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -