如何将表单输入保存到json数据中并保存到一个字段表中

<form id="myForm">
  <label for="name">Name:</label>
  <input type="text" id="name" name="name"><br><br>
  <label for="email">Email:</label>
  <input type="email" id="email" name="email"><br><br>
  <input type="submit" value="Submit">
</form>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
  $(document).ready(function() {
    $('#myForm').submit(function(event) {
      event.preventDefault(); // 阻止表单默认提交行为

      // 获取表单数据
      var formData = {
        name: $('#name').val(),
        email: $('#email').val()
      };

      // 发送POST请求到服务器
      $.ajax({
        type: 'POST',
        url: '/saveFormData',
        data: JSON.stringify(formData),
        contentType: 'application/json',
        success: function(response) {
          alert('Form data saved successfully!');
        },
        error: function(error) {
          alert('Error saving form data.');
        }
      });
    });
  });
</script>

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

const app = express();
app.use(bodyParser.json());

// 创建MySQL连接池
const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 处理表单数据保存请求
app.post('/saveFormData', (req, res) => {
  const formData = req.body;

  // 将表单数据转换为JSON字符串
  const jsonData = JSON.stringify(formData);

  // 将JSON数据保存到MySQL数据库中的字段表
  pool.query('INSERT INTO form_data (json_data) VALUES (?)', [jsonData], (error, results) => {
    if (error) {
      console.error('Error saving form data:', error);
      res.status(500).json({ error: 'Error saving form data' });
    } else {
      res.json({ success: true });
    }
  });
});

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