<!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数据库