- Query query=new Query();
- Criteria criteria=Criteria.where("name").is("tom").and("studentNum").in(numberList);
- query.addCriteria(criteria);
- 或new Query(criteria);
- Criteria criteria=Criteria.where("indexWarnGrade").ne("0").orOperator(Criteria.where("resId").is(channelId),Criteria.where("resBelongChannelId").is(channelId));
- query.addCriteria(criteria);
- query.with(new Sort(Direction.DESC, "indexWarnLatelyDate"));
- //分页
- int currentPage = (initPagingBean.getStart()/initPagingBean.getPageSize())+1;
- Query query=new Query();
- //查询通道和通道下属的设备告警信息
- Criteria criteria=Criteria.where("indexWarnGrade").ne("0").orOperator(Criteria.where("resId").is(channelId),Criteria.where("resBelongChannelId").is(channelId));
- query.addCriteria(criteria);
- query.with(new Sort(Direction.DESC, "indexWarnLatelyDate"));
- int total = (int) this.realMongodbServiceImpl.findCount(MonitorObject.class, query);
- initPagingBean.setTotalItems(total);
- //查询mo集合
- List<MonitorObject> moList=this.realMongodbServiceImpl.findList(MonitorObject.class, query, currentPage, initPagingBean.getPageSize());
- initPagingBean.setDataList(wvList);
- return initPagingBean;
- //is相当于等于
- //in相当于sql中的in