execute.asp

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

<%@ LANGUAGE=JavaScript %>

<%

var conn = new ActiveXObject("ADODB.Connection");
conn.Open(Application("ConnectionString"));
var sql = "CREATE VIEW YuDing_JiuDian AS SELECT YuDingJiuDian.YongHu,JiuDian.BianHao,JiuDian.MingCheng FROM YuDingJiuDian,JiuDian WHERE YuDingJiuDian.JiuDianBianHao=JiuDian.BianHao"
conn.Execute(sql);
conn.Close();
Response.Write("OK");

%>