plane_query.asp

ASP程序实现的酒店预定系统

frmCalendarSample.tbSelYear.options[i].selected = true;
//  End -->
</script>
    <form name="frmCalendarSample" method="post" action="">
      <input type="hidden" name="calSelectedDate" value="">
      <table border="0" bgcolor="#B5CDE6">
        <tr> 
          <td width="140" height="19" bgcolor="#FCBF6D"></td>
        </tr>
        <tr> 
          <td valign="top" height="20" bgcolor="#FEE8C9"> 
            <select name="tbSelMonth" onchange='fUpdateCal(frmCalendarSample.tbSelYear.value, frmCalendarSample.tbSelMonth.value)'>
              <option value="1">一月</option>
              <option value="2">二月</option>
              <option value="3">三月</option>
              <option value="4">四月</option>
              <option value="5">五月</option>
              <option value="6">六月</option>
              <option value="7">七月</option>
              <option value="8">八月</option>
              <option value="9">九月</option>
              <option value="10">十月</option>
              <option value="11">十一月</option>
              <option value="12">十二月</option>
            </select>
            <select name="tbSelYear" onchange='fUpdateCal(frmCalendarSample.tbSelYear.value, frmCalendarSample.tbSelMonth.value)'>
              <option value="1998">1998</option>
              <option value="1999">1999</option>
              <option value="2000">2000</option>
              <option value="2001">2001</option>
              <option value="2002">2002</option>
              <option value="2003">2003</option>
              <option value="2004">2004</option>
              <option value="2003">2005</option>
              <option value="2003">2006</option>
              <option value="2003">2007</option>
              <option value="2003">2008</option>
              <option value="2003">2009</option>
              <option value="2003">2010</option>
            </select>
          </td>
        </tr>
        <tr> 
          <td height="19" valign="top" bgcolor="#FEE8C9"> 
            <script language="JavaScript">
var dCurDate = new Date();
fDrawCal(dCurDate.getFullYear(), dCurDate.getMonth()+1, 20,20, "12px",  1);
</script>
          </td>
        </tr>
        <tr> 
          <td height="18" valign="top" bgcolor="#FCBF6D"><font color="#FFFFFF" onClick="MM_showHideLayers('Layer1','','hide')">返回</font></td>
        </tr>
      </table>
    </form>
  </div>
  <table width="756" border="0" cellpadding="0" cellspacing="0">
    <tr> 
      <td height="16" valign="top" colspan="14" bgcolor="#336699">&nbsp;</td>
    </tr>
    <tr> 
      <td valign="middle" colspan="3" rowspan="3" align="center"><img src="../../Images/index/images/index22.gif" width="122" height="79"></td>
      <td valign="top" colspan="8" rowspan="2"><img src="../../Images/biao_zy_13.gif" width="525" height="90"></td>
      <td valign="top" height="67" colspan="3">&nbsp;</td>
    </tr>
    <tr> 
      <td height="23" valign="top" colspan="3"><img src="../../Images/zhongwen.gif" width="40" height="22" border="0" onclick="location.href='../../china/index.asp'"> 
        <img src="../../Images/hanwen_kr.gif" width="40" height="22" border="0" onclick="location.href='../index.asp'"> 
      </td>
    </tr>
    <tr> 
      <td height="1" width="70"></td>
      <td width="90"></td>
      <td width="86"></td>
      <td width="91"></td>
      <td width="43"></td>
      <td width="47"></td>
      <td width="90"></td>
      <td width="8"></td>
      <td width="44"></td>
      <td width="37"></td>
      <td width="20"></td>
    </tr>
    <tr> 
      <td valign="top" width="21" height="22" bgcolor="#336699">&nbsp;</td>
      <td width="89" valign="middle" align="left" bgcolor="#336699"><b><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a01" href="../index.asp">首页</a></font> 
        </b></td>
      <td valign="middle" colspan="2" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a02" href="../Hotel/hotel_query.asp">酒店预订</a></font> 
      </td>
      <td valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a03" href="plane_query.asp">机票预订</a></font> 
      </td>
      <td valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a04" href="../CAR/Rentcar.htm">汽车租赁</a></font></td>
      <td valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <a class="a05" href="../City/city_query.asp"><font  size="2">城市指南</font></a> 
      </td>
      <td colspan="2" valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a06" href="../TRIP/TRIP.HTM">旅游指南</a></font> 
      </td>
      <td valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a  class="a07" href="../member/member_query.asp">会员中心</a></font></td>
      <td colspan="3" valign="middle" bgcolor="#336699"><img src="../../Images/biaoti_zy_4.gif" width="4" height="8"> 
        <font  size="2"><a class="a08" href="../Bbs/default.asp">BBS</a></font> 
      </td>
      <td valign="top" bgcolor="#326A94">&nbsp;</td>
    </tr>
    <tr bgcolor="#cacaca"> 
      <td height="22" colspan="8" valign="middle"><font color="#000000" size="2">订位电话</font><font color="#000000">：<font size="2">024－23490652　　800－8907894</font></font></td>
      <td colspan="4" valign="middle" ><font size=2px> 
        <%response.write today %>
        </font> </td>
      <td valign="middle" colspan="2" ><img src="../../Images/calendar.gif" width="43" height="17" onClick="MM_showHideLayers('Layer1','','show')"> 
      </td>
    </tr>
    <tr> 
      <td height="0"></td>
      <td></td>
      <td width="20"></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
  </table>
  </center>
