jiudian_add.asp
来自「部分功能:1.查询旅游信息:主要查询景点和酒店的信息」· ASP 代码 · 共 34 行
ASP
34 行
<%@ LANGUAGE=JavaScript %>
<!--#include file ="../lib/comm.asp"-->
<%
if (Session("YongHu")==null || Session("YongHu").LeiXing != 1)
Response.Redirect("denglu.asp");
%>
<html>
<body>
<%
if (hasRequest(Request.Form("MingCheng")) && hasRequest(Request.Form("XingJi")) && hasRequest(Request.Form("LianXiRen")) && hasRequest(Request.Form("LianXiDianHua")) && hasRequest(Request.Form("DiZhi"))) {
var conn = new ActiveXObject("ADODB.Connection");
conn.Open(Application("ConnectionString"));
var sql = "INSERT INTO JiuDian (MingCheng,XingJi,LianXiRen,LianXiDianHua,DiZHi) VALUES('"
+ Request.Form("MingCheng") + "','"
+ Request.Form("XingJi") + "','"
+ Request.Form("LianXiRen") + "','"
+ Request.Form("LianXiDianHua") + "','"
+ Request.Form("DiZhi") + "'"
+ ")";
//Response.Write(sql);
conn.Execute(sql);
conn.Close();
Response.Write("<p align=\"center\">添加成功,<a href=\"jiudian.asp\">返回</a>。</p>");
} else {
Response.Write("缺少参数或参数非法,<a href='javascript:window.history.go(-1)'>返回</a>。");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?