city_query.asp

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

                  <tr> 
                    <td height="25" valign="middle" align="center"><font size="2" color="#000000">密 
                      码:</font></td>
                    <td colspan="3" valign="middle" align="left"> 
                      <input type="password" name="password" size="10" maxlength="10">
                    </td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="29"></td>
                    <td></td>
                    <td valign="middle" align="center"> 
                      <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"><img src="../../Images/zhuce.gif" width="39" height="17" usemap="#Map5" border="0"></td>
                    <td></td>
                  </tr>
                  <tr> 
                    <td height="190"></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                  </tr>
                </form>
              </table>
            </td>
          </tr>
        </table>
      </td>
      <td width="572" valign="top"> 
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr> 
            <td width="5" rowspan="2" valign="top"> 
              <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#cacaca">
                <tr> 
                  <td width="5" height="473"></td>
                </tr>
              </table>
            </td>
            <td width="567" valign="top" height="467"> 
              <table width="100%" border="0" cellpadding="0" cellspacing="0">
                <tr> 
                  <td width="567" valign="top" height="467"> 
                    <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#d9e7eb">
                      <tr> 
                        <td height="228" width="20"></td>
                        <td width="347" valign="middle" align="center" bgcolor="#d9e7eb"><img src="../../Images/map.gif" width="289" height="209" usemap="#Map" border="0" href="hotel_query.asp?province=%BD%AD%CB%D5"> 
                          <map name="Map"> 
                            <area shape="rect" coords="123,166,153,178" href="city_query.asp?province=云南" alt="">
                            <area shape="rect" coords="161,170,191,182" href="city_query.asp?province=广西" alt="">
                            <area shape="rect" coords="155,190,181,202" href="city_query.asp?province=海南" alt="">
                            <area shape="rect" coords="195,184,223,195" href="city_query.asp?province=澳门" alt="">
                            <area shape="rect" coords="193,170,221,181" href="city_query.asp?province=广东" alt="">
                            <area shape="rect" coords="224,177,252,187" href="city_query.asp?province=香港" alt="">
                            <area shape="rect" coords="253,167,282,178" href="city_query.asp?province=台湾" alt="">
                            <area shape="rect" coords="223,155,252,166" href="city_query.asp?province=福建" alt="">
                            <area shape="rect" coords="182,154,214,164" href="city_query.asp?province=湖南" alt="">
                            <area shape="rect" coords="153,154,180,164" href="city_query.asp?province=贵州" alt="">
                            <area shape="rect" coords="43,121,72,135" href="city_query.asp?province=西藏" alt="">
                            <area shape="rect" coords="149,140,177,151" href="city_query.asp?city=重庆" alt="">
                            <area shape="rect" coords="123,125,151,137" href="city_query.asp?province=四川" alt="">
                            <area shape="rect" coords="238,138,269,150" href="city_query.asp?province=浙江" alt="">
                            <area shape="rect" coords="207,140,234,152" href="city_query.asp?province=江西" alt="">
                            <area shape="rect" coords="183,127,213,139" href="city_query.asp?province=湖北" alt="">
                            <area shape="rect" coords="214,123,242,135" href="city_query.asp?province=安徽" alt="">
                            <area shape="rect" coords="247,123,275,135" href="city_query.asp?city=上海" alt="">
                            <area shape="rect" coords="221,110,251,120" href="city_query.asp?province=江苏" alt="">
                            <area shape="rect" coords="189,110,218,122" href="city_query.asp?province=河南" alt="">
                            <area shape="rect" coords="158,109,188,121" href="city_query.asp?province=陕西" alt="">
                            <area shape="rect" coords="132,99,164,110" href="city_query.asp?province=宁夏" alt="">
                            <area shape="rect" coords="95,98,121,110" href="city_query.asp?province=青海" alt="">
                            <area shape="rect" coords="36,65,66,77" href="city_query.asp?province=新疆" alt="">
                            <area shape="rect" coords="103,75,131,87" href="city_query.asp?province=甘肃" alt="">
                            <area shape="rect" coords="141,73,185,85" href="city_query.asp?province=内蒙古" alt="">
                            <area shape="rect" coords="178,95,207,105" href="city_query.asp?province=山西" alt="">
                            <area shape="rect" coords="210,95,242,105" href="city_query.asp?province=山东" alt="">
                            <area shape="rect" coords="196,83,226,94" href="city_query.asp?province=河北" alt="">
                            <area shape="rect" coords="228,83,257,94" href="city_query.asp?city=天津" alt="">
                            <area shape="rect" coords="196,68,229,82" href="city_query.asp?city=北京" alt="">
                            <area shape="rect" coords="249,46,278,58" href="city_query.asp?province=吉林" alt="">
                            <area shape="rect" coords="241,24,288,36" href="city_query.asp?province=黑龙江" alt="">
                            <area shape="rect" coords="230,65,260,76" href="city_query.asp?province=辽宁" alt="">
                          </map>
                        </td>
                        <td width="200" valign="top" bgcolor="#d9e7eb"> 
                          <%                                                                       
				if Request("province")<>"" then '根据查询界面生成查询语                                                                                                    
        			sqlrs="select 中文城市名,韩文城市名,城市编码 from xt_td_city where 所在省='"+Request("province")+"'"                                                                                                    
                else                                                                      
        			sqlrs="select 中文城市名,韩文城市名,城市编码 from xt_td_city where 所在省='辽宁'"                                                                                                    
                end if     				                                                                                                    
			%>
                          <!-- #include file="../../Include/AdoDBOpen.asp" -->
                          <table width="200" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td align="center" bgcolor="#92C9C9" height="20">*<font size="2">城市列表</font>*</td>
                            </tr>
                          </table>
                          <table width="200" border="0" cellpadding="0" cellspacing="0">
                            <%                                                                           
              i=0                                                                                           
				do while (not rs.eof)                                                                                          
			      if (i mod 2)=0 then                                                                                                 
			  %>
                            <tr> 
                              <td height="7" width="25%" align="center"><a href=<%="city_detail.asp?city=" & rs(2) & "&province=" & request("province")%>><font size=2 color="#000000"><%=rs(0)%></font></a></td>
                              <td height="7" width="25%"><font size=2><font color="#000000"><%=rs(1)%></font></font></td>
                            </tr>
                            <%else%>
                            <tr bgcolor="#326B94"> 
                              <td height="7" width="25%" align="center" bgcolor="#fff1dd"><a href=<%="city_detail.asp?city=" & rs(2) & "&province=" & request("province")%>><font size=2 color="#ffffff"><%=rs(0)%></font></a></td>
                              <td height="7" width="25%" bgcolor="#fff1dd"><font size=2 ><font color="#000000"><%=rs(1)%></font></font></td>
                            </tr>
                            <%end if%>
                            <%                                                                                                     
				rs.movenext '纪录指针下移                                                                                                     
				i=i+1                                                                                                     
				loop                                                                                                     
				%>
                          </table>
                        </td>
                      </tr>
                      <tr> 
                        <td colspan="3" valign="top" height="168"> 
                          <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#d9e7eb">
                            <tr> 
                              <td valign="top" height="5" colspan="2">&nbsp;<b>推荐国内著名景点列表</b></td>
                              <td valign="top" height="5"></td>
                            </tr>
                            <tr> 
                              <td width="63" valign="middle" align="center" bgcolor="#ffcc00"><a name="ddd"><font color="#FFFFFF" size="2"></font></a><font color="#FFFFFF" size="2">城市</font></td>
                              <td valign="middle" width="120" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">风景名称</font></td>
                              <td valign="middle" width="120" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">详细</font></td>
                            </tr>
                            <%                                                                                              
    sqlRs=" Select a.城市编码,中文城市名,风景名称_cn From xt_td_city a,xt_td_CityView b where a.城市编码=b.城市编码 and b.推荐=1 order by 中文城市名,风景名称_cn"                
