Node.js与MySQL构建API服务器完整教程

mkdir my-api-server
cd my-api-server

npm install express mysql

npm install nodemon --save-dev

CREATE DATABASE mydb;

USE mydb;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100)
);

touch index.js

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

const app = express();

// 解析JSON请求体
app.use(express.json());

// 创建MySQL连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username', // 替换为你的用户名
  password: 'your_password', // 替换为你的密码
  database: 'mydb'
});

// 在数据库连接上测试连接
connection.connect(error => {
  if (error) throw error;
  console.log('Successfully connected to the database.');
});

// 定义一个API端点
app.get('/users', (req, res) => {
  connection.query('SELECT * FROM users', (error, results) => {
    if (error) throw error;
    res.json(results);
  });
});

// 启动服务器
const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});

{
  "scripts": {
    "start": "node index.js",
    "dev": "nodemon index.js"
  }
}

npm run dev

curl http://localhost:3000/users