JavaScript operation Oracle database example_javascript skills-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

JavaScript operation Oracle database example_javascript skills

May 16, 2016 pm 04:10 PM

javascript oracle operate database

I am still a newbie in the IT world and have not been working for a long time. However, with my eagerness to learn and my never-ending pace of learning, I have gained a lot in programming~~

I always thought that JavaScript must call server-side code (C# or JAVA) through AJAX if it wants to interact with the database, but recently I discovered that JavaScript can interact with the database directly... The following is a simple call from the database A small example of loading data into the interface (if you have any good suggestions about JS operation data, I hope you can leave them, we can learn from each other and make progress together)~~

&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&gt;
&lt;HTML&gt;
 &lt;HEAD&gt;
 &lt;TITLE&gt; New Document &lt;/TITLE&gt;
 &lt;META NAME="Generator" CONTENT="EditPlus"&gt;
 &lt;META NAME="Author" CONTENT=""&gt;
 &lt;META NAME="Keywords" CONTENT=""&gt;
 &lt;META NAME="Description" CONTENT=""&gt;
 &lt;script type="text/javascript"&gt;
  function getData()
  {
    //定义SQL语句
    var sql = "select obj_id,obj_caption from mw_sys.mwt_om_obj where rownum&lt;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="&lt;table cellpadding=0; cellspacing=0; style='border:solid 1px gray;'&gt;&lt;thead&gt;&lt;td style='border:solid 1px gray; text-align:center;'&gt;行号&lt;/td&gt;&lt;td style='border:solid 1px gray; text-align:center;'&gt;作业文本ID号&lt;/td&gt;&lt;td style='border:solid 1px gray;'&gt;专业编号&lt;/td&gt;&lt;tbody&gt;";
    while(!rs.EOF)
    {
      shtml+="&lt;tr&gt;&lt;td style='border:solid 1px gray; text-align:center;'&gt;";
      shtml+=rownum+1;
      shtml+="&lt;/td&gt;";
      for(i = 0;i&lt;rs.Fields.Count;++i)
      {
        shtml+="&lt;td style='border:solid 1px gray; background-color:yellow;'&gt;";
        shtml+=rs.Fields(i).value==null&#63;" ":rs.Fields(i).value;
        shtml+="&lt;/td&gt;";
      }
      shtml+="&lt;/tr&gt;";
      rownum++;
      if(rownum==1000)
      break;
      rs.MoveNext();
    }
    shtml+="&lt;/tbody&gt;&lt;/table&gt;";
    rs.close();
    ConnDB.close();
    document.getElementById("data").innerHTML=shtml;
  }
 &lt;/script&gt;
 
 &lt;/HEAD&gt;
 
 &lt;BODY&gt;
 &lt;input type="button" value="Table" onclick="getData()"/&gt;
 &lt;div id="data"&gt;
 &lt;/div&gt;
 &lt;/BODY&gt;
&lt;/HTML&gt;

Copy after login

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn