javascript操作mysql数据库

const mysql = require('mysql2');

// 创建连接池
const pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase',
  connectionLimit: 10
});

// 查询数据
pool.query('SELECT * FROM users', (err, results) => {
  if (err) {
    console.error(err);
    return;
  }
  console.log(results);
});

// 插入数据
const user = { name: 'John', age: 30 };
pool.query('INSERT INTO users SET ?', user, (err, results) => {
  if (err) {
    console.error(err);
    return;
  }
  console.log('User inserted:', results.insertId);
});

// 更新数据
const userId = 1;
const newName = 'Jane';
pool.query('UPDATE users SET name = ? WHERE id = ?', [newName, userId], (err, results) => {
  if (err) {
    console.error(err);
    return;
  }
  console.log('User updated:', results.affectedRows);
});

// 删除数据
const userId = 1;
pool.query('DELETE FROM users WHERE id = ?', userId, (err, results) => {
  if (err) {
    console.error(err);
    return;
  }
  console.log('User deleted:', results.affectedRows);
});

// 关闭连接池（在应用程序退出时）
pool.end();