mongodb的分页排序查询与jpa的类似,使用springdata中提供的接口就可以实现,直接上代码:
public Page<User> selUsersSortAndPage(Integer pageNum,Integer size,String userName){
//userName为传入的查询条件,也可以以对象的形式传入多个查询条件
BasicDBObject basicDBObject = new BasicDBObject();
//加入userName查询条件(精确匹配)
basicDBObject.put("userName",userName);
//模糊查询
Pattern pattern = Pattern.compile("^.*"+"北京"+".*$",Pattern.CASE_INSENSITIVE);
basicDBObject.put("address",pattern);
//or查询,或city有北京,或companyAdderss中有北京的
//先创建这几个查询条件
BasicDBObject basicDBObject2 = new BasicDBObject.put("city",pattern );
BasicDBObject basicDBObject3 = new BasicDBObject.put("companyAdderss",pattern );
//将查询条件加入到BasicDBList对象中
BasicDBList dbList = new BasicDBList();
dbList.add(basicDBObject2);
dbList.add(basicDBObject3);
//形如,$or:[{"city":"北京"},{"companyAdderss":"北京"}]
basicDBObject.put("$or",dbList);
//排序
Sort sort = new Sort(Direction.desc,"age");
//创建分页模板(包含排序规则)
Pageable pageable = PageRequest.of(pageNum-1,size,sort);
Query query = new BasicQuery(basicDBObject.toJson());
//数据总数查询
Long count = mongoTemplate.find(query,User.class);
List list = mongoTemplate.find(query.with(pageable),User.class);
//组装分页数据,Page对象要自己定义,包含总页数,总条数,每页大小及当前页等信息
Page<User> page = new Page(...);
}
Page对象要自己定义,springData中有提供,直接使用也可以。