javascript串連資料庫

//用 JavaScript 寫伺服器端串連資料庫的程式碼範例
 var conn = new ActiveXObject("ADODB.Connection");
 conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; " +
 "Password=sa; Initial Catalog=pubs");
 var rs = new ActiveXObject("ADODB.Recordset");
 var sql = "select * from authors";
 rs.open(sql, conn);
 shtml = "<table width='100%' border=1>";
 shtml += "<tr bgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td><td>phone</td><td>address</td><td> city</td><td>state</td><td>zip</td></tr>";
 while (!rs.EOF) {
  shtml += "<tr><td>" + rs("au_id") + "</td><td>" + rs("au_lname") + "</td><td>" + rs("au_fname") + "</td><td>" + rs("phone") + "</td><td>" + rs("address") + "</td><td>" + rs("city") + "</td><td>" + rs("state") + "</td><td>" + rs("zip") + "</td></tr>";
  rs.moveNext;
 }
 shtml += "</table>";
 document.write(shtml);
 rs.close();
 rs = null;
 conn.close();
 conn = null; 

本文來自CSDN部落格，轉載請標明出處：http://blog.csdn.net/fenghu89/archive/2008/01/19/2053836.aspx