execute.asp

部分功能：1.查询旅游信息：主要查询景点和酒店的信息

<%@ 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");

%>