天天看點

javascript 讀取資料庫

var conn=new ActiveXObject("ADODB.Connection"); //create connection object

 var connString="database connection string"; //connection string

 conn.open(connString);

 var rs=new ActiveXObject("ADODB.RecordSet"); //create recordset object

 var queryStrin="select top 10* from authors";

 rs.open(querystr,conn);

 while(!rs.EOF)

 {

      //there is code

      rs.moveNext;

 }

  rs.close(); 

  rs = null; 

  conn.close(); 

  conn = null;