node和mysql的例子

const express = require('express');
const mysql = require('mysql');

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

// 连接到 MySQL
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database!');
});

const app = express();

// 创建一个简单的路由来执行查询
app.get('/users', (req, res) => {
  const sql = 'SELECT * FROM users';
  connection.query(sql, (err, result) => {
    if (err) throw err;
    res.json(result);
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'correct_username',
  password: 'correct_password',
  database: 'correct_database'
});

const pool = mysql.createPool({
  connectionLimit: 10,
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});