数据库"/>
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 连接 数据库
发布评论