java mongocollection_MongoDb完结笔记-与java结合

学习主题：MongoDb3

学习目标：

掌握如下内容

mongodb数据库前提：

1 连接 MongoDB 数据库

1.1 创建工程(maven：jar)

在 POM 文件中添加 MongoDB 驱动坐标

org.mongodb

mongo-java-driver

3.8.2

未封装代码：

public class MongoDBDemo {

public static void main(String[] args) {

//创建连接对象

MongoClient client = new MongoClient("192.168.41.145", 27017);

//获取MongoDB数据库

MongoDatabase database = client.getDatabase("develop");

//获取MongoDB中的集合

MongoCollection collection = database.getCollection("dev");

//连接成功显示ok

System.out.println("OK.................");

}

}

1.2 创建 MongoDB 连接

封装 MongoDBUtil

import com.mongodb.MongoClient;

import com.mongodb.client.MongoCollection;

import com.mongodb.client.MongoDatabase;

/**

* @author cyj

* @date 2019-11-04 15:11

*/

public class MongoDBUtil {

private static MongoClient client=null;

static {

if (client==null){

client=new MongoClient("192.168.41.145", 27017);

}

}

//获取MongoDB数据库

public static MongoDatabase getDatabas(String dbName){

return client.getDatabase(dbName);

}

//获取MongoDB中的集合

public static MongoCollection getCollection(String dbName,String collName){

return getDatabas(dbName).getCollection(collName);

}

}

测试：

public class MongoDBDemo {

public static void main(String[] args) {

MongoDBUtil.getCollection("develop","dev");

//连接成功显示ok

System.out.println("OK.................");

}

}

1.3 创建 MongoDB 的认证连接

封装 MongoDBAuthUtil

import com.mongodb.MongoCredential;

import com.mongodb.ServerAddress;

import com.mongodb.MongoClient;

import com.mongodb.client.MongoCollection;

import com.mongodb.client.MongoDatabase;

import java.util.Arrays;

/**

* 创建MongoDB链接-使用用户认证

* @author cyj

* @date 2019-11-04 15:34

*/

public class MongoDBAuthUtil {

private static MongoClient client = null;

static {

if(client == null){

//创建一个封装用户认证信息

MongoCredential credential = MongoCredential.createCredential("sxt", "develop", "sxt".toCharArray());

//封装MongoDB的地址与端口

ServerAddress address = new ServerAddress("192.168.41.145", 27017);

client = new MongoClient(address, Arrays.asList(credential));

}

}

//获取MongoDB数据库

public static MongoDatabase getDatabase(String dbName){

return client.getDatabase(dbName);

}

//获取MongoDB中的集合

public static MongoCollection getCollection(String dbName, String collName){

MongoDatabase database = getDatabase(dbName);

return database.getCollection(collName);

}

}

1.4 创建 MongoDB 的池连

封装 MongoDBPoolUtil

package com.bjsxt;

import com.mongodb.MongoClient;

import com.mongodb.MongoClientOptions;

import com.mongodb.ServerAddress;

import com.mongodb.client.MongoCollection;

import com.mongodb.client.MongoDatabase;

/**

* 使用池连的方式获取连接

*/

public class MongoDBPoolUtil {

private static MongoClient client = null;

static{

if(client == null){

MongoClientOptions.Builder builder = new MongoClientOptions.Builder();

builder.connectionsPerHost(10);//每个地址的最大连接数

builder.connectTimeout(5000);//连接超时时间

builder.socketTimeout(5000);//设置读写操作超时时间

ServerAddress address = new ServerAddress("192.168.70.156",27017);

client = new MongoClient(address,builder.build());

}

}

//获取MongoDB数据库

public static MongoDatabase getDatabase(String dbName){

return client.getDatabase(dbName);

}

//获取MongoDB中的集合

public static MongoCollection getCollection(String dbName, String collName){

MongoDatabase database = getDatabase(dbName);

return database.getCollection(collName);

}

}

1.5 创建 MongoDB 的认证池连

封装 MongoDBAuthPoolUtil

import com.mongodb.MongoClient;

import com.mongodb.MongoClientOptions;

