node.js查询oracle,nodejs连接oracle

var oracledb = require('oracledb');

var config = {

"user": "scott",

"password": "123456",

"connectString":"localhost:1521/ORCL"

}

oracledb.getConnection(config,function (err,connection) {

if(err) {

console.log(err.message);

doRelease(connection);

return;

}

connection.execute("select * from dic_roles",function (err,result) {

if(err) {

console.error(err.message);

doRelease(connection);

return;

}

// 打印返回的表结构

console.log("========" + result.metaData);

// console.log(JSON.parse(result));

console.log(result.rows);

});

});

function doRelease(connection) {

connection.close(function (err) {

if(err) {

console.error(err.message)

}

})

}

执行报错后，执行下面代码

npm i oracledb –registry=https://registry.npm.taobao.org

转载自：https://blog.csdn.net/pengfeifei26/article/details/84926234