%>
                            <!-- #include file="../../Include/AdoDBOpen.asp" -->
                            <%                                                                                                  
				do while (not rs.eof)  and rowcount>0                                                                                                  
			      if (rowcount mod 2)=0 then                                                                                                  
			  %>
                            <tr> 
                              <%else%>
                            <tr bgcolor="#fff1dd"> 
                              <%end if%>
                              <td height="20" valign="middle" ><font size="2"><%=rs(1)%></font></td>
                              <td valign="middle" align="center"><font size=2 color="#326A94"><%=rs(2)%></font></td>
                              <td valign="middle" align="center" ><a href="javascript:open1(<%=rs(0)%>,<%="'" & rs(2) & "'"%>)"><font size="2" color="#000000">详细</font></a></td>
                            </tr>
                            <%                                                                                                     
				rs.movenext '纪录指针下移                                                                                                     
				rowcount=rowcount-1                                                                                                     
				loop                                                                                                     
				%>
                            <tr> 
                              <td height="20" colspan="3" valign="top">&nbsp;</td>
                            </tr>
                            <tr> 
                              <td height="20" colspan="3" valign="top"  align="right" bgcolor="#ffcc00"> 
                                <%sLinkFile="city_query.asp?query="                                                                              
                        sBookMark="ddd"%>
                                <!-- #include file="../../Include/pageend.asp" -->
                                  </font>
                                </font></td>
                            </tr>
                          </table>
                        </td>
                      </tr>
                      <tr> 
                        <td height="71"></td>
                        <td></td>
                        <td></td>
                      </tr>
                    </table>
                  </td>
                </tr>
              </table>
            </td>
          </tr>
          <tr> 
            <td height="6"></td>
          </tr>
        </table>
      </td>
      <td width="26"></td>
    </tr>
  </table>
<map name="Map2"> 
  <area shape="rect" coords="7,-1,53,21" href="../User/user_login.asp">
</map>
<map name="Map3"> 
  <area shape="rect" coords="5,-1,57,23" href="#">
</map>
<map name="Map4">
  <area shape="rect" coords="5,2,41,21" href="../../korea/index.asp">
</map>
<map name="Map5">
  <area shape="rect" coords="1,0,44,15" href="../User/user_login.asp">
</map>
</center>
</body>

</html>
<script language=javascript>                         
			function open1(code,code1)                         
			{                         
			window.open("cityview_detail.asp?code="+code+"&code1="+code1,"城市风景详细","height=300,width=340,toolbar=no,menubar=no,scrollbars=yes,resizable=no,status=no,location=no")                         
			}                         
</script>