JavaScript中链接数据库示例

      一个用javascript链接数据库的例子，比较简单。流程和ADO.NET有相似之处，只是部分地方语法稍有差异，代码如下:    

<script language="javascript"> 
   function test_connect_sql(){
      try{
      //JavaScript 写服务器端连接数据库的代码
      var conn = new ActiveXObject("ADODB.Connection"); 
      conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=drsa; " 
        +"Password=123456; Initial Catalog=StockDoctor"); 
      var rs = new ActiveXObject("ADODB.Recordset"); 
      var sql="select * from test"; 
      rs.open(sql, conn); 

      html = "<table width='100%' border=1>"; 
      html +="<tr bgcolor='#f4f4f4'><td>id</td><td>stuname</td><td>stuage</td><td>stuzy</td></tr>"; 

      while(!rs.EOF) 
      { 
            html += "<tr><td>" + rs("id") + "</td><td>" + rs("stuname") + "</td><td>" + rs("stuage") + "</td><td>" +    rs("stuzy") + "</td></tr>"; 
            rs.moveNext; 
      } 
        html += "</table>"; 
        document.write(html); 
    }
    catch(e){
    
    }finally{
          rs.close();  
          rs = null;  
          conn.close();  
          conn = null; 
   }
 } 
 window.onload =function(){test_connect_sql();}
</script>