Detailed explanation of examples of JavaScript calling ActiveX to operate Oracle database-JS Tutorial-php.cn

Detailed explanation of examples of JavaScript calling ActiveX to operate Oracle database

黄舟

Release： 2017-03-14 15:36:48

Original

1849 people have browsed it

JavaScriptCan also operate Oracle database? This seems incredible. But we can see another word from the title: ActiveX, which seems to have helped us unlock the mystery of how JavaScript operates the Oracle database. This article uses an example to introduce the detailed method of using JavaScript to call ActiveX to operate the Oracle database. I hope it will be helpful to you.

The following is the JavaScript code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
 <TITLE> New Document </TITLE>
 <META NAME="Generator" CONTENT="EditPlus">
 <META NAME="Author" CONTENT="">
 <META NAME="Keywords" CONTENT="">
 <META NAME="Description" CONTENT="">
 <script type="text/javascript">
  function getData()
  {
    //定义SQL语句
    var sql = "select obj_id,obj_caption from mw_sys.mwt_om_obj where rownum<5000";
    //新建数据库连接对象和数据集存取对象
    var ConnDB = new ActiveXObject("ADODB.Connection");
    ConnDB.open("Provider=MSDAORA.1;Password=app;User ID=mw_app;Data Source=pms;Persist Security Info=True");
    var rs = new ActiveXObject("ADODB.Recordset");
    rs.ActiveConnection = ConnDB;
    rs.Open(sql);
    //遍历
    var s;
    var rownum=0;
    var shtml="<table cellpadding=0; cellspacing=0; style=&#39;border:solid 1px gray;&#39;>
    <thead><td style=&#39;border:solid 1px gray; text-align:center;&#39;>行号</td>
    <td style=&#39;border:solid 1px gray; text-align:center;&#39;>作业文本ID号</td>
    <td style=&#39;border:solid 1px gray;&#39;>专业编号</td><tbody>";
    while(!rs.EOF)
    {
      shtml+="<tr><td style=&#39;border:solid 1px gray; text-align:center;&#39;>";
      shtml+=rownum+1;
      shtml+="</td>";
      for(i = 0;i<rs.Fields.Count;++i)
      {
        shtml+="<td style=&#39;border:solid 1px gray; background-color:yellow;&#39;>";
        shtml+=rs.Fields(i).value==null?" ":rs.Fields(i).value;
        shtml+="</td>";
      }
      shtml+="</tr>";
      rownum++;
      if(rownum==1000)
      break;
      rs.MoveNext();
    }
    shtml+="</tbody></table>";
    rs.close();
    ConnDB.close();
    document.getElementById("data").innerHTML=shtml;
  }
 </script>

 </HEAD>

 <BODY>
 <input type="button" value="Table" onclick="getData()"/>
 <p id="data">
 </p>
 </BODY>
</HTML>

Copy after login

The above is the detailed content of Detailed explanation of examples of JavaScript calling ActiveX to operate Oracle database. For more information, please follow other related articles on the PHP Chinese website!