使用typescript在sql查询后返回布尔值

import { Connection, createConnection } from 'mysql';

async function executeQuery(query: string): Promise<boolean> {
  const connection: Connection = await createConnection({
    host: 'your_database_host',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database_name',
  });

  return new Promise<boolean>((resolve, reject) => {
    connection.query(query, (error, results) => {
      if (error) {
        reject(error);
      } else {
        // 判断查询结果是否为空
        const isEmpty: boolean = results.length === 0;
        resolve(isEmpty);
      }
      connection.end();
    });
  });
}

// 调用示例
const sqlQuery: string = 'SELECT * FROM your_table';
executeQuery(sqlQuery)
  .then((isEmpty: boolean) => {
    console.log(`Is query result empty? ${isEmpty}`);
  })
  .catch((error) => {
    console.error('Error executing SQL query:', error);
  });