String queryStr = dbcollectionusersrn + aggregatern + lookuprn + from menurn + localFieldmenu_idrn + foreignFieldmenu_id rn + as menurn + rn + matchrn + $andrn + use
在Eclipse中查询微信云数据库并匹配username,institution和password,可以使用以下修改后的query语句:
String queryStr =
"db.collection('users')\r\n"
+ ".aggregate()\r\n"
+ ".lookup({\r\n"
+ " from: \"menu\",\r\n"
+ " localField:\"menu_id\",\r\n"
+ " foreignField:\"menu_id\", \r\n"
+ " as: \"menu\"\r\n"
+ "})\r\n"
+ ".match({\r\n"
+ " $and:[\r\n"
+ " {username:{$eq:\""+ userModel.getUsername() +"\"}},\r\n"
+ " {institution:{$eq:\""+ userModel.getInstitution() +"\"}},\r\n"
+ " {password:{$eq:\""+ userModel.getPasswords() +"\"}},\r\n"
+ " ]\r\n"
+ "})\r\n"
+ ".end()";
注意,我在每个匹配条件中添加了$eq操作符以确保进行精确匹配。这将确保只有完全匹配的记录才会被返回
原文地址: http://www.cveoy.top/t/topic/iJNh 著作权归作者所有。请勿转载和采集!