import com.mongodb.MongoCredential;

import com.mongodb.ServerAddress;

import com.mongodb.client.MongoCollection;

import com.mongodb.client.MongoDatabase;

/**

* @author cyj

* @date 2019-11-04 16:27

*/

public class MongoDBAuthPoolUtil {

private static MongoClient client=null;

static {

if (client==null){

MongoClientOptions.Builder builder=new MongoClientOptions.Builder();

builder.connectionsPerHost(10);//每个地址的最大连接数

builder.connectTimeout(5000);//连接超时时间

builder.socketTimeout(5000);//设置读写操作超时时间

MongoCredential credential=MongoCredential.createCredential("sxt", "develop", "sxt".toCharArray());

ServerAddress address = new ServerAddress("192.168.41.145", 27017);

client = new MongoClient(address,credential,builder.build());

}

}

//获取MongoDB数据库

public static MongoDatabase getDatabase(String dbName){

return client.getDatabase(dbName);

}

//获取MongoDB中的集合

public static MongoCollection getCollection(String dbName, String collName){

return getDatabase(dbName).getCollection(collName);

}

//创建集合

public static void createCollection(String dbName,String collName){

getDatabase(dbName).createCollection(collName);

}

//删除集合

public static void dropCollection(MongoCollection coll){

coll.drop();

}

}

2 操作集合

2.1 创建集合

//创建集合

public static void createCollection(String dbName,String collName){

getDatabase(dbName).createCollection(collName);

}

2.2 获取集合

//获取MongoDB中的集合

public static MongoCollection getCollection(String dbName, String collName){

return getDatabase(dbName).getCollection(collName);

}

2.3 删除集合

//删除集合

public static void dropCollection(MongoCollection coll){

coll.drop();

}

3 操作文档

3.1 添加文档

3.1.1 添加单个文档 3.1.2 添加多个文档

import com.mongodb.client.MongoCollection;

import org.bson.Document;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

/**

* @author cyj

* @date 2019-11-04 16:55

*/

public class InsertDocument {

public static void main(String[] args) {

InsertDocument docu = new InsertDocument();

//docu.inesrtSingleDocument();

docu.insertManyDocument();

}

/**

* 添加单个文档

*/

public void inesrtSingleDocument(){

//获取集合

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

// {}---->Document

//append(String key,Object value)---->{key:value}

Document docu=new Document();

docu.append("username","lisi").append("userage",26).append("userdesc","Very Good").append("userlike", Arrays.asList(new String[]{"Music","Sport"}));

collection.insertOne(docu);

}

/**

* 文档的批量添加

*/

public void insertManyDocument(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

List list = new ArrayList();

for(int i=0;i<5;i++){

Document docu = new Document();

docu.append("username","zhangsan"+i);

docu.append("userage",20+i);

docu.append("userdesc","OK"+i);

docu.append("userlike",Arrays.asList(new String[]{"Music","Sport"}));

list.add(docu);

}

collection.insertMany(list);

}

}

运行结果：注：因为我是在develop库下创建的sxt用户,所以创建devtest集合时不用切换到bjsxt用户

3.2 更新文档

3.2.1 更新单个文档单个键

/**

* 更新单个文档单个键

* --> db.devtest.update({username:{$eq:"lisi"}},{$set:{userage:28}})

*/

public void updateSingleDocumentSingleKey(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

//更新文档

//Filters封装了条件的一个工具类 {$set:{userage:28}}

collection.updateOne(Filters.eq("username","lisi"),new Document("$set",new Document("userage",28)));

}

3.2.2 更新单个文档多个键

/**

* 更新单个文档多个键 -->db.devtest.update({username:{$eq:"zhangsan0"}},{$set:{userage:18,userdesc:"Very Good"}})

*/

public void updateSingleDocumentManyKey(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

collection.updateOne(Filters.eq("username","zhangsan0"),new Document("$set",new Document("userage",18).append("userdesc","Very Good")));

}

3.2.3 更新多个文档中的单个键

/**

* 更新多个文档单个键

* --> db.devtest.update({username:{$ne:"zhangsan0"}},{$set:{userage:18,userdesc:"Very Good"}},{multi:true})

*/

