使用nodejs在Mysql中插入多个复选框选择

<form action="/submit" method="post">
  <label><input type="checkbox" name="hobbies[]" value="reading"> 阅读</label>
  <label><input type="checkbox" name="hobbies[]" value="sports"> 运动</label>
  <label><input type="checkbox" name="hobbies[]" value="music"> 音乐</label>
  <button type="submit">提交</button>
</form>

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

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

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

app.post('/submit', (req, res) => {
  const hobbies = req.body.hobbies;
  const userId = 1; // 假设用户ID为1

  if (!hobbies || hobbies.length === 0) {
    return res.status(400).send('请选择至少一个兴趣爱好');
  }

  const query = 'INSERT INTO user_hobbies (user_id, hobby) VALUES ?';
  const values = hobbies.map(hobby => [userId, hobby]);

  connection.query(query, [values], (error, results) => {
    if (error) {
      console.error(error);
      return res.status(500).send('数据库插入失败');
    }
    res.send('兴趣爱好已成功保存');
  });
});

app.listen(3000, () => {
  console.log('服务器运行在 http://localhost:3000');
});