如何使用node.js创建webservice将数据插入到mysql中？

npm init

npm install express mysql

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

const app = express();
const port = 3000; // 可根据需要修改端口号

const connection = mysql.createConnection({
  host: 'localhost', // MySQL服务器地址
  user: 'root', // MySQL用户名
  password: 'password', // MySQL密码
  database: 'database_name' // 数据库名称
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

app.post('/insert', (req, res) => {
  const data = req.body; // 假设请求中包含要插入的数据

  // 执行插入操作
  connection.query('INSERT INTO table_name SET ?', data, (err, results) => {
    if (err) {
      console.error('Error inserting data into MySQL: ' + err.stack);
      res.status(500).send('Error inserting data into MySQL');
      return;
    }
    res.status(200).send('Data inserted successfully');
  });
});

app.listen(port, () => {
  console.log('Server is running on port ' + port);
});

node app.js