使用 mongoTemplate 进行分页

问题描述

我有一个带有 Pageable 的查询:

I have a Query with Pageable:

Query query = new Query().with(new PageRequests(page, size))

如何使用 MongoTemplate 执行它?我没有看到一个方法返回 Page<T>.

How can I execute it with MongoTemplate ? I don't see a single method returning Page<T>.

推荐答案

确实MongoTemplate没有findXXX with Pageables.

It's true that the MongoTemplate doesn't have findXXX with Pageables.

但是你可以使用 Spring Repository PageableExecutionUtils 来实现.

But you can use the Spring Repository PageableExecutionUtils for that.

在您的示例中，它看起来像这样:

In your example it would look like this:

Pageable pageable = new PageRequests(page, size);
Query query = new Query().with(pageable);
List<XXX> list = mongoTemplate.find(query, XXX.class);
return PageableExecutionUtils.getPage(
                       list, 
                       pageable, 
                       () -> mongoTemplate.count(Query.of(query).limit(-1).skip(-1), XXX.class));

就像在原始的 Spring Data Repository 中一样，PageableExecutionUtils 将执行一个计数请求并将其包装到一个漂亮的 Page 中.

Like in the original Spring Data Repository, the PageableExecutionUtils will do a count request and wrap it into a nice Page for you.

这里你可以看到spring也在做同样的事情.

Here you can see that spring is doing the same.