单击提交按钮怎么保存mysql数据库

// 前端代码
<form id="myForm">
  <input type="text" name="name" />
  <input type="email" name="email" />
  <button type="submit">提交</button>
</form>

<script>
  document.getElementById("myForm").addEventListener("submit", function (event) {
    event.preventDefault(); // 阻止默认提交行为
    
    // 获取表单数据
    const formData = new FormData(event.target);
    
    // 将表单数据发送到后端
    fetch("/saveData", {
      method: "POST",
      body: formData
    })
    .then(response => response.json())
    .then(data => {
      console.log("数据保存成功");
    })
    .catch(error => {
      console.error("保存数据时出错:", error);
    });
  });
</script>

// 后端代码 (Node.js + Express)
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"
});

// 连接到MySQL数据库
connection.connect();

// 创建API接口来保存数据
app.post("/saveData", (req, res) => {
  const { name, email } = req.body;

  // 将数据插入到数据库表中
  const sql = "INSERT INTO users (name, email) VALUES (?, ?)";
  connection.query(sql, [name, email], (error, results, fields) => {
    if (error) {
      console.error("保存数据时出错:", error);
      res.status(500).json({ error: "保存数据时出错" });
    } else {
      res.json({ message: "数据保存成功" });
    }
  });
});

// 启动服务器
app.listen(port, () => {
  console.log(`服务器正在运行于 http://localhost:${port}`);
});