java操作mongodb（分页）

来源：互联网发布：迷羊郁达夫知乎编辑：程序博客网时间：2024/06/02 02:19

使用skip+limit的方式实现分页。直接上代码（依赖的代码在上一篇博客中）：

/** * 分页查询 * @param page * @param pageSize * @return */public List<User> pageList(int page,int pageSize){DB myMongo = MongoManager.getDB("myMongo");DBCollection userCollection = myMongo.getCollection("user");DBCursor limit = userCollection.find().skip((page - 1) * 10).sort(new BasicDBObject()).limit(pageSize);List<User> userList = new ArrayList<User>();while (limit.hasNext()) {User user = new User();user.parse(limit.next());userList.add(user);}return userList;}

List<User> list = userAction.pageList(1,10);for(User user : list){System.out.println(user);}System.out.println("=======================");list = userAction.pageList(2,10);for(User user : list){System.out.println(user);}

输出如下：

id:2,name:manman,address:beijingid:1,name:jinhui,address:beijingid:3,name:3,address:3id:4,name:4,address:4id:5,name:5,address:5id:6,name:6,address:6id:7,name:7,address:7id:8,name:8,address:8id:9,name:9,address:9id:10,name:10,address:10=======================id:11,name:11,address:11id:12,name:12,address:12id:13,name:13,address:13id:13,name:13,address:13id:13,name:13,address:13id:13,name:13,address:13id:13,name:13,address:13

注意：

使用skip跳过少量的数据是很好的选择，但是如果跳过大量的数据的时候，skip方法就会执行的很慢。所以我们要尽量的避免使用skip跳过大量的数据。后面我们会提到如何优化大数据量的分页。

0 0