📄 query_jiudian.asp
字号:
<!-- 酒店查询 -->
<%@ LANGUAGE=JavaScript %>
<!--#include file ="Lib/Comm.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>中国旅游 - 酒店查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript" src="images/myfreetemplates.js"></script>
<link href="images/myfreetemplates.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/btn_chaxuen_dn.gif','images/btn_jingdian_dn.gif','images/btn_jiudian_dn.gif','images/btn_lvxingshe_dn.gif','images/btn_liuyan_dn.gif')"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="6" valign="top"> </td>
<td width="42" rowspan="6" valign="top" background="images/sidebg_left.gif"> </td>
<td width="670" background="images/tabletopbg1.gif"><img src="images/tabletopbg1.gif" width="1" height="4"></td>
<td width="46" rowspan="6" valign="top" background="images/sidebg_right.gif"><img src="images/sidebg_right.gif" width="46" height="3"></td>
<td rowspan="6" valign="top"> </td>
</tr>
<tr>
<td width="670"> <table width="676" border="0" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="2" background="images/pixi_greyblue.gif"><img src="images/top_logo.gif" width="166" height="92"></td>
<td colspan="6" background="images/pixi_greyblue.gif"><img src="images/pixi_greyblue.gif" width="1" height="61"></td>
</tr>
<tr>
<td><img src="images/top_curve.gif" width="22" height="31"></td>
<td colspan="5" align="right"><a onMouseOver="MM_swapImage('btn_null','','images/btn_null.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_null.gif" name="btn_null" border="0" id="btn_null" width="53" height="31"></a><!--
1
--><a href="index.asp" onMouseOver="MM_swapImage('btn_shouye','','images/btn_shouye_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_shouye.gif" name="btn_shouye" border="0" id="btn_shouye" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
2
--><a href="chaxun.asp" onMouseOver="MM_swapImage('btn_chaxuen','','images/btn_chaxuen_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_chaxuen.gif" name="btn_chaxuen" border="0" id="btn_chaxuen" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
3
--><a href="jingdian.asp" onMouseOver="MM_swapImage('btn_jingdian','','images/btn_jingdian_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_jingdian.gif" name="btn_jingdian" border="0" id="btn_jingdian" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
4
--><a href="jiudian.asp" onMouseOver="MM_swapImage('btn_jiudian','','images/btn_jiudian_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_jiudian.gif" name="btn_jiudian" border="0" id="btn_jiudian" width="68" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
5
--><a href="lvxingshe.asp" onMouseOver="MM_swapImage('btn_lvxingshe','','images/btn_lvxingshe_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_lvxingshe.gif" name="btn_lvxingshe" border="0" id="btn_lvxingshe" width="86" height="31"></a><img src="images/nav_spacer.gif" width="2" height="31"><!--
6
--><a href="liuyan.asp" onMouseOver="MM_swapImage('btn_liuyan','','images/btn_liuyan_dn.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="images/btn_liuyan.gif" name="btn_liuyan" border="0" id="btn_liuyan" width="68" height="31"></a></td>
</tr>
</table></td>
</tr>
<tr>
<td width="670" height="4" background="images/pixi_lightblue.gif"><img src="images/pixi_lightblue.gif" width="4" height="4"></td>
</tr>
<tr>
<td width="670" background="images/pixi_lightblue.gif"> <div align="left">
<!-- 横幅图片-->
<table width="676" cellpadding="0">
<tr><td align="center"><img src="images/changcheng.jpg" /></td></tr>
</table>
</div></td>
</tr>
<tr>
<td width="670" height="4" background="images/pixi_lightblue.gif"><img src="images/pixi_lightblue.gif" width="4" height="4"></td>
</tr>
<tr>
<td align="right" valign="top">
<table width="100%" cellpadding="0px" cellspacing="0px">
<tr><td align="right"><img src="images/midcurve2.gif" /></td></tr>
<tr><td class="neirong">
<!-- 主体内容 -->
<%
if (hasRequest(Request.QueryString("bianhao"))) {
BHQuery(Request.QueryString("bianhao"));
}
else if (hasRequest(Request.QueryString("key"))) {
if (hasRequest(Request.QueryString("type")))
type = String(Request.QueryString("type"));
else
type = "名称";
Query(type,Request.QueryString("key"));
}
else {
Response.Write("<font color='red'>缺少查询参数</font>");
}
%>
<!-- 按编号查询 -->
<%
function BHQuery(BianHao) {
%>
<style type="text/css">
table.jiudian { font-size: 14px; border-collapse:collapse; margin-bottom: 24px;}
table.jiudian caption { font-weight: bold; text-align: left; padding-left: 180px; font-size: 18px; }
table.jiudian caption a { font-size: 14px; text-decoration: none; font-weight:normal; color: green; }
table.jiudian td { padding: 5px;}
</style>
<%
if (!isNum(BianHao)) {
Response.Write("<font color='red'>BianHao查询参数非法。</font>");
return;
}
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM JiuDian WHERE BianHao=" + BianHao;
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
if (rs.eof){
Response.Write("<font color='red'>对不起，该记录已被移动或被删除！</font>");
} else {
%>
<table class="jiudian" align="center" width="500" border="1">
<caption><%=rs("MingCheng")%> <a href="yuding.asp?bianhao=<%=rs("BianHao")%>"><img src="images/yuding.jpg" border="0" alt="预定" /></a></caption>
<tr><td width="80" align="right">地址：</td><td><%=rs("DiZhi")%></td></tr>
<tr><td align="right">星级：</td><td><%=rs("XingJi")%></td></tr>
<tr><td align="right">联系人：</td><td><%=rs("LianXiRen")%></td></tr>
<tr><td align="right">联系电话：</td><td><%=rs("LianXiDianHua")%></td></tr>
</table>
<%
}
rs.Close();
rs = null;
conn.Close();
sql = "SELECT JingDianBianHao,JingDianMingCheng FROM JingDian_JiuDian WHERE JiuDianBianHao=" + BianHao;
conn.Open();
rs = conn.Execute(sql);
%>
<table class="jiudian" align="center" width="500" border="1">
<caption>附近景点</caption>
<%
while (!rs.eof) {
%>
<tr><td><a href="query_jingdian.asp?bianhao=<%=rs("JingDianBianHao")%>"><%=rs("JingDianMingCheng")%></a></td></tr>
<%
rs.MoveNext();
}
%>
</table>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
}; // end BHQuery()
%>
<!-- ################## -->
<%
function Query(type,key) {
var keys = String(key).split(/\s/);
key = keys[0];
if (type=="名称") type = "MingCheng";
else if (type=="地址") type = "DiZhi";
else type = "MingCheng";
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM JiuDian WHERE " + type + " Like '%" + key + "%'";
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
%>
<style type="text/css">
.list_jingdian { width:500px; border-collapse:collapse;margin-bottom: 24px;}
.list_jingdian td { padding: 5px; padding-left: 12px; font-size: 20px;
letter-spacing:2px; font-family: "楷体_gb2312",georgia;
background: url("images/m_line.gif") no-repeat bottom;}
.list_jingdian strong { color:#FF0000; font-weight: normal;}
.list_jingdian a { text-decoration: none;}
.list_jingdian a:hover { text-decoration: underline;}
</style>
<h2 align="center">搜索到的酒店：</h2>
<table class="list_jingdian" align="center">
<%
if (rs.eof) Response.Write("<font color='red'>对不起，找不到符合条件的记录。</font><a href='javascript:window.history.go(-1)'>返回</a>");
while (!rs.eof) {
%>
<tr><td>
<img src="images/list_jingdian.gif" /> <a href="query_jiudian.asp?bianhao=<%=rs("BianHao")%>"><%
if (type =="MingCheng")
Response.Write(String(rs("MingCheng")).replace(key,"<strong>" + key + "</strong>"));
else
Response.Write(rs("MingCHeng"));
%>
</a>
<div style="font-size: 14px; font-family: georgia; padding-left: 24px; margin-top: -12px;">
<br />地址：
<%
if (type=="DiZhi")
Response.Write(String(rs("DiZhi")).replace(key,"<strong>" + key + "</strong>"));
else
Response.Write(rs("DiZhi"));
%>
</div>
</td></tr>
<%
rs.MoveNext();
}
rs.Close(); rs = null;
conn.Close(); conn = null;
%>
</table>
<%
}; // end Query()
%>
</td></tr>
</table>
</td>
</tr>
<tr>
<td valign="top"> </td>
<td valign="top" background="images/sidebg_left.gif"> </td>
<td valign="top" background="images/pixi_lightblue.gif"> <span class="baseline">©
Copyright 2006.<br>
<br>
</span></td>
<td valign="top" background="images/sidebg_right.gif"> </td>
<td valign="top"> </td>
</tr>
</table>
<table border=0 CELLSPACING=0 CELLPADDING=0 WIDTH="601" align=center>
<tr>
<td align=center><br><center>
<font style="font-size: 11px;">© 中国旅游 版权所有 <br />www.xxx.com</font>
</center></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -