html5连接sqlserver数据库,使用JavaScript连接SqlServer数据库。执行CRUD操作。

function db()

{

//活动编号

var activeid = Request.Form("activeid");

//用户名

var username = Request.Form("username");

//手机号码

var mobile = Request.Form("mobile");

var conn= Server.CreateObject("ADODB.connection");

var rs= Server.CreateObject("adodb.recordset");

var userid = getUserIdByName(username);

conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");

var sql = "insert into user (activeid,userid,chrtel,dtappenddate) values("+activeid+","+userid+",'"+mobile+"',getdate())";

rs.open(sql,conn);

rs.close();

conn.close();

rs=null;

conn=null;

}

function getUserIdByName(username)

{