如何根据mysql中的两个单选按钮值填充select输入

<form action="/submit" method="post">
  <input type="radio" name="option" value="option1"> Option 1
  <input type="radio" name="option" value="option2"> Option 2
  <button type="submit">Submit</button>
</form>

<select id="selectInput"></select>

<script>
  // 使用JavaScript监听表单提交事件
  document.querySelector('form').addEventListener('submit', function(event) {
    event.preventDefault(); // 阻止表单默认提交行为

    // 获取选中的单选按钮值
    var selectedOption = document.querySelector('input[name="option"]:checked').value;

    // 发起AJAX请求到后端处理程序
    var xhr = new XMLHttpRequest();
    xhr.open('POST', '/submit');
    xhr.setRequestHeader('Content-Type', 'application/json');
    xhr.onload = function() {
      if (xhr.status === 200) {
        var response = JSON.parse(xhr.responseText);
        populateSelectInput(response.result);
      }
    };
    xhr.send(JSON.stringify({ option: selectedOption }));
  });

  // 根据后端返回的结果填充select输入
  function populateSelectInput(data) {
    var selectInput = document.getElementById('selectInput');
    selectInput.innerHTML = ''; // 清空select输入

    // 根据数据创建option元素并添加到select输入中
    data.forEach(function(item) {
      var option = document.createElement('option');
      option.value = item.value;
      option.textContent = item.label;
      selectInput.appendChild(option);
    });
  }
</script>

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

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

// MySQL数据库连接配置
const dbConfig = {
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
};

// 处理表单提交的路由
app.post('/submit', function(req, res) {
  const selectedOption = req.body.option;

  // 创建MySQL数据库连接
  const connection = mysql.createConnection(dbConfig);

  // 构建SQL查询语句
  let sql = '';
  if (selectedOption === 'option1') {
    sql = 'SELECT * FROM table1';
  } else if (selectedOption === 'option2') {
    sql = 'SELECT * FROM table2';
  }

  // 执行SQL查询
  connection.query(sql, function(error, results) {
    if (error) {
      console.error('MySQL query error:', error);
      res.status(500).json({ error: 'Internal Server Error' });
    } else {
      res.json({ result: results });
    }

    // 关闭数据库连接
    connection.end();
  });
});

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