js mysql 操作数据库_js操作数据库

js操作数据库1

var conn=new ActiveXObject("ADODB.Connection");

conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data.mdb");

conn.Open();

var rs = new ActiveXObject("ADODB.Recordset");

rs.LockType=rs.CursorType=1;

//rs.ActiveConnection=conn;

//rs.Source="SELECT id,text FROM [Tree]";

var sql="SELECT id,text FROM [Tree]";

rs.Open(sql,conn);

while (!rs.EOF)

...{

Response.Write(rs("text")+" ");

rs.MoveNext();

}

rs.Close;

rs=null;

conn.Close();

conn=null;

JS中操作数据库2

function database()

{

var conn = new ActiveXObject("Adodb.Connection");

conn.Open("driver={SQL server};database=数据库名;server=服务器;uid=用户名;pwd=密码")

var rs_str = new ActiveXObject("Adodb.Recordset");

rs_str.Open ("SQL查询语句",conn,1,1)

if (!rs_str.eof)

{

alert(rs_str.recordcount);   //弹出查询的记录数

}

}

database(); //调用函数