📄 jingdian_jiudian.asp
字号:
<%@ LANGUAGE=JavaScript %>
<!--#include file ="../lib/comm.asp"-->
<html>
<head>
<style type="text/css">
li a {font-size: 11px;}
</style>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312" />
</head>
<body>
<h1 align="center">景点┈┈酒店</h1>
<%
Response.expires = 0;
if (hasRequest(Request("bianhao")) && isNum(Request("bianHao"))) {
if (hasRequest(Request("delete")) && isNum(Request("delete"))) {
Delete(Request("bianhao"),Request("delete"));
}
if (hasRequest(Request("add")) && isNum(Request("add"))) {
Add(Request("bianhao"),Request("add"));
}
FJJD(Request("bianhao"));
} else {
Response.Write("<font color='red'>缺少参数或参数非法!<a href='javascript:window.history.go(-1)'>返回</a></font>");
}
%>
<a href='javascript:window.history.go(-1)'>返回</a>
<%
function FJJD(bianhao) {
Response.Write("<h2>附近酒店：</h2>");
Response.Write("<ul>");
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM JingDian_JiuDian WHERE JingDianBianHao=" + bianhao;
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
if (rs.eof) Response.Write("<li>没有附近酒店。</li>");
while (!rs.eof) {
Response.Write("<li>" + rs("JiuDianMingCheng") + " <a href='jingdian_jiudian.asp?bianhao=" + bianhao + "&delete=" + rs("JiuDianBianHao") + "'>删除</a></li>");
rs.MoveNext();
}
Response.Write("</ul>");
rs.Close(); rs = null;
Response.Write("<p> <h2>添加附近酒店：</h2>");
Response.Write("<form action='' method='get'>");
Response.Write("<input name='bianhao' type='hidden' value='" + bianhao + "' />");
Response.Write("<select name='add' style='margin-left: 28px;'>");
sql = "SELECT * FROM JiuDian";
rs = conn.Execute(sql);
while (!rs.eof) {
Response.Write("<option value='" + rs("BianHao") + "'>" + rs("MingCheng") + "</option>");
rs.MoveNext();
}
Response.Write("</select> <input type='submit' value='添加' />");
Response.Write("</form>");
rs.Close(); rs = null;
conn.Close();
};
%>
<%
function Delete(jingdian,jiudian) {
var conn = new ActiveXObject("ADODB.Connection");
var sql = "DELETE * FROM SheZhi WHERE JingDianBianHao=" + jingdian + " AND JiuDianBianHao=" + jiudian;
conn.Open(Application("ConnectionString"));
try {
conn.Execute(sql);
Response.Write("<p><font color='blue'>已删除！</font></p>");
} catch(e) {
Response.Write("<p><font color='red'>系统错误，删除失败！</font></p>");
}
conn.Close();
conn = null;
};
%>
<%
function Add(jingdian,jiudian) {
var conn = new ActiveXObject("ADODB.Connection");
var sql = "INSERT INTO SheZhi (JingDianBianHao,JiuDianBianHao) VALUES (" + jingdian + "," + jiudian + ");";
conn.Open(Application("ConnectionString"));
try {
conn.Execute(sql);
Response.Write("<p><font color='blue'>添加成功！</font></p>");
} catch(e) {
if (e.number = -2147467259)
Response.Write("<p><font color='red'>不能重复添加，添加失败！</font></p>");
else
Response.Write("<p><font color='red'>系统错误，添加失败！</font></p>");
}
conn.Close();
conn = null;
};
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -