📄 citylist.asp
字号:
<!--#include file="../function/connect.asp"-->
<%
meth=request("meth")
if meth="del" and request("City_ID")<>"" then
strsql="delete from Dict_Cities where City_ID in (" & request("City_ID") &")"
objConn.execute strsql
end if
PY_Code=request("PY_Code")
City=request("City")
Area_Code=request("Area_Code")
strsql="select ci.*,co.Country,p.Province from Dict_Cities ci,Dict_Countries co,Dict_Provinces p where ci.Country_ID=co.Country_ID and p.Province_ID=ci.Province_ID "
if PY_Code<>"" then
strsql=strsql & " and ci.PY_Code like '%" & PY_Code & "%'"
end if
if City<>"" then
strsql=strsql & " and ci.City like '%" & City & "%'"
end if
if Area_Code<>"" then
strsql=strsql & " and ci.Area_Code like '%" & Area_Code & "%'"
end if
Set objRs = Server.CreateObject("adodb.recordset")
objRs.Open strsql,objConn,1,1
%>
<html>
<head>
<title>国家</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../cssD.css" rel=stylesheet>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolorlight='#000000' bordercolordark='#FFFFFF'>
<form name="form1" method="post" action="Citylist.asp">
<tr class="tablehead">
<td width="4%"> </td>
<td width="20%" nowrap>
<div align="center">城市</div>
</td>
<td width="19%" nowrap>
<div align="center">拼音码</div>
</td>
<td width="19%" nowrap>
<div align="center">区号</div>
</td>
<td width="19%" nowrap>
<div align="center">国家/地区</div>
</td>
<td width="19%" nowrap>
<div align="center">邮编</div>
</td>
<td width="19%" nowrap>
<div align="center">省份</div>
</td>
</tr>
<%if not objrs.eof then
do while not objrs.eof
%>
<tr align="center">
<td width="4%" class="tablehead">
<input type="checkbox" name="City_ID" value="<%=objrs.fields("City_ID")%>">
</td>
<td width="20%" nowrap> <%=objrs.fields("City")%></td>
<td width="19%" nowrap> <%=objrs.fields("PY_Code")%></td>
<td width="19%" nowrap> <%=objrs.fields("Area_Code")%></td>
<td width="19%" nowrap> <%=objrs.fields("Country")%></td>
<td width="19%" nowrap> <%=objrs.fields("ZIP")%></td>
<td width="19%" nowrap> <%=objrs.fields("Province")%></td>
</tr>
<%
objrs.movenext
loop
end if%>
<input type="hidden" name="meth" value="">
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -