MongoDB 分页查询

最新推荐文章于 2023-11-29 14:37:09 发布

java_wliang

最新推荐文章于 2023-11-29 14:37:09 发布

阅读量605

点赞数

分类专栏： MongoDB 文章标签： MongoDB分页

本文链接：https://blog.csdn.net/java_wliang/article/details/38401581

版权

MongoDB 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

在运用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" }