在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操作符以确保进行精确匹配。这将确保只有完全匹配的记录才会被返回

String queryStr =			dbcollectionusersrn			+ aggregatern			+ lookuprn			+ from menurn			+ localFieldmenu_idrn			+ foreignFieldmenu_id rn			+ as menurn			+ rn			+ matchrn			+ $andrn			+ use

原文地址: http://www.cveoy.top/t/topic/iJNh 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录