nodejs oracle-db多数据库连接

const oracledb = require('oracledb');

async function connectToDB(dbConfig) {
  try {
    // 连接数据库
    const connection = await oracledb.getConnection(dbConfig);
    console.log('Connected to Oracle database');

    // 执行查询
    const result = await connection.execute('SELECT * FROM table_name');
    console.log('Query result:', result.rows);

    // 关闭连接
    await connection.close();
    console.log('Connection closed');
  } catch (error) {
    console.error('Error connecting to Oracle database:', error);
  }
}

// 配置多个数据库连接信息
const dbConfigs = [
  {
    user: 'user1',
    password: 'password1',
    connectString: 'host1:port1/service1',
  },
  {
    user: 'user2',
    password: 'password2',
    connectString: 'host2:port2/service2',
  },
];

// 连接多个数据库
dbConfigs.forEach((config, index) => {
  console.log(`Connecting to database ${index + 1}`);
  connectToDB(config);
});