nodejs连接oracle数据库

awen-fly

已于 2024-07-01 14:31:37 修改

阅读量150

点赞数 2

文章标签：数据库 oracle node.js

于 2024-07-01 10:37:47 首次发布

本文链接：https://blog.csdn.net/qq_50935441/article/details/140094185

版权

压缩包下载

创建文件夹network/admin

文件夹下创建2个文件

写入如下内容

tnsnames.ora

MYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 端口号))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 数据库名称)
    )
  )

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

环境变量

path

OCI_INC_DIR

OCI_LIB_DIR

下载模块

npm install oracledb

测试demo

npm

const oracledb = require('oracledb');  
  
oracledb.getConnection({  
  user: "账号",  
  password: "密码",  
  connectString: "ip:端口号/数据库名称" 
}, function(err, connection) {  
  if (err) {  
    console.error(err.message);  
    return;  
  }  
  else{
    console.info("conn:",connection);
    connection.execute(
      "SELECT * FROM 表名 WHERE ID = 'ID号'",
      function(err, result) {
        if (err) {
          console.error(err.message);
          return;
        }
        console.log(result.rows);
      });}
});

压缩包地址

https://blog.csdn.net/qq_50935441/article/details/140100084?spm=1001.2014.3001.5502