如何在Node.js Express和mongodb中使用find()获取html中选定选项的值

const MongoClient = require('mongodb').MongoClient;
const url = 'mongodb://localhost:27017'; // MongoDB连接URL
const dbName = 'your-database-name'; // 数据库名称

app.post('/submit', (req, res) => {
  const selectedOption = req.body.option; // 获取HTML表单中选定选项的值

  MongoClient.connect(url, (err, client) => {
    if (err) throw err;

    const db = client.db(dbName);
    const collection = db.collection('your-collection-name'); // 集合名称

    collection.find({ option: selectedOption }).toArray((err, result) => {
      if (err) throw err;

      res.render('result', { data: result }); // 将查询结果传递给结果页面
      client.close();
    });
  });
});

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

<% if (data.length > 0) { %>
  <% data.forEach((item) => { %>
    <p><%= item.name %></p> <!-- 根据查询结果的字段进行显示 -->
  <% }); %>
<% } else { %>
  <p>No results found.</p>
<% } %>