js操作数据库

js操作数据库1
<script language="Javascript" runat="server">
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;
</script>

JS中操作数据库2
<script language="javascript">
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(); //调用函数
</script>