public void updateManyDocumentSingleKey(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

collection.updateMany(Filters.ne("username",null),new Document("$set",new Document("userdesc","Very Good")));

}

3.2.4 更新多个文档中的多个键

/**

* 更新多个文档多个键

* --> db.devtest.update({username:{$ne:null}},{$set:{userage:20,userdesc:"OK"}},{multi:true})

*/

public void updateManyDocumentManyKey(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

collection.updateMany(Filters.ne("username",null),new Document("$set",new Document("userdesc","OK").append("userage",20)));

}

3.2.5 更新文档中的数组

/**

* 更新文档中的数组

* {$push:{}}

* -->db.devtest.update({username:{$eq:"lisi"}},{$push:{userlike:"Art"}})

*/

public void updateDocumentArray(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

collection.updateOne(Filters.eq("username","lisi"),new Document("$push",new Document("userlike","Art")));

}

3.3 查询文档

3.3.1 查询全部文档

/**

* 查询全部文档

* -->db.devtest.find()

*/

public void selectDocumentAll(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

//返回的是一个文档的迭代器

FindIterable iterable = collection.find();

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.2 根据_id 查询文档-$eq

/**

* 根据_id查询文档

* --> db.devtest.find("5dbfe840e755c006c0b03217")

*/

public void selectDocumentById(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.eq("_id",new ObjectId("5d398cd64b022206d87d168e")));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

ObjectId()是一个对象，所以需要new ,而不能直接传字符串

------------

3.3.3 查询多个文档-$gt

/**

* 根据年龄查询文档，条件是年龄大于19

* --> db.devtest.find({userage:{$gt:19}})

*/

public void selectDocumentConditionByGt(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.gt("userage",19));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.4 查询多个文档-$type

/**

* 根据年龄查询文档，添加是年龄的值是整数类型(number)

* --> db.devtest.find({userage:{$type:"number"}})

*/

public void selectDocumentConditionByType(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.type("userage","number"));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.5 查询多个文档-$in

/**

* 查询用户的名字为 zhangsan1,zhangsan2

*--> db.devtest.find({username:{$in:["zhangsan1","zhangsan2"]}})

*--> db.devtest.find({$or:[{username:"zhangsan1"},{username:"zhangsan2"}]})

*/

public void selectDocumentConditionByIn(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.in("username","zhangsan1","zhangsan2"));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.6 查询多个文档-$nin

/**

* 查询用户的名字不是 zhangsan1,zhangsan2

*--> db.devtest.find({username:{$nin:["zhangsan1","zhangsan2"]}})

*/

public void selectDocumentConditionByNin(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.nin("username","zhangsan1","zhangsan2"));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.7 查询多个文档-$regex

/**

* 查询用户的名字是z开头2结尾的。

*--> db.devtest.find({username:/^z.*2$/}) Pattern：java.util包

*/

public void selectDocumentConditionByRegex(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.regex("username", Pattern.compile("^z.*2$")));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.8 逻辑运算符-$and

/**

* 查询用户username是zhangsan1并且年龄为20岁的用户

* --> db.devtest.find({$and:[{username:{$eq:"zhangsan1"}},{userage:{$eq:20}}]})

*/

public void selectDocumentConditionUseAnd(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.and(Filters.eq("username","zhangsan1"),Filters.eq("userage",20),Filters.eq("userdesc","OK")));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.9 逻辑运算符-$or

/**

* 查询用户要求username是list，或者userage是20 或者 userdesc是Very Good

* --> db.devtest.find({$or:[{username:{$eq:"lisi"}},{userage:{$eq:20}},{userdesc:{$eq:"Very Good"}}]})

*/

public void selectDocumentConditionUseOr(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.or(Filters.eq("username","lisi"),Filters.eq("userage",20),Filters.eq("userdesc","Very Good")));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.10 逻辑运算符-$and 与$or 联合使用

/**

* 查询文档中username为lisi并且年龄为20岁，或者userdesc为Very Good

* --> db.devtest.find({$or:[{$and:[{username:{$eq:"lisi"}},{userage:{$eq:20}}]},{userdesc:{$eq:"Very Good"}}]})

*/

public void selectDocumentConditionAndOr(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.or(Filters.and(Filters.eq("username","lisi"),Filters.eq("userage",20)),Filters.eq("userdesc","Very Good")));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.3.11 查询文档-排序处理

/**

* 查询文档中username是z开头的，根据username对结果做降序排序。1升序排序， -1降序排序规则 $sort:{username,-1}

* --> db.devtest.find({username:/^z/}).sort({username:-1})

*/

public void selectDocumentSorting(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

FindIterable iterable = collection.find(Filters.regex("username", Pattern.compile("^z"))).sort(new Document("username",-1));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike"));

}

}

