node.js oracledb -使用数组为每个组获取一条记录

const oracledb = require('oracledb');

async function getRecordsForGroups(groups) {
  let connection;

  try {
    connection = await oracledb.getConnection({
      user: 'username',
      password: 'password',
      connectString: 'localhost:1521/orcl'
    });

    const result = await connection.execute(
      `SELECT * FROM your_table WHERE group_id IN (:groups)`,
      [groups],
      {
        outFormat: oracledb.OUT_FORMAT_OBJECT
      }
    );

    return result.rows;
  } catch (error) {
    console.error(error);
  } finally {
    if (connection) {
      try {
        await connection.close();
      } catch (error) {
        console.error(error);
      }
    }
  }
}

const groups = [1, 2, 3]; // 传递一个包含组ID的数组

getRecordsForGroups(groups)
  .then((rows) => {
    console.log(rows);
  })
  .catch((error) => {
    console.error(error);
  });