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 name var 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>