java操作MangoDB的聚合Aggregation用法-分页查询

最新推荐文章于 2022-10-20 09:58:03 发布

sim-uu

最新推荐文章于 2022-10-20 09:58:03 发布

阅读量2.8k

点赞数

分类专栏： java MangoDB NoSql 文章标签： java使用Aggregation调用MongoDB java聚合mangoDB MangoDB在java中分页 MangoDB分页查询 java分页MangoDB

本文链接：https://blog.csdn.net/weixin_37828719/article/details/102765150

版权

java 同时被 3 个专栏收录

18 篇文章 0 订阅

订阅专栏

NoSql

4 篇文章 0 订阅

订阅专栏

MangoDB

3 篇文章 0 订阅

订阅专栏

构造聚合

Aggregation aggregation = newAggregation(
						match(beforeCriteria),
						unwind("suborders"),
						match(endCriteria),
						sort(page.getSort()),
						skip(page.getPageNumber()),
						limit(page.getPageSize())
				);

创建条件

Criteria beforeCriteria = where("suborders.supplierChannel.other.supplier._id").is(new ObjectId(sourceId));
		Criteria endCriteria = where("suborders.supplierChannel.other.supplier._id").is(new ObjectId(sourceId));

		if (Strings.isNotBlank(keywords)) {
			endCriteria.orOperator(
					where("code").regex(keywords),
					where("member.code").regex(keywords),
					where("member.name").regex(keywords),
					where("status.name").regex(keywords));
		}

查找Count总记录数

	Aggregation countAggregation = newAggregation(
				match(beforeCriteria),
				unwind("suborders"),
				match(endCriteria),
				Count.count()
		);

调用

	@Autowired
	private MongoOperations mongoOperations;
	
		AggregationResults<OrderSource> orders = mongoOperations.aggregate(aggregation, Order.class, OrderSource.class);
		List<OrderSource> orderSources = orders.getMappedResults();

		AggregationResults<com.jfc.common.mongodb.Count> countResults = mongoOperations.aggregate(countAggregation,
				Order.class, com.jfc.common.mongodb.Count.class);
				
		long total = Count.get(countResults);
		
		return new org.springframework.data.domain.PageImpl<>(orderSources, page, total);