javascript在ie下连接数据库

<script language="javascript">
    //用 JavaScript 写服务器端连接数据库的代码示例 
    var conn = new ActiveXObject("ADODB.Connection"); 
    //var sqlstr="Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa;Password=;

    InitialCatalog=pubs";
    var sqlstr="Provider=SQLOLEDB;Data Source=localhost;UID=sa;PWD=;database=test";
    conn.Open(sqlstr); 
    var rs = new ActiveXObject("ADODB.Recordset"); 
    var sql="select top 10 * from staff"; 
    rs.open(sql,conn); 
    shtml = "<table width='100%' border=1>"; 
    shtml +="<tr bgcolor='#f4f4f4'><td>st_id</td><td>st_name</td><td>password</td></tr>"; 
    while(!rs.EOF) 
    { 
        shtml += "<tr><td>" + rs("st_id") + "</td><td>" + rs("st_name") + "</td><td>" + rs("password") +"</td></tr>"; 
        rs.moveNext; 
    } 
    shtml += "</table>"; 
    document.write(shtml); 
    rs.close(); 
    rs = null; 
    conn.close(); 
    conn = null;
</script>

 

rs.RecordCount获得查询的结果数

 

 

//连接access

<SCRIPT LANGUAGE="JavaScript">
<!--
function getCountFromDB() {
    //以当前页面文件为基础，找到文件所在的绝对路径。
    var filePath = location.href.substring(0, location.href.indexOf("Cnt.htm"));
    var path = filePath + "MyData.mdb";
    //去掉字符串中最前面的"files://"这8个字符。
    path = path.substring(8);
    var updateCnt = 0;
 
    //生成查询和更新用的sql语句。
    var sqlSelCnt = "SELECT COUNT FROM [COUNT] WHERE ID = 'count'";
    var sqlUpdCnt = "UPDATE [COUNT] SET [COUNT] = '";
 
    //建立连接，并生成相关字符串 
    var con = new ActiveXObject("ADODB.Connection");
    con.Provider = "Microsoft.Jet.OLEDB.4.0";
    con.ConnectionString = "Data Source=" + path;
 
    con.open;
    var rs = new ActiveXObject("ADODB.Recordset");
    rs.open(sqlSelCnt, con);
    while (!rs.eof) {
        var cnt = rs.Fields("COUNT");
        document.write(cnt);
        //将取得结果加1后更新数据库。
        updateCnt = cnt * 1 + 1;
        rs.moveNext;
    }
    rs.close();
    rs = null;
 
    sqlUpdCnt = sqlUpdCnt + updateCnt + "'";
    con.execute(sqlUpdCnt);
 
    con.close();
    con = null;
}