使用mongodb和node js从Collection中获取所有数据

我有一个名为时间表的集合。我想显示仅由Classroom：6 bakti组成的Collection中的所有数据当我运行console.log（）时。我只有文档的对象ID。我想显示具有Classroom：6 bakti。

来自收藏的数据

{
    "_id" : ObjectId("5eaf124852a49d2cb4aa9d46"),
    "teacher" : "Siti Noor Khairani binti Afifudeen",
    "timeslot" : 1,
    "subject" : "Bahasa Melayu",
    "classroom" : "6 bakti",
    "year" : "2020",
    "__v" : 0
}

{
    "_id" : ObjectId("5eaf12a252a49d2cb4aa9d47"),
    "teacher" : "Siti Noor Khairani binti Afifudeen",
    "timeslot" : 2,
    "subject" : "Bahasa Inggeris",
    "classroom" : "6 Usaha",
    "year" : "2020",
    "__v" : 0
}
{
    "_id" : ObjectId("5eafd9285015e9001756d568"),
    "teacher" : "Siti Noor Khairani binti Afifudeen",
    "timeslot" : 2,
    "subject" : "Bahasa Melayu",
    "classroom" : "6 bakti",
    "year" : "2020",
    "__v" : 0
}

这是我的路线文件

我使用教室获取url参数。

router.get('/timetable_class/view/:id',mid, function(req,res){
  Timetable.find({classroom:req.params.id},{year:currentYear},function(err,timetable){
    if (err) throw err;
    console.log(currentYear);
    console.log(timetable, "hai");
    res.render('admin_content/view_timetable_class',{'timetable':timetable});
  });
});

查看文件

<H1><FONT COLOR="DARKCYAN"><CENTER><%= timetable %></FONT></H1>
       <table border="2" cellspacing="3" align="center">
          <tr>
          <td align="center">
              <td><%= timetable.classroom %>  
               <td><%= timetable.subject %>                                
      </td>

</tr>

尝试使用$ and运算符：{$ and：[{}，{}]}

const currentYear = new Date().getFullYear()

Timetable.find({$and:[{classroom:req.params.id},{year:currentYear}]},function(err,timetable){
    if (err) throw err;
    console.log(currentYear);
    console.log(timetable, "hai");
    res.render('admin_content/view_timetable_class',{'timetable':timetable});
  });