将复选框值插入Sqlite数据库

<form id="myForm">
  <input type="checkbox" name="option1" value="value1"> Option 1<br>
  <input type="checkbox" name="option2" value="value2"> Option 2<br>
  <input type="checkbox" name="option3" value="value3"> Option 3<br>
  <input type="button" value="Submit" onclick="insertData()">
</form>

function insertData() {
  var form = document.getElementById("myForm");
  var checkboxes = form.getElementsByTagName("input");
  var selectedOptions = [];

  for (var i = 0; i < checkboxes.length; i++) {
    if (checkboxes[i].type === "checkbox" && checkboxes[i].checked) {
      selectedOptions.push(checkboxes[i].value);
    }
  }

  // 使用Sqlite库执行插入操作
  // 示例代码如下，具体的插入操作可能因使用的Sqlite库而有所不同
  var sqlite = require('sqlite');
  var db = new sqlite.Database('mydatabase.db');

  db.run("INSERT INTO options (value) VALUES (?)", selectedOptions, function(err) {
    if (err) {
      console.error(err.message);
    } else {
      console.log("Data inserted successfully");
    }
  });

  db.close();
}

const express = require('express');
const sqlite3 = require('sqlite3').verbose();

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

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

app.post('/insertData', (req, res) => {
  const selectedOptions = req.body.selectedOptions;

  const db = new sqlite3.Database('mydatabase.db');

  db.run("INSERT INTO options (value) VALUES (?)", selectedOptions, function(err) {
    if (err) {
      console.error(err.message);
      res.status(500).send("Error inserting data into database");
    } else {
      console.log("Data inserted successfully");
      res.status(200).send("Data inserted successfully");
    }
  });

  db.close();
});

app.listen(port, () => {
  console.log(`Server listening at http://localhost:${port}`);
});