使用动态查询实现spring mvc分页

Question

在我的情况下，我有一个审查实体，它由审查状态和提交日期组成。

我正在尝试使用JpaRepository，但我不确定如何使用它来支持以下搜索查询。

SELECT * from review WHERE review.reviewStatus = 2 AND 
  ( review.submittedOn BETWEEN '2015-09-08' AND '2015-09-09' )

我可以看到（参考http://docs.spring.io/spring-data/jpa/docs/1.4.3.release/reference/html/jpa.repositories.html)，我们可以为特定的查询定义方法，比如FindByName。

SELECT * from review WHERE ( review.submittedOn BETWEEN 
  '2015-09-08' AND '2015-09-09' )

SELECT * from review WHERE review.reviewStatus = 2

请指导和/或分享链接以实现相同。

提前谢了。

Answer 1

查看http://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/repository/pagingandsortingrepository.html

可以将可分页对象传递到FindAll方法中

http://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/domain/pageable.html

public List<Person> search(String searchTerm, int pageIndex) {
    LOGGER.debug("Searching persons with search term: " + searchTerm);

    //Passes the specification created by PersonSpecifications class and the page specification to the repository.
    Page requestedPage = personRepository.findAll(lastNameIsLike(searchTerm), constructPageSpecification(pageIndex));

    return requestedPage.getContent();
}

/**
 * Returns a new object which specifies the the wanted result page.
 * @param pageIndex The index of the wanted result page
 * @return
 */
private Pageable constructPageSpecification(int pageIndex) {
    Pageable pageSpecification = new PageRequest(pageIndex, NUMBER_OF_PERSONS_PER_PAGE, sortByLastNameAsc());
    return pageSpecification;
}