3.4 日期操作

3.4.1 插入系统当前日期

/**

* 插入系统当前日期

*--> db.devtest.insert({username:"wangwu",userage:22,userdesc:"Very Good",userlike:["Music","Art"],userbirth:new Date()})

*/

public void insertDocumentSystemDate(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop", "devtest");

Document docu=new Document();

docu.put("username","wangwu");

docu.put("userage",22);

docu.put("userdesc","Very Good");

docu.put("userlike", Arrays.asList(new String[]{"Music","Art"}));

docu.put("userbirth",new Date());

collection.insertOne(docu);}

3.4.2 插入指定日期

创建日期处理工具类

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

/**

* @author cyj

* @date 2019-11-04 19:30

*/

public class DateUtil {

/**

* Date To String

*/

public static String dateToString(String parten, Date date){

SimpleDateFormat format=new SimpleDateFormat(parten);

return format.format(date);

}

/**

* String To Date

*/

public static Date stringToDate(String parten,String date){

SimpleDateFormat format=new SimpleDateFormat(parten);

Date d=null;

try {

d = format.parse(date);

} catch (ParseException e) {

e.printStackTrace();

}

return d;

}

}

添加指定日期

/**

* 插入指定日期

* --> db.devtest.insert({username:"zhaoliu",userage:24,userdesc:"Very Good",userlike:["Music","Art"],userbirth:new Date("2019-11-05T13:32:13")})

*/

public void insertDocumentCustoDate(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

Date date= DateUtil.stringToDate("yyyy-MM-dd HH:mm:ss","2019-11-05 13:32:13");

Document docu = new Document();

docu.put("username","zhaoliu");

docu.put("userage",24);

docu.put("userdesc","Very Good");

docu.put("userlike", Arrays.asList(new String[]{"Music","Art"}));

docu.put("userbirth",date);

collection.insertOne(docu);

}

3.4.3 查询日期-$eq

/**

* 查询日期：查询用的生日为2019-05-01 13:32:13的用户信息

*--> db.devtest.find({userbirth:{$eq:new Date("2019-11-05T13:32:13")}})

*/

public void selectDocumentDateUseEq(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

Date date = DateUtil.stringToDate("yyyy-MM-dd HH:mm:ss","2019-11-05 13:32:13");

FindIterable iterable = collection.find(Filters.eq("userbirth", date));

MongoCursor cursor = iterable.iterator();

while (cursor.hasNext()){

Document docu = cursor.next();

String temp=DateUtil.dateToString("yyyy-MM-dd HH:mm:ss",(Date) docu.get("userbirth"));

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike")+"\t"+temp);

}

}

3.4.4 查询日期-$gt

/**

* 查询日期：查询用的生日大于2019-01-01 00:00:00的用户信息

*--> db.devtest.find({userbirth:{$gt:new Date("2019-01-01T00:00:00")}})

*/

public void selectDocumentDateUseGt(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

Date date = DateUtil.stringToDate("yyyy-MM-dd HH:mm:ss","2019-01-01 00:00:00");

FindIterable iterable = collection.find(Filters.gt("userbirth",date));

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

String temp = DateUtil.dateToString("yyyy-MM-dd HH:mm:ss",(Date) docu.get("userbirth"));

System.out.println(docu.get("username")+"\t"+docu.get("userage")+"\t"+docu.get("userdesc")+"\t"+docu.get("userlike")+"\t"+temp);

}

}

