数据库"/>
JavaScript 连接 数据库
mysql
<script type="text/javascript"> var datasource="mysql_data_source"; var username="root";// var password="*******";// try {//用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=MSDASQL.1;Data Source="+datasource+";User ID="+username+";Password="+password+"");var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from test"; rs.open(sql, conn, 1,1 ); while (!rs.EOF) {document.write(rs("id"));document.write("<BR>");rs.MoveNext;} } catch (errer) {alert(errer.description); }</script>
oracle
<html> <script type="text/javascript"> ///下面三个属性要修改var url="nhzj_112"; // oracle 的 tns Service namevar username="test";// var password="*******";// //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=OraOLEDB.Oracle;Data Source="+url+";User ID="+username+";Password="+password+";PLSQLRset=1"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select 1 num from dual"; rs.open(sql, conn, 1,1 ); while (!rs.EOF) {document.write(rs("num"));document.write("<BR>");rs.MoveNext; } rs.close();</script> </HTML>
更多推荐
JavaScript 连接 数据库
发布评论