带有mysql查询的异步函数不会返回查询结果node.js

const mysql = require('mysql');

// 创建MySQL连接池
const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 定义异步函数，执行MySQL查询
async function executeQuery(query) {
  return new Promise((resolve, reject) => {
    // 从连接池中获取连接
    pool.getConnection((err, connection) => {
      if (err) {
        reject(err);
        return;
      }

      // 执行查询
      connection.query(query, (err, results) => {
        // 释放连接
        connection.release();

        if (err) {
          reject(err);
          return;
        }

        resolve(results);
      });
    });
  });
}

// 调用异步函数执行查询
async function main() {
  try {
    const query = 'SELECT * FROM your_table';
    const results = await executeQuery(query);
    console.log(results);
  } catch (error) {
    console.error(error);
  }
}

// 执行主函数
main();