📄 all.asp
字号:
<%st=timer()%>
<% Response.Buffer = True %>
<!--#include file="config.asp" -->
<!--#include file="ad.asp" -->
<%
dim pov,i,j
pov=array("广东","辽宁","江苏","湖北","四川","山西","陕西","河北","河南","吉林","山东","安徽","浙江","福建","湖南","广西","江西","贵州","云南","西藏","海南","甘肃","宁夏","青海","新疆","黑龙江","内蒙古")
set rs=server.CreateObject("adodb.recordset")
set rszx=server.CreateObject("adodb.recordset")
set rsparty=server.CreateObject("adodb.recordset")
set rsbook=server.CreateObject("adodb.recordset")
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name=keywords content="<%=sitekeywords%>">
<meta name="description" content="<%=sitedescription%>">
<title>城市地图 -- <%=sitename%></title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="2" oncontextmenu="self.event.returnValue=false" >
<noscript><iframe src="*.htm"></iframe></noscript>
<div align="<%=sitealign%>">
<!--#include file="title.asp" -->
<table border="0" cellpadding="3" cellspacing="1" bgcolor="#0099FF" width="760">
<tr>
<td width="200" bgcolor="#0099FF" style="font-size: 10pt; color: #FFFFFF; font-weight:bold" height="35"> 城市地图</td>
<td width="550" align="right" bgcolor="#99CCFF"><a href="add_city.asp">添加城市</a> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" colspan="2" height="74" width="740">
<table border="0" cellpadding="10" cellspacing="0" style="border-collapse: collapse" width="733">
<tr>
<td bgcolor="#99FF99">说明：城市名后（<font color="#FF0000">A</font>|<font color="#008000">B</font>|<font color="#0000FF">C</font>）
<font color="#FF0000">A表示该城市资讯信息数 </font>|<font color="#008000">
B表示该城市聚会信息数 </font>|<font color="#0000FF"> C</font><font color="blue">表示该城市留言数</font></td>
</tr>
</table>
<table border="0" cellpadding="3" cellspacing="3" bgcolor="#FFFFFF" style="border-collapse: collapse">
<tr>
<td width="120" height="33" align="center" bgcolor="#99CCFF" style="letter-spacing: 5; font-size: 10pt; font-weight: bold" height="35">直辖市</td>
<td width="600" align="left" style='letter-spacing: 1; font-size: 10pt;'><a alt='查看〖北京〗的信息' href='city.asp?ct=010'>北京</a><%
rszx.open "select * from xinxi where 审核=-1 and 城市='010'",conn,1,1
response.write ("(<a style='color:red' alt='〖北京〗共有 "&rszx.recordcount&" 条资讯信息' href='city.asp?ct=010'>" &rszx.recordcount&"</a>")
rszx.close
rsparty.open "select * from party where 审核=-1 and 城市='010'",conn,1,1
response.write ("|<a style='color:green' alt='〖北京〗共有 "&rsparty.recordcount&" 条聚会信息' href='cityparty.asp?ct=010'>" &rsparty.recordcount&"</a>")
rsparty.close
rsbook.open "select * from citybook where 城市区号='010'",conn,1,1
response.write ("|<a style='color:blue' alt='〖北京〗共有 "&rsbook.recordcount&" 条城市留言' href='citybook.asp?ct=010'>" &rsbook.recordcount&"</a>)")
rsbook.close
response.write (" ")%><a alt='查看〖上海〗的信息' href='city.asp?ct=021'>上海</a><%
rszx.open "select * from xinxi where 审核=-1 and 城市='021'",conn,1,1
response.write ("(<a style='color:red' alt='〖上海〗共有 "&rszx.recordcount&" 条资讯信息' href='city.asp?ct=021'>" &rszx.recordcount&"</a>")
rszx.close
rsparty.open "select * from party where 审核=-1 and 城市='021'",conn,1,1
response.write ("|<a style='color:green' alt='〖上海〗共有 "&rsparty.recordcount&" 条聚会信息' href='cityparty.asp?ct=021'>" &rsparty.recordcount&"</a>")
rsparty.close
rsbook.open "select * from citybook where 城市区号='021'",conn,1,1
response.write ("|<a style='color:blue' alt='〖上海〗共有 "&rsbook.recordcount&" 条城市留言' href='citybook.asp?ct=021'>" &rsbook.recordcount&"</a>)")
rsbook.close
response.write (" ")%><a alt='查看〖天津〗的信息' href='city.asp?ct=022'>天津</a><%
rszx.open "select * from xinxi where 审核=-1 and 城市='022'",conn,1,1
response.write ("(<a style='color:red' alt='〖天津〗共有 "&rszx.recordcount&" 条资讯信息' href='city.asp?ct=022'>" &rszx.recordcount&"</a>")
rszx.close
rsparty.open "select * from party where 审核=-1 and 城市='022'",conn,1,1
response.write ("|<a style='color:green' alt='〖天津〗共有 "&rsparty.recordcount&" 条聚会信息' href='cityparty.asp?ct=022'>" &rsparty.recordcount&"</a>")
rsparty.close
rsbook.open "select * from citybook where 城市区号='022'",conn,1,1
response.write ("|<a style='color:blue' alt='〖天津〗共有 "&rsbook.recordcount&" 条城市留言' href='citybook.asp?ct=022'>" &rsbook.recordcount&"</a>)")
rsbook.close
response.write (" ")%><a alt='查看〖重庆〗的信息' href='city.asp?ct=023'>重庆</a><%
rszx.open "select * from xinxi where 审核=-1 and 城市='023'",conn,1,1
response.write ("(<a style='color:red' alt='〖重庆〗共有 "&rszx.recordcount&" 条资讯信息' href='city.asp?ct=023'>" &rszx.recordcount&"</a>")
rszx.close
rsparty.open "select * from party where 审核=-1 and 城市='023'",conn,1,1
response.write ("|<a style='color:green' alt='〖重庆〗共有 "&rsparty.recordcount&" 条聚会信息' href='cityparty.asp?ct=023'>" &rsparty.recordcount&"</a>")
rsparty.close
rsbook.open "select * from citybook where 城市区号='023'",conn,1,1
response.write ("|<a style='color:blue' alt='〖重庆〗共有 "&rsbook.recordcount&" 条城市留言' href='citybook.asp?ct=023'>" &rsbook.recordcount&"</a>)")
rsbook.close
response.write (" ")%>
</td>
</tr>
<%
for i=0 to Ubound(pov)
rs.open "select * from city where 审核=-1 and 省份='"& pov(i) &"'order by 省份 desc,编号",conn,1,1
response.write ("<tr><td height=33 align='center' bgcolor='#99CCFF'style='letter-spacing: 5; font-size: 10pt; font-weight: bold'>" &pov(i) & "</td><td align='left' style='letter-spacing: 1; font-size: 10pt;'>")
j=1
Do while not rs.eof
response.write ("<a alt='查看〖"&rs("城市")&"〗的信息' href='city.asp?ct="& rs("区号") &"'>"&rs("城市")&"</a>")
rszx.open "select * from xinxi where 审核=-1 and 城市='"& rs("区号") &"'",conn,1,1
response.write ("(<a style='color:red' alt='〖"&rs("城市")&"〗共有 "&rszx.recordcount&" 条资讯信息' href='city.asp?ct="& rs("区号") &"'>" &rszx.recordcount&"</a>")
rszx.close
rsparty.open "select * from party where 审核=-1 and 城市='"& rs("区号") &"'",conn,1,1
response.write ("|<a style='color:green' alt='〖"&rs("城市")&"〗共有 "&rsparty.recordcount&" 条聚会信息' href='cityparty.asp?ct="& rs("区号") &"'>" &rsparty.recordcount&"</a>")
rsparty.close
rsbook.open "select * from citybook where 城市区号='"& rs("区号") &"'",conn,1,1
response.write ("|<a style='color:blue' alt='〖"&rs("城市")&"〗共有 "&rsbook.recordcount&" 条城市留言' href='citybook.asp?ct="& rs("区号") &"'>" &rsbook.recordcount&"</a>)")
rsbook.close
response.write (" ")
rs.movenext
if j mod 5=0 then response.write("<br>") end if
j=j+1
loop
response.write ("</td></tr>")
rs.close
next
set rs=nothing
set rszx=nothing
set rsparty=nothing
set rsbook=nothing
%>
</table>
</td>
</tr>
</table>
<!--文字广告，ad.asp--> <%call ad_bottom()%>
<!--#include file="copyright.asp" -->
</div>
</body></html>
<%
et=timer()
response.write("<br><div align=center>加载网页总用时 "&int((et-st)*1000000)/1000&" ms</div><br><br>")
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -