html链接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)

{

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

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

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

var sql = "select userid from RegUsers where chrname='"+username+"'";

rs.open(sql,conn);

if(!rs.EOF)

{

return rs("userid");

}

rs.close();

conn.close();

rs=null;

conn=null;

}

function baoming()

{

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

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

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

var sql = "select userid,activeid,chrtel,CONVERT(varchar(30),dtappenddate,20) as dtappenddate from baoming order by id desc";

rs.open(sql,conn);

var i =1;

while(!rs.EOF && i<31)

{

Response.Write("

");

Response.Write("

"+i +"");

Response.Write("

"+ getUserNameById(rs('userid')) +"");

Response.Write("

"+ getActi