使用javascript将数据库值显示在html中的表中

问题描述：

大家好，

i我试图用javascript从hql中的sql数据库中检索数据。

请帮我身体......... 。

i只知道javascript不可能。但是会有一些方法！

现在我这样写：

hi all,
i am trying to retrieving data from sql database in html with javascript.
please any body help to me..........
i know not possible in only javascript. but will have some way!
now i written like this:

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

var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";

connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
   document.write(rs.fields(1));
   rs.movenext;
}

rs.close;
connection.close;

提前感谢。

thanks in advance.

答

以下帮助链接中的示例是： Javascript：ADODB& SQL查询 [ ^ ]

来自链接的示例：

从SQL数据库中检索数据

示例简单查询：query =SELECT x，y从blah-blah;

Does the samples at the following link of help: Javascript: ADODB & SQL Queries[^]

A sample from the link:
RETRIEVE DATA FROM SQL DATABASE
Example simple query: query="SELECT x,y FROM blah-blah";

function GetDatabaseData(){ //saves all rows of desired DataBase tables in sqlArr
  var adOpenDynamic=2;
  var adLockOptimistic=3;
  sqlArr=new Array();
  try{
    var rs = new ActiveXObject("ADODB.Recordset");
    rs.open(query, conn, adOpenDynamic, adLockOptimistic);
    var j=0;var tArr=[];
    if(!rs.bof){rs.MoveFirst();}
    for(var i=0;i<rs.fields.count;++i){tarr[i]>    sqlArr[j]=tArr;j++;
    if(!rs.eof){rs.MoveNext();}
    while(!rs.eof){
      tArr=[];
      for(var i=0;i<rs.fields.count;++i){>
        tArr[i]=rs.fields(i).value;
        if(tArr[i]!=tArr[i]+''){tArr[i]='<object>';}
        if(tArr[i]=='null'){tArr[i]='-';}
      }
      sqlArr[j]=tArr;j++;
      rs.MoveNext();
    }
    rs.close();//record set
  }
  catch(err01){
    conn.close();
    conn=null;// leave DB
    Some error handling...
  }
}

hbghkbjhkljk，.jmkm，.m， mjbghmn m，n，nmn，mnm，nm，hjbvhj vbnv

hbghkbjhkljk,.jmkm,.m,mjbghmn m,n,nmn,mnm,nm,hjbvhj vbnv

hibbhjbgffgdsxvcvvbchgfghfhgfhfghfhgfghfghgfgfhgghjkhjnm，nmbhgfghjknkm，。m。，m .; kmhyftrdtrsdgvchbvjh

hibbhjbgffgdsxvcvvbchgfghfhgfhfghfhgfghfghgfgfhgghjkhjnm,nmbhgfghjknkm,.m.,m.;kmhyftrdtrsdgvchbvjh

使用javascript将数据库值显示在html中的表中

相关推荐