⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 plane_query.asp

📁 ASP程序实现的酒店预定系统
💻 ASP
字号:
<!--#include file="../Include/AdoConn.asp"-->
<html>
<head>
<title>城市查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="/Css/All.css">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="80%" border="0" cellspacing="1" cellpadding="0" bgcolor="#000000">
  <tr>
    <td width="81" valign="top"><img src="../Images/help.jpg" width="80" height="200"></td>
    <td valign="top" bgcolor="#FFFFFF"> 
      <table width="80%" border="0" cellspacing="0" cellpadding="0" align="center">
        <form name="form1" method="post" action="plane_List.asp?query=query">
          <tr> 
            <td height="27" align="center"> 航 班 信 息 查 询</td>
          </tr>
          <tr> 
            <td height="151" bgcolor="#FFF5D9" align="center"> 
              <table width="90%" border="1" cellspacing="0" cellpadding="0">
                <tr> 
                  <td height="5" colspan="2"></td>
                </tr>
                <tr> 
                  <td height="25"><font size="2">航班号</font></td>
                  <td height="25"> 
                    <input type="text" name="planeNum" maxlength="20" size="17">
                    &nbsp; </td>   
                </tr>   
                      <%   
		  '取出所有省   
		  strsql="select 中文城市名 from xt_td_city order by 中文城市名"   
		  set rst1=conn.execute(strsql)   
		 %>   
                <tr> 
                  <td height="25"><font size="2">出发城市</font></td>   
                  <td height="25">    
                    <select name="City1">   
                      <option value=""></option>   
<%		  do while not rst1.eof   
		%>   
                      <option value="<%=rst1(0)%>"><%=rst1(0)%></option>   
                      <%rst1.MoveNext    
		loop   
%>   
                    </select>   
                  </td>   
                </tr> 
                <tr>    
                  <td height="25"><font size="2">到达城市</font></td>   
                  <td height="25">    
                    <select name="City2">   
                      <option value=""></option>   
<% rst1.movefirst 
do while not rst1.eof   
		%>   
                      <option value="<%=rst1(0)%>"><%=rst1(0)%></option>   
                      <%rst1.MoveNext    
		loop   
		rst1.close   
%>   
                    </select>   
                  </td>   
                </tr>   
                <tr align="center">    
                  <td colspan="2" bgcolor="#FFFFFF" height="30">    
                    <font size="2">    
                    <input style="BACKGROUND-COLOR:#FFCC00;color:#000000;" type="submit" name="Submit" value="查  询" class="buttonnew">&nbsp;&nbsp;  
                    <input style="BACKGROUND-COLOR:#FFCC00;color:#000000;" name="Submit2" value="重  置" class="buttonnew" type="reset">   
                    </font>   
                  </td>   
                </tr>   
              </table>   
            </td>   
          </tr>   
          <tr>   
            <td height="5" bgcolor="#FFF5D9">    
               
            </td>   
          </tr>   
        </form>   
      </table>   
   
    </td>   
  </tr>   
</table>   
</body>   
</html>   

⌨️ 快捷键说明

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