3.5 聚合操作

3.5.1 聚合操作-计算文档总数-$sum

需求：查询集合中的文档数量

Mongo Shell：db.dev.aggregate([{$group:{_id:null,count:{$sum:1}}}])

/**

* 需求：查询集合中的文档数量

Mongo Shell:db.dev.aggregate([{$group:{_id:null,count:{$sum:1}}}])

*/

public void selectDocumentAggregateCount(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document sum = new Document();

sum.put("$sum",1);

Document count = new Document();

count.put("_id",null);

count.put("count",sum);

Document group = new Document();

group.put("$group",count);

List list = new ArrayList();

list.add(group);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("count"));

}

}

3.5.2 聚合操作-计算值的总和-$sum

需求：查询集合中所有 size 键中的值的总和

Mongo Shell：db.dev.aggregate([{$group:{_id:null,totalSize:{$sum:"$size"}}}])

/**

* 需求：查询集合中所有size键中的值的总和

Mongo Shell:db.dev.aggregate([{$group:{_id:null,totalSize:{$sum:"$size"}}}])

*/

public void selectDocumentAggregateSum(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document sum = new Document();

sum.put("$sum","$size");

Document totalSize = new Document();

totalSize.put("_id",null);

totalSize.put("totalSize",sum);

Document group = new Document();

group.put("$group",totalSize);

List list = new ArrayList();

list.add(group);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("totalSize"));

}

}

3.5.3 聚合操作-在分组中计算值的总和-$sum

需求：对 title 进行分组，计算每组中的 size 的总和

Mongo Shell：db.dev.aggregate([{$group:{_id:"$title",totalSize:{$sum:"$size"}}}])

/**

* 需求：对title进行分组，计算每组中的size的总和

Mongo Shell:db.dev.aggregate([{$group:{_id:"$title",totalSize:{$sum:"$size"}}}])

*/

public void selectDocumentAggregateGroupBySum(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document sum= new Document();

sum.put("$sum","$size");

Document totalSize = new Document();

totalSize.put("_id","$title");

totalSize.put("totalSize",sum);

Document group = new Document();

group.put("$group",totalSize);

List list = new ArrayList();

list.add(group);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("totalSize"));

}

}

3.5.4 聚合操作-分组前的数据过滤-$match

需求：查询 dev 集合有多少文档的 size 大于 200。

Mongo Shell： db.dev.aggregate([{$match:{size:{$gt:200}}},{$group:{_id:null,totalSize:{$sum:1}}}])

/**

* 需求：查询dev集合有多少文档的size大于200。

Mongo Shell：

db.dev.aggregate([{$match:{size:{$gt:200}}},{$group:{_id:null,totalSize:{$sum:1}}}])

*/

public void selectDocumentAggregateGroupByWhere(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document gt = new Document();

gt.put("$gt",200);

Document size = new Document();

size.put("size",gt);

Document match = new Document();

match.put("$match",size);

Document sum = new Document();

sum.put("$sum",1);

Document totalSize = new Document();

totalSize.put("_id",null);

totalSize.put("totalSize",sum);

Document group = new Document();

group.put("$group",totalSize);

List list = new ArrayList();

list.add(match);

list.add(group);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("totalSize"));

}

}

3.5.5 聚合操作-分组后的数据过滤-$match

需求：查询 dev 集合，根据 title 分组计算出每组的 size 的总和，并过滤掉总和小于 200 的文档。

Mongo Shell： db.dev.aggregate([{$group:{_id:"$title",totalSize:{$sum:"$size"}}},{$match:{totalSize:{$gt: 200}}}])

/**

* 需求：查询dev集合，根据title分组计算出每组的size的总和，并过滤掉总和小于200的文档。

Mongo Shell：

db.dev.aggregate([{$group:{_id:"$title",totalSize:{$sum:"$size"}}},{$match:{totalSize:{$gt:200}}}])

*/

public void selectDocumentAggregateGroupByHaving(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document sum = new Document();

sum.put("$sum","$size");

Document totalSize = new Document();

totalSize.put("_id","$title");

totalSize.put("totalSize",sum);

Document group = new Document();

group.put("$group",totalSize);

//{$match:{totalSize:{$gt:200}}}

Document gt = new Document();

gt.put("$gt",200);

Document mtotalSize = new Document();

mtotalSize.put("totalSize",gt);

Document match = new Document();

match.put("$match",mtotalSize);

List list = new ArrayList();

list.add(group);

list.add(match);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu.get("totalSize"));

}

}

3.5.6 聚合操作-$project-聚合投影约束

需求：查询 dev 集合，将数组中的内容拆分显示，并只显示 title 键与 tags 键的值。

Mongo Shell： db.dev.aggregate([{$unwind:"$tags"},{$project:{_id:0,tags:"$tags",title:"$title"}}])

/**

* 需求：查询dev集合，将数组中的内容拆分显示，并只显示title键与tags键的值。

Mongo Shell：

db.dev.aggregate([{$unwind:"$tags"},{$project:{_id:0,tags:"$tags",title:"$title"}}])

*/

public void selectDocumentProject(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document unwind = new Document();

unwind.put("$unwind","$tags");

Document pro = new Document();

pro.put("_id",0);

pro.put("tags","$tags");

pro.put("title","$title");

Document project = new Document();

project.put("$project",pro);

List list = new ArrayList();

list.add(unwind);

list.add(project);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

System.out.println(cursor.next());

}

}

3.5.7 聚合操作-$project-字符串处理

需求：查询 dev 集合，将数组中的内容拆分显示。将 title 字段和 tags 字段的值拼接为 一个完整字符串并在 Title_Tags 字段中显示。

Mongo Shell： db.dev.aggregate([{$unwind:"$tags"},{$project:{_id:0,Title_Tags:{$concat:["$title","-","$tag s"]}}}])

/**

* 需求：查询dev集合，将数组中的内容拆分显示。将title字段和tags字段的值拼接为一个完整字符串并在Title_Tags字段中显示。

Mongo Shell：

db.dev.aggregate([{$unwind:"$tags"},{$project:{_id:0,Title_Tags:{$concat:["$title","-","$tags"]}}}])

*/

public void selectDocumentProjectConcat(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document unwind = new Document();

unwind.put("$unwind","$tags");

Document concat = new Document();

concat.put("$concat", Arrays.asList(new String[]{"$title","-","$tags"}));

Document title = new Document();

title.put("_id",0);

title.put("Title_Tags",concat);

Document project = new Document();

project.put("$project",title);

List list = new ArrayList();

list.add(unwind);

list.add(project);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

System.out.println(cursor.next());

}

}

3.5.8 聚合操作-$project 算术运算

需求：查询dev集合中数据，显示title和 size字段，为size字段数据做加 1 操作，显示字段命名为 New_Size。排除那些没有 size 键的文档。

Mongo Shell： db.dev.aggregate([{$match:{size:{$ne:null}}},{$project:{_id:0,title:1,New_Size:{$add:["$si ze",1]}}}])

/**

* 需求：查询dev集合中数据，显示title和size字段，为size字段数据做加1操作，显示字段命名为New_Size。排除那些没有size键的文档。

Mongo Shell：

db.dev.aggregate([{$match:{size:{$ne:null}}},{$project:{_id:0,title:1,New_Size:{$add:["$size",1]}}}])

*/

public void selectDocumentProjectAdd(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document ne = new Document();

ne.put("$ne",null);

Document size = new Document();

size.put("size",ne);

Document match = new Document();

match.put("$match",size);

//{$project:{_id:0,title:1,New_Size:{$add:["$size",1]}}}

Document add = new Document();

add.put("$add",Arrays.asList(new Object[]{"$size",1}));

Document new_Size = new Document();

new_Size.put("_id",0);

new_Size.put("title",1);

new_Size.put("New_Size",add);

Document project = new Document();

project.put("$project",new_Size);

List list = new ArrayList();

list.add(match);

list.add(project);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

System.out.println(cursor.next());

}

}

3.5.9 聚合操作-$project 日期处理

需求：查询 devtest 集合查询那些有生日的用户，并按照 YYYY 年 mm 月 dd 日 HH:MM:SS 格式显示日期。

