JS串連Oracle

<script language=javascript>  

 

//容錯問題，請讀者自行進行判斷。

//定義SQL語句

var sql = "select * from users";

//建立資料庫連接對象和資料集存取對象

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

ConnDB.open("Provider=MSDAORA.1;Password=mdj;User ID=mdj;Data Source=ORCL;Persist Security Info=True");

var rs =  new ActiveXObject("ADODB.Recordset");
rs.ActiveConnection = ConnDB;
rs.Open(sql);

//遍曆

var s;
while(!rs.EOF){
  
  
   for(i = 0;i<rs.Fields.Count;++i){
  alert(rs.Fields(i).value);
  }
  rs.MoveNext();
}

var sql=null;

rs.close

ConnDB.close

 

 

</script>