nodejs连接mysql数据库实例

const mysql = require('mysql');

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

// 连接数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err);
    return;
  }
  console.log('Connected to MySQL database!');

  // 执行查询
  connection.query('SELECT 1 + 1 AS solution', (error, results, fields) => {
    if (error) throw error;
    console.log('The solution is:', results[0].solution);
  });

  // 关闭连接
  connection.end((err) => {
    if (err) {
      console.error('Error closing the connection:', err);
      return;
    }
    console.log('Connection closed.');
  });
});

const Sequelize = require('sequelize');

const sequelize = new Sequelize('your_database', 'your_username', 'your_password', {
  host: 'localhost',
  dialect: 'mysql'
});

// 定义模型
const User = sequelize.define('user', {
  username: Sequelize.STRING,
  email: Sequelize.STRING
});

// 同步数据库
sequelize.sync().then(() => {
  return User.create({
    username: 'example',
    email: 'example@example.com'
  });
}).then(user => {
  console.log(user.toJSON());
}).catch(err => {
  console.error('Error:', err);
});