如何在不使用Sequelize的情况下定义模型？(带有MySQL的Node.JS)

npm install mysql

const mysql = require('mysql');

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

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

class User {
  constructor(data) {
    this.id = data.id;
    this.name = data.name;
    this.email = data.email;
  }

  // 创建用户
  static create(userData, result) {
    const sql = 'INSERT INTO users SET ?';
    connection.query(sql, userData, (err, res) => {
      if (err) return result(err, null);
      result(null, { id: res.insertId, ...userData });
    });
  }

  // 获取用户
  static get(userId, result) {
    const sql = 'SELECT * FROM users WHERE id = ?';
    connection.query(sql, [userId], (err, res) => {
      if (err) return result(err, null);
      result(null, res[0] ? new User(res[0]) : null);
    });
  }

  // 更新用户
  static update(userId, userData, result) {
    const sql = 'UPDATE users SET ? WHERE id = ?';
    connection.query(sql, [userData, userId], (err, res) => {
      if (err) return result(err, null);
      result(null, { id: userId, ...userData });
    });
  }

  // 删除用户
  static delete(userId, result) {
    const sql = 'DELETE FROM users WHERE id = ?';
    connection.query(sql, [userId], (err, res) => {
      if (err) return result(err, null);
      result(null, res.affectedRows > 0);
    });
  }
}

module.exports = User;

const User = require('./User');

// 创建用户
User.create({ name: 'John Doe', email: 'john.doe@example.com' }, (err, user) => {
  if (err) throw err;
  console.log(user);

  // 获取用户
  User.get(user.id, (err, user) => {
    if (err) throw err;
    console.log(user);

    // 更新用户
    user.name = 'Jane Doe';
    User.update(user.id, user, (err, user) => {
      if (err) throw err;
      console.log(user);

      // 删除用户
      User.delete(user.id, (err, result) => {
        if (err) throw err;
        console.log(result);
      });
    });
  });
});