处理nodejs数据库异步函数的最佳方式是什么

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

function query(sql) {
  return new Promise((resolve, reject) => {
    connection.query(sql, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

// 使用Promise进行数据库查询
query('SELECT * FROM users')
  .then(results => {
    console.log(results);
  })
  .catch(error => {
    console.error(error);
  });

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

function query(sql) {
  return new Promise((resolve, reject) => {
    connection.query(sql, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

// 使用async/await进行数据库查询
async function getUsers() {
  try {
    const results = await query('SELECT * FROM users');
    console.log(results);
  } catch (error) {
    console.error(error);
  }
}

getUsers();