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> 

 

 

转载于:https://www.cnblogs.com/zzxbest/archive/2010/06/11/1756409.html