如何用nodeJS从MySql数据库中创建html选择选项菜单

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

const sql = 'SELECT * FROM options';

connection.query(sql, (err, results) => {
  if (err) throw err;

  // 处理查询结果
  const options = results.map((row) => {
    return `<option value="${row.id}">${row.name}</option>`;
  });

  // 生成HTML选择选项菜单
  const html = `<select>${options.join('')}</select>`;

  console.log(html);

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