将javascript数据发送到mysql服务器表

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

const app = express();
const port = 3000;

// 创建与MySQL数据库的连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 建立数据库连接
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);
});

// 处理POST请求
app.post('/submit-data', (req, res) => {
  // 获取前端发送的数据
  const data = req.body;

  // 将数据插入到MySQL数据库的表中
  const sql = 'INSERT INTO mytable (column1, column2) VALUES (?, ?)';
  const values = [data.value1, data.value2];

  connection.query(sql, values, (err, result) => {
    if (err) {
      console.error('Error inserting data into MySQL table: ' + err.stack);
      res.status(500).send('Error inserting data into MySQL table');
      return;
    }
    console.log('Data inserted into MySQL table');
    res.status(200).send('Data inserted into MySQL table');
  });
});

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