js 访问mysql数据库

// 安装mysql模块：npm install mysql
const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接数据库
connection.connect();

// 执行SQL查询
connection.query('SELECT * FROM users', (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

// 关闭数据库连接
connection.end();

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

// 将connection.query转换为Promise形式
const query = util.promisify(connection.query).bind(connection);

// 使用async/await处理异步查询
async function getUsers() {
  try {
    const results = await query('SELECT * FROM users');
    console.log(results);
  } catch (error) {
    throw error;
  } finally {
    connection.end();
  }
}

getUsers();