如何在带有异步和池的节点中使用Mysql2获取MySQL的insertId？

const mysql = require('mysql2/promise');

// 创建连接池配置
const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  waitForConnections: true,
  connectionLimit: 10, // 连接池中的最大连接数
  queueLimit: 0
});

// 异步函数执行插入操作并获取insertId
async function insertData(data) {
  let connection;
  try {
    // 从连接池获取连接
    connection = await pool.getConnection();
    
    // 执行插入操作
    const [result] = await connection.execute('INSERT INTO your_table (column1, column2) VALUES (?, ?)', [data.value1, data.value2]);
    
    // 获取并返回insertId
    return result.insertId;
  } catch (error) {
    console.error('Error executing insert:', error);
    throw error;
  } finally {
    if (connection) connection.release(); // 释放连接回连接池
  }
}

// 使用示例
(async () => {
  try {
    const newId = await insertData({ value1: 'example1', value2: 'example2' });
    console.log('New record inserted with ID:', newId);
  } catch (error) {
    console.error('Failed to insert data:', error);
  }
})();