JavaScript下远程连Oracle数据库

最新推荐文章于 2023-10-01 02:20:11 发布

辛翊

最新推荐文章于 2023-10-01 02:20:11 发布

阅读量3.8k

点赞数

分类专栏： windows编程

本文链接：https://blog.youkuaiyun.com/dongdan_002/article/details/45331987

版权

windows编程专栏收录该内容

16 篇文章

订阅专栏

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Connecting to Oracle using JavaScript</title>
<h1> Test orcl </h1>
</head>
<body>

<script language="JavaScript" type="text/javascript">

var conObj = new ActiveXObject('ADODB.Connection');
alert("new1");
var connectionString = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.168)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(SERVER=DEDICATED)));User Id=michael;Password=0.0;"
try{
conObj.Open(connectionString);
var rs = new ActiveXObject("ADODB.Recordset");
sql = "SELECT SYSDATE FROM DUAL"
sq = "select fname from myemp123 where id = 2"
rs.Open(sq, conObj);
}catch(e)
{
	alert(e.message);
}
alert("Á¬½Ó³É¹¦");
alert(rs(0));


rs.close;
conObj.close;
//-->
</script>
</body>
</html>