<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Connecting to Oracle using JavaScript</title>
</head>
<body>
<script language="JavaScript" type="text/javascript">
<!--
var conObj = new ActiveXObject('ADODB.Connection');
var connectionString = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SB.SB.SB.SB)(PORT=$so_dm)))(CONNECT_DATA=(SID=SBZ)(SERVER=DEDICATED)));User Id=SBHIS;Password=NISHITADENVSHEN;"
conObj.Open(connectionString);
var rs = new ActiveXObject("ADODB.Recordset");
sql = "SELECT To_Char(Sysdate,'yyyy-MM-dd hh24:mi:ss') As DateTime FROM DUAL"
rs.Open(sql, conObj);
alert("OracleDB Sysdate:"+rs(0));
rs.close;
conObj.close;
//-->
</script>
</body>
</html>
更多推荐
JavaScript连接Oracle数据库
发布评论