JavaScript使用ActiveXObject訪問(wèn)Access和SQL Server數(shù)據(jù)庫(kù)

更新時(shí)間：2015年04月02日 09:33:45 投稿：junjie

這篇文章主要介紹了JavaScript使用ActiveXObject訪問(wèn)Access和SQL Server數(shù)據(jù)庫(kù),本文分別給出相應(yīng)操作代碼,需要的朋友可以參考下

JS操作 Access 數(shù)據(jù)庫(kù)

<SCRIPT LANGUAGE="JavaScript">  

<!--  

var filePath = location.href.substring(0, location.href.indexOf("實(shí)例197.連接Access數(shù)據(jù)庫(kù).html"));    //以當(dāng)前頁(yè)面文件為基礎(chǔ)，找到文件所在的絕對(duì)路徑  

var path = filePath + "197.mdb";  

path = path.substring(8);            

var objdbConn = new ActiveXObject("ADODB.Connection");         

var strdsn = "driver={Microsoft Access Driver (*.mdb)};dbq=" + path;     

objdbConn.Open(strdsn);                       

document.write("連接ACCESS數(shù)據(jù)庫(kù)成功!<br>");  

objdbConn.Close();                          

//-->  

</SCRIPT>

連接SQL Server數(shù)據(jù)庫(kù)

復(fù)制代碼代碼如下:

<SCRIPT LANGUAGE="JavaScript">  

<!--  

var objdbConn = new ActiveXObject("ADODB.Connection");    

var strdsn = "Driver={SQL Server};SERVER=(local);UID=sa;PWD=111111;DATABASE=hljdatabase";    

objdbConn.Open(strdsn);       

document.write("數(shù)據(jù)庫(kù)連接成功<br>");      

objdbConn.Close();                     

//-->  

</SCRIPT>

查詢數(shù)據(jù)庫(kù)實(shí)例

復(fù)制代碼代碼如下:

<SCRIPT LANGUAGE="JavaScript">  

<!--  

var objdbConn = new ActiveXObject("ADODB.Connection");    

var strdsn = "Driver={SQL Server};SERVER=(local);UID=sa;PWD=111111;DATABASE=hljdatabase";      // 需要修改自己的服務(wù)器地址,用戶名,密碼  

objdbConn.Open(strdsn);       

var objrs = objdbConn.Execute("SELECT * FROM 表 where 關(guān)聯(lián)=0");                  // 輸入本地的表  

var fdCount = objrs.Fields.Count - 1;           

if (!objrs.EOF){                                 

  document.write("<table border=1><tr>");     

  for (var i=0; i <= fdCount; i++)                  

      document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");  

  document.write("</tr>");  

  while (!objrs.EOF){                     

    document.write("<tr>");               

    for (i=0; i <= fdCount; i++)  

       document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");  

    document.write("</tr>");  

    objrs.moveNext();                   

  }  

  document.write("</table>");   

}  

else   

  document.write("數(shù)據(jù)庫(kù)內(nèi)沒(méi)有記錄!<br>");  

objrs.Close();                           

objdbConn.Close();                     

//-->  

</SCRIPT>

操作數(shù)據(jù)庫(kù)實(shí)例

復(fù)制代碼代碼如下:

<SCRIPT LANGUAGE="JavaScript">  

<!--  

var objdbConn = new ActiveXObject("ADODB.Connection");    

var strdsn = "Driver={SQL Server};SERVER=(local);UID=sa;PWD=111111;DATABASE=hljdatabase";   // 需要修改自己的服務(wù)器地址,用戶名,密碼  

objdbConn.Open(strdsn);       

objdbConn.Execute("update 表 set 關(guān)聯(lián)=0");                    // 請(qǐng)寫(xiě)入自己的執(zhí)行語(yǔ)句  

document.write("更新數(shù)據(jù)成功!<br>");  

objdbConn.Close();                     

//-->  

</SCRIPT>

您可能感興趣的文章: