#!/usr/bin/env python
# coding:UTF-8
"""
@version: python3.x
@author:曹新健
@contact: 617349013@qq.com
@software: PyCharm
@file: 2、查询文档.py
@time: 2018/9/23 22:38
"""
import pymongo
from pymongo import MongoClient
from bson.objectid import ObjectId #用于id查询
#连接服务器
conn = MongoClient("localhost",27017)
#连接数据库
db = conn.mydb
#获取集合
collection = db.student
#查询文档
'''
#查询部分文档
res = collection.find({"age":{"$gt":15}})
for i in res:
print(i)
#查询全部文档
res = collection.find()
for i in res:
print(i)
#统计数据
res = collection.find({"age":{"$gt":15}}).count()
print(res)
#根据id查询
res = collection.find({"_id":ObjectId("5ba82fe261bc5c245ce9e149")})
print(res[0])
#排序
#res = collection.find().sort("age") #升序
res = collection.find().sort("age",pymongo.DESCENDING) #降序
for i in res:
print(i)
'''
#分页
res = collection.find().skip(5).limit(5)
for i in res:
print(i)
#断开
conn.close()