如何将下拉列表中的数据存储到我们的MySql数据库中？

CREATE TABLE options (
    id INT AUTO_INCREMENT PRIMARY KEY,
    value VARCHAR(255)
);

<select id="mySelect">
    <option value="option1">Option 1</option>
    <option value="option2">Option 2</option>
    <option value="option3">Option 3</option>
</select>
<button onclick="saveData()">Save</button>

function saveData() {
    var selectedOption = $("#mySelect").val(); // 获取选中的值
    
    // 发送AJAX请求到后端保存数据
    $.ajax({
        url: "/saveOption",
        method: "POST",
        data: {option: selectedOption},
        success: function(response) {
            alert("Data saved successfully!");
        },
        error: function() {
            alert("Failed to save data.");
        }
    });
}

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

const app = express();
const port = 3000;

// 创建MySQL连接
const connection = mysql.createConnection({
    host: "localhost",
    user: "your_username",
    password: "your_password",
    database: "your_database"
});

// 处理保存数据请求
app.post("/saveOption", (req, res) => {
    const option = req.body.option; // 获取发送的数据

    // 将数据插入到数据库中
    const query = "INSERT INTO options (value) VALUES (?)";
    connection.query(query, [option], (error, results) => {
        if (error) {
            console.error("Failed to save data:", error);
            res.status(500).send("Failed to save data.");
        } else {
            console.log("Data saved:", option);
            res.sendStatus(200);
        }
    });
});

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