在mySQL数据库中插入来自react-native和node-js的多条记录

import axios from 'axios';

const sendDataToBackend = async (data) => {
  try {
    const response = await axios.post('http://backend-url/api/insertData', data);
    console.log(response.data); // 可选的，用于处理后端返回的响应
  } catch (error) {
    console.error(error);
  }
};

// 调用函数发送数据
const data = [
  { name: 'Record 1', value: 10 },
  { name: 'Record 2', value: 20 },
  { name: 'Record 3', value: 30 },
];

sendDataToBackend(data);

const mysql = require('mysql2');

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

// 处理来自React Native的数据并插入到数据库
app.post('/api/insertData', (req, res) => {
  const data = req.body; // 假设数据以JSON格式发送

  // 构建插入语句
  const values = data.map(({ name, value }) => `('${name}', ${value})`).join(',');

  // 执行插入操作
  const query = `INSERT INTO your-table (name, value) VALUES ${values}`;
  connection.query(query, (error, results) => {
    if (error) {
      console.error(error);
      res.status(500).json({ error: 'Failed to insert data' });
    } else {
      res.json({ success: true });
    }
  });
});

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