Java中mongodb使用and和or的复合查询

最新推荐文章于 2021-02-16 09:37:39 发布

weixin_30480651

最新推荐文章于 2021-02-16 09:37:39 发布

阅读量115

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/lcp12306/p/6101352.html

版权

条件类似：a=5 or (a=2 and b>3)
BasicDBList endList = new BasicDBList();

BasicDBObject forceEnd = new BasicDBObject();
forceEnd.put("status", 5);

BasicDBList condList = new BasicDBList();
BasicDBObject autoEnd = new BasicDBObject();
condList.add(new BasicDBObject("status", 2));
condList.add(new BasicDBObject("endTime", new BasicDBObject("$lt", new Date())));
autoEnd.put("$and",condList);

endList.add(forceEnd);
endList.add(autoEnd);

basicDBObject.put("$or",endList);

转载于:https://www.cnblogs.com/lcp12306/p/6101352.html