Mongo Shell： db.devtest.aggregate([{$match:{userbirth:{$ne:null}}},{$project:{ 自定义日期格式:{$dateToString:{format:"%Y 年%m 月%d 日 %H:%M:%S",date:"$userbirth"}}}}])

/**

* 需求：查询devtest集合查询那些有生日的用户，并按照YYYY年mm月dd日 HH:MM:SS格式显示日期。

* 注意：如果直接在MongoDB中做日期的格式化处理，那么是按照表示UTC时间来处理的，会少8个小时。建议在程序中

* 通过java.util.Date来做日期的转换。

Mongo Shell：

db.devtest.aggregate([{$match:{userbirth:{$ne:null}}},{$project:{自定义日期格式:{$dateToString:{format:"%Y年%m月%d日 %H:%M:%S",date:"$userbirth"}}}}])

*/

public void selectDocumentProjectDate(){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","devtest");

Document ne = new Document();

ne.put("$ne",null);

Document birth = new Document();

birth.put("userbirth",ne);

Document match = new Document();

match.put("$match",birth);

//{$project:{自定义日期格式:{$dateToString:{format:"%Y年%m月%d日 %H:%M:%S",date:"$userbirth"}}}}

Document format = new Document();

format.put("format","%Y年%m月%d日 %H:%M:%S");

format.put("date","$userbirth");

Document dateToString = new Document();

dateToString.put("$dateToString",format);

Document custoDate = new Document();

custoDate.put("自定义日期格式",dateToString);

Document project = new Document();

project.put("$project",custoDate);

List list = new ArrayList();

list.add(match);

list.add(project);

AggregateIterable iterable = collection.aggregate(list);

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

System.out.println(cursor.next());

}

}

3.6 分页查询

3.6.1 使用 skip 与 limit 方法分页

/**

* 通过skip与limit方法实现分页

* @param pageIndex 当前页

*/

public void selectDocumentByPageUseSkipAndLimit(int pageIndex){

int page=(pageIndex-1)*2; //第几页=(当前页-1)*每页显示数量

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

//可以给查询添加条件

Document condition=new Document("size",new Document("$ne",null));

long total = collection.countDocuments(condition);//返回条件的总条数,也可以放在查询中

System.out.println("总条数："+total);

//long total = collection.countDocuments();

FindIterable iterable = collection.find(condition).skip(page).limit(2);//显示返回满足条件的数据

// FindIterable iterable = collection.find().skip(page).limit(2);

MongoCursor cursor = iterable.iterator();

while (cursor.hasNext()){

Document document = cursor.next();

System.out.println(document);

}

}

3.6.2 优化分页查询(skip方法比较耗时，因为要换算出现在应该跳过多少文档，skip会扫描所有的文档。所以文档较多的时候就不适合使用 )

使用条件判断替换 skip 方法 (跳页很麻烦)

/**

* 通过条件判断实现分页

* @param pageIndex 当前页

* @param pageSize 每页显示多少条

* @param lastId 最后文档的某一个key的值，作为查询下一个数据的判断条件。此处随便给一个都行

*/

public void selectDocumentByPageUseCondition(int pageIndex,int pageSize,String lastId){

MongoCollection collection = MongoDBAuthPoolUtil.getCollection("develop","dev");

Document condition = new Document("size",new Document("$ne",null));

long countNum = collection.countDocuments(condition);//满足条件的有多少条

System.out.println(countNum);

FindIterable iterable = null;

if(pageIndex == 1){//查的是第一页，第一页不需要跳过

iterable = collection.find(condition).limit(pageSize);

}else{//查的不是第一页

if(lastId != null){

condition.append("_id",new Document("$gt",new ObjectId(lastId)));

iterable = collection.find(condition).limit(pageSize);

}

}

MongoCursor cursor = iterable.iterator();

while(cursor.hasNext()){

Document docu = cursor.next();

System.out.println(docu);

}

}

测试：

public static void main(String[] args) {

SelectDocumentByPage page = new SelectDocumentByPage();

//page.selectDocumentByPageUseSkipAndLimit(1);

}