使用node.js、express和jade中的MySQL值填充选择菜单

const mysql = require('mysql2');

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

// 连接到数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ', err);
    return;
  }
  console.log('Connected to MySQL database');
});

// 查询MySQL数据库中的值
connection.query('SELECT * FROM your_table', (err, results) => {
  if (err) {
    console.error('Error querying MySQL database: ', err);
    return;
  }
  
  // 将查询结果传递给Express路由
  app.get('/', (req, res) => {
    res.render('index', { data: results });
  });
});

// 关闭数据库连接
connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL database connection: ', err);
    return;
  }
  console.log('Closed MySQL database connection');
});

select(name='your_select_menu')
  each item in data
    option(value=item.id)= item.name