spring data jpa @query和pageabel

原文地址 https://stackoverflow.com/questions/22345081/spring-data-jpa-query-and-pageable

您可以对native query 使用分页。它在此处记录：https：//docs.spring.io/spring-data/jpa/docs/current/reference/html/#_native_queries

“ 您可以通过自己指定 count query 来使用本机查询进行分页：示例59.使用@Query在查询方法中声明分页的本机count query ”

public interface UserRepository extends JpaRepository<User, Long> {

  @Query(value = "SELECT * FROM USERS WHERE LASTNAME = ?1",
    countQuery = "SELECT count(*) FROM USERS WHERE LASTNAME = ?1",
    nativeQuery = true)
  Page<User> findByLastname(String lastname, Pageable pageable);
}

打赏