<center>
  <table width="756" border="0" cellpadding="0" cellspacing="0">
    <tr> 
      <td width="176" valign="top" rowspan="2"> 
        <table width="100%"  height="100%" border="0" cellpadding="0" cellspacing="0">
          <tr> 
            <td height="92" valign="top" colspan="2"> 
              <table width="100%" border="0" cellpadding="0" cellspacing="0">
                <tr> 
                  <td width="174" height="81" valign="top"> 
                    <table width="174" border="0" cellpadding="0" cellspacing="0" height="92">
                      <tr> 
                        <td width="125" height="2"></td>
                        <td width="49"></td>
                      </tr>
                      <tr> 
                        <td colspan="2" height="22" valign="top"><img src="../../Images/weekgood.gif" width="174" height="22"></td>
                      </tr>
                      <tr> 
                        <td valign="middle" height="23" align="center" bgcolor="#f1f1f1"> 
                          <p align="center"><font size="2" color="#000000">始-末</font> 
                        </td>
                        <td valign="middle" align="center" bgcolor="#f1f1f1"><font size="2" color="#000000">价格</font></td>
                      </tr>
                      <%sql="Select 航班编码,出发城市_kr,目的城市_kr,特惠价格 from xt_td_plane where 特惠=1"
set rs=conn.execute(sql)
do while not rs.eof%>
                      <tr> 
                        <td height="2"></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="22" valign="middle" align="center" bgcolor="#f1f1f1"><a href="javascript:open1(<%=rs(0)%>)"><font color=#000000 size="2"><%=rs(1) & "-" & rs(2)%></font></a></td>
                        <td valign="top" bgcolor="#f1f1f1"><font size="2"><font color="000000"> 
                          <p align="center"><%=rs(3)%> 
                          </font></font></td>
                      </tr>
                      <%rs.movenext
					
loop%>
                      <tr> 
                        <td height="3"></td>
                        <td></td>
                      </tr>
                      <tr bgcolor="#f1f1f1"> 
                        <td height="16" colspan="2" valign="top">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td height="2"></td>
                        <td></td>
                      </tr>
                    </table>
                  </td>
                </tr>
              </table>
            </td>
            <td width="2"></td>
          </tr>
          <tr> 
            <td height="22" valign="top" colspan="2"><img src="../../Images/userlogin_plan.gif" width="174" height="22"></td>
            <td></td>
          </tr>
          <tr> 
            <td height="316" width="2"></td>
            <td colspan="2" valign="top"> 
              <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
                <form name="loginform" method="post" action="../login.asp">
                  <tr> 
                    <td height="7" width="60"></td>
                    <td width="49"></td>
                    <td width="62"></td>
                    <td width="3"></td>
                  </tr>
                  <tr> 
                    <td valign="middle" height="25" align="center" bgcolor="#f1f1f1"><font size="2" color="#000000">用 
                      户:</font></td>
                    <td colspan="2" valign="middle" bgcolor="#f1f1f1" align="center"> 
                      <input type="text" name="username" size="10" maxlength="10">
                    </td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="2"></td>
                    <td></td>
                    <td></td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="25" valign="middle" align="center" bgcolor="#f1f1f1"><font size="2" color="#000000">密 
                      码:</font></td>
                    <td colspan="2" valign="middle" align="center" bgcolor="#f1f1f1"> 
                      <input type="password" name="password" size="10" maxlength="10">
                    </td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="2"></td>
                    <td></td>
                    <td></td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="29" valign="top" bgcolor="#f1f1f1">&nbsp;</td>
                    <td valign="middle" align="center" bgcolor="#f1f1f1"> 
                      <input style=" BACKGROUND-COLOR: #e6f4ff;
    BORDER-BOTTOM: #0099ff 1px solid;
    BORDER-LEFT: #0099ff 1px solid;
    BORDER-RIGHT: #0099ff 1px solid;
    BORDER-TOP: #0099ff 1px solid;
    COLOR: #336699;
    HEIGHT: 18px;
	width:30px:
    TEXT-ALIGN: center"type="submit" name="Submit" value="登录" class="botton" onclick="return check()">
                    </td>
                    <td valign="middle" bgcolor="#f1f1f1"><img onclick="location.href='../user/user_login.asp'" src="../../Images/zhuce_kr.gif" width="39" height="17"></td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td  colspan="3" height="226" valign="top" bgcolor="#f1f1f1">&nbsp;</td>
                    <td></td>
                  </tr>
                </form>
              </table>
            </td>
          </tr>
          <tr>
            <td height="13"></td>
            <td width="172"></td>
            <td></td>
          </tr>
        </table>
      </td>
      <td width="580" height="439" valign="top"> 
        <table width="565" border="0" cellpadding="0" cellspacing="0">
          <tr> 
            <td width="3" height="439" valign="top"> 
              <table width="100%"  height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#cacaca">
                <tr> 
                  <td width="3" height="439"></td>
                </tr>
              </table>
            </td>