Node.js でOracleアクセス
---------------------------------------
1.node.jsからoracleへ接続するためのモジュールをインストール
npm i oracledb
2.Oracle Instant Client をダウンロード
3.サンプルコード
------------
const dbConfig={
user : '××',
password : '××',
connectionString : '192.168.××.××:1521/pdborcl2'
}
const oracledb=require('oracledb')
let parameter;
let connection;
let result;
(async () =>{
try {
oracledb.initOracleClient({libDir: 'D:\\instantclient_21_8'});
let sql='select ename from emp where empno =:empno';
parameter=[7655];
connection=await oracledb.getConnection({
user : dbConfig.user,
password : dbConfig.password,
connectionString : dbConfig.connectionString
});
options = {outFormat: oracledb.OUT_FORMAT_OBJECT};
console.log('Connected Start');
if(connection){
result = await connection.execute(sql,parameter,options);
console.log(result.rows);
}
} catch (error) {
console.log("ERROR"+error);
}finally{
await connection.close();
}
})()
4.実行
node cndb.js
PS C:\Users\Aramaki\OneDrive\デスクトップ\MyDoc\jstest> node condb.js
Connected Start
[ { ENAME: '山田' } ]
PS C:\Users\Aramaki\OneDrive\デスクトップ\MyDoc\jstest>