mongo 多条件or

佚名 6年前 (2019-04-22) 随笔 2002人围观抢沙发百度已收录

or语句

1 > select * from xx where a=1 or b=2


2 > db.XXX.find({"$or":[{"a":1}, {"b":2}]});

等于java mongotemplate

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

1 Query query = new Query();
2 
3 Criteria criteria0 = new Criteria();
4 Criteria criteria1 = Criteria.where("accid").is(queryKey);
5 Criteria criteria2 = Criteria.where("phone").is(queryKey);
6 criteria0.orOperator(criteria1, criteria2);
7 
8 query.addCriteria(criteria0);
9 List<Player> playerList = mongoDao.findAll(query, MongoKey.PLAYER, Player.class);