MongoDB 分页查询

在运用MongoDB进行分页查询的时候,往往需要使用分页查询,MongoDB进行分页查询往往需要使用

limit()、skip()、sort()这三个函数进行组合


首先输入测试数据,测试数据如下:

> db.test.find();
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a49"), "num" : 1, "name" : "小白1" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4a"), "num" : 2, "name" : "小白2" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4b"), "num" : 3, "name" : "小白3" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4c"), "num" : 4, "name" : "小白4" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4d"), "num" : 5, "name" : "小白5" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4e"), "num" : 6, "name" : "小白6" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a4f"), "num" : 7, "name" : "小白7" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a50"), "num" : 8, "name" : "小白8" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a51"), "num" : 9, "name" : "小白9" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a52"), "num" : 10, "name" : "小白10" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a53"), "num" : 11, "name" : "小白11" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a54"), "num" : 12, "name" : "小白12" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a55"), "num" : 13, "name" : "小白13" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a56"), "num" : 14, "name" : "小白14" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a57"), "num" : 15, "name" : "小白15" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a58"), "num" : 16, "name" : "小白16" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a59"), "num" : 17, "name" : "小白17" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a5a"), "num" : 18, "name" : "小白18" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a5b"), "num" : 19, "name" : "小白19" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a5c"), "num" : 20, "name" : "小白20" }

检索数据可以使用sort()方法来对数据进行排序,指定排序字段,并使用1或-1来指定排序方式是升序或降序

如:num字段降序

> db.test.find().sort({"num":-1})


可以使用limit()方法来读取指定数量的数据,还可以使用skip()方法来跳过指定数量的数据。对分页性能上面效率非常高


假设分页每页10条文档记录,则分页如下:

返回第一页文档数据,即前8条

> db.test.find().sort({"num":-1}).limit(8)
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aac"), "num" : 100, "name" : "小白100"
}
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aab"), "num" : 99, "name" : "小白99" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aaa"), "num" : 98, "name" : "小白98" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa9"), "num" : 97, "name" : "小白97" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa8"), "num" : 96, "name" : "小白96" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa7"), "num" : 95, "name" : "小白95" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa6"), "num" : 94, "name" : "小白94" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa5"), "num" : 93, "name" : "小白93" }

skip(num)可以跳过num条数据,如第二页数据:

> db.test.find().sort({"num":-1}).skip(8).limit(8)
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa4"), "num" : 92, "name" : "小白92" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa3"), "num" : 91, "name" : "小白91" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa2"), "num" : 90, "name" : "小白90" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa1"), "num" : 89, "name" : "小白89" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783aa0"), "num" : 88, "name" : "小白88" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a9f"), "num" : 87, "name" : "小白87" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a9e"), "num" : 86, "name" : "小白86" }
{ "_id" : ObjectId("53e1d7e0ce8db1dcd7783a9d"), "num" : 85, "name" : "小白85" }




  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MongoDB中进行分页查询可以通过使用MongoDB分页插件来实现。首先,需要配置MongoDB的相关信息。在配置类中使用@Configuration注解标记,并使用@Autowired注解将MongoTemplate注入进来。然后,使用@Bean注解标记一个方法,返回MongoPageHelper实例,该实例需要传入MongoTemplate对象作为参数。这样就完成了MongoDB配置的准备工作。 接下来,需要使用正确的分页办法来实现分页查询。在MongoDB中,推荐的分页解决方案是先查询当前页的第一数据,然后按顺序查询pageSize数据。这样可以提高查询的效率。 如果你想使用开箱即用的分页能力,可以使用MongoDB分页插件。该插件为MongoDB提供了方便的分页功能。你可以在我的博客中找到如何使用Maven引入该插件的详细信息。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [MongoDB分页的Java实现和分页需求的思考](https://blog.csdn.net/weixin_34303897/article/details/86400025)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *3* [mongo-page-helper:MongoDB分页插件](https://download.csdn.net/download/weixin_42098759/18715448)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值