如何使用Axios和Express将React数组数据插入Mysql？

import axios from 'axios';

const sendDataToServer = async (data) => {
  try {
    const response = await axios.post('/api/data', data);
    console.log(response.data); // 可选：打印服务器返回的响应数据
  } catch (error) {
    console.error(error);
  }
};

const express = require('express');
const bodyParser = require('body-parser');

const app = express();

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));

// 其他中间件和路由设置...

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

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

const router = express.Router();

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_mysql_username',
  password: 'your_mysql_password',
  database: 'your_database_name',
});

router.post('/data', (req, res) => {
  const { dataArray } = req.body;

  const query = 'INSERT INTO your_table_name (column_name) VALUES ?';
  const values = dataArray.map((data) => [data]);

  connection.query(query, [values], (error, results) => {
    if (error) {
      console.error(error);
      res.status(500).send('Error inserting data into MySQL');
    } else {
      res.status(200).send('Data inserted successfully');
    }
  });
});

module.exports = router;

const express = require('express');
const dataRouter = require('./routes/data');

const app = express();

// 其他中间件设置...

app.use('/api', dataRouter);

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