博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
(06)mongodb 游标与分页
阅读量:4350 次
发布时间:2019-06-07

本文共 1569 字,大约阅读时间需要 5 分钟。

遍历1:

> var mycursor=db.person.find();

> while(mycursor.hasNext()){printjson(mycursor.next())}
{ "_id" : 1, "name" : "张三", "sex" : "男", "age" : 37.3 }
{ "_id" : 2, "name" : "张三", "sex" : "男", "age" : 27.3 }
{ "_id" : 3, "name" : "张三", "sex" : "男", "age" : 27.3 }
{ "_id" : 4, "name" : "李四", "class" : "三班", "score" : 90 }
{ "_id" : 5, "like" : "football", "name" : "王五" }
{
"_id" : ObjectId("5d4190e8c21b717496b2989b"),
"name" : "lisi",
"age" : 13,
"area" : "chaoyang",
"gender" : "male"
}
>

遍历2:

> var mycursor=db.person.find();

> mycursor.forEach(function(obj){printjson(obj)})
{ "_id" : 1, "name" : "张三", "sex" : "男", "age" : 37.3 }
{ "_id" : 2, "name" : "张三", "sex" : "男", "age" : 27.3 }
{ "_id" : 3, "name" : "张三", "sex" : "男", "age" : 27.3 }
{ "_id" : 4, "name" : "李四", "class" : "三班", "score" : 90 }
{ "_id" : 5, "like" : "football", "name" : "王五" }
{
"_id" : ObjectId("5d4190e8c21b717496b2989b"),
"name" : "lisi",
"age" : 13,
"area" : "chaoyang",
"gender" : "male"
}
>

分页:(skip、limit);

db.person.find().skip((n-1)*m).limit(m); 查询第n页,每一页m条

> var mycursor=db.person.find().skip((1-1)*2).limit(2);  共两页,第一页

> while(mycursor.hasNext()){printjson(mycursor.next())}
{ "_id" : 1, "name" : "张三", "sex" : "男", "age" : 37.3 }
{ "_id" : 2, "name" : "张三", "sex" : "男", "age" : 27.3 }
>
> var mycursor=db.person.find().skip((2-1)*2).limit(2);  共两页,第二页
> while(mycursor.hasNext()){printjson(mycursor.next())}
{ "_id" : 3, "name" : "张三", "sex" : "男", "age" : 27.3 }
{ "_id" : 4, "name" : "李四", "class" : "三班", "score" : 90 }
>

 

转载于:https://www.cnblogs.com/javasl/p/11279285.html

你可能感兴趣的文章
VsVim - Shortcut Key (快捷键)
查看>>
HDU5447 Good Numbers
查看>>
08.CXF发布WebService(Java项目)
查看>>
java-集合框架
查看>>
RTMP
查看>>
求一个数的整数次方
查看>>
点云PCL中小细节
查看>>
铁路信号基础
查看>>
RobotFramework自动化2-自定义关键字
查看>>
CMU Bomblab 答案
查看>>
技术分析淘宝的超卖宝贝
查看>>
Azure云服务托管恶意软件
查看>>
My安卓知识6--关于把项目从androidstudio工程转成eclipse工程并导成jar包
查看>>
旧的起点(开园说明)
查看>>
生产订单“生产线别”带入生产入库单
查看>>
crontab导致磁盘空间满问题的解决
查看>>
自定义滚动条
查看>>
APP开发手记01(app与web的困惑)
查看>>
初识前端作业1
查看>>
ffmpeg格式转换命令
查看>>