yuding_delete.asp

来自「部分功能：1.查询旅游信息：主要查询景点和酒店的信息」· ASP 代码 · 共 23 行

<%@ LANGUAGE=JavaScript %>

<!--#include file ="../lib/comm.asp"-->
<%
if (Session("YongHu")==null || Session("YongHu").LeiXing != 1)
	Response.Redirect("denglu.asp");
%>

<%
if (hasRequest(Request("jiudianbianhao")) && isNum(Request("jiudianbianhao"))) {

	var conn = new ActiveXObject("ADODB.Connection");
	var sql = "DELETE * FROM YuDingJiuDian WHERE JiuDianBianhao=" + Request("jiudianbianhao") + " AND YongHu='" + Request("yonghu") + "'";
	conn.Open(Application("ConnectionString"));
	conn.Execute(sql);
	conn.Close();
	conn = null;
	Response.Write("<p align=\"center\" color=\"blue\">删除成功，<a href='yuding.asp'>返回</a>。</p>");
} else {
	Response.Write("缺少参数或参数非法，<a href='javascript:window.history.go(-1)'>返回</a>。");
}

%>