express框架mysql

npm install mysql

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

const app = express();

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

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

// 定义一个简单的路由来测试数据库连接
app.get('/', (req, res) => {
  connection.query('SELECT 1 + 1 AS solution', (error, results, fields) => {
    if (error) throw error;
    res.send(`The solution is: ${results[0].solution}`);
  });
});

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

connection.query('SELECT * FROM users', (error, results, fields) => {
  if (error) {
    console.error('Error executing query:', error);
    return res.status(500).send('Internal Server Error');
  }
  res.json(results);
});