citylist.asp

来自「asp的新闻网站」· ASP 代码 · 共 113 行

ASP
113
字号
<%Response.Buffer=true%>
<!--
Programmer:jin kai 
Update:2000.8.14
CopyRight:东宇电子商务
-->

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>已存在城市名称</title>
<script language="javascript" src="check.js"></script>
<link rel=stylesheet href="style.css" type=text/css>
 <!--#include file="../include/odbc.asp" -->
<!--#include file="../include/killStr.asp" -->
<!--#include file="../include/checkUser.asp" -->
<!--#include file="../include/checkServer.asp" -->
<%
'修改:潘树文
'时间:2001年2月9日
%>
</head>
<body bgcolor="#C0C0C0">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><font color="#008080">城市管理:<br>
  </font></td>
</tr>
</table>


<form method="POST" action="cityDel.asp">
<table border="1" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="60%" align="center">已存在城市名称</td>
    <td width="20%" align="center"> </td>
    <td width="20%" align="center"> </td>
  </tr>

<%
Dim rs
Dim sql
Set rs=Server.CreateObject("ADODB.Recordset")
sql = "Select * From weather_city Order By cityID"
rs.open sql,conn,1,2

While Not rs.Eof 

%>  
  
  
  <tr>
    <td width="60%" align="center"><%=rs("cityName")%></td>
    <td width="20%" align="center"><a href="modifyCity.asp?id=<%=rs("cityID")%>" target="_self"><font color="#FF6600">编辑</font></a></td>
    <td width="20%" align="center">
        <p><input type="checkbox" name="del" value="<%=rs("cityID")%>"></p>
    </td>
  </tr>
  
<%
rs.MoveNext
Wend
%>  

  <tr>
    <td width="100%" align="center" colspan="3"> </td>
  </tr>


  <tr>
    <td width="100%" align="center" colspan="3">
      <table border="0" width="100%">
        <tr>
          <td width="50%" align="center"><input type="submit" value="确定删除" name="B1"></td>
          <td width="50%" align="center"><input type="reset" value="重新选择" name="B2"></td>
        </tr>
      </table>
    </td>
  </tr>

</table>
</form>

<hr>

<form method="POST" action="citySave.asp" name=form1  onsubmit="return check(this);">

<table border="1" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="33%">
      <p align="right">增加城市:</td>
    <td width="67%" colspan="2">
        <input type="text" name="Name" size="20"></td>
  </tr>
  <tr>
    <td width="50%" colspan="2" align="center"><input type="submit" value="确    认" name="B1"></td>
    <td width="50%" align="center"><input type="reset" value="重新填写" name="B2"></td>
  </tr>
</table>
      </form>

</body>

</html>
<%
rs.Close
Set rs = nothing
conn.Close
Set conn = nothing
%>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?