我在我的圖層中同時使用nativeQuery和作為：countQueryRepository
@Query(value = "select * FROM Person p where p.forename = :forename and p.surname = :surname",
countQuery = "SELECT count(*) FROM Person p where p.forename = :forename",
nativeQuery = true)
User findByForenameAndSurname(@Param("surname") String lastname,
@Param("forename") String firstname);
}
我想要由此回傳的整數計數，countQuery并且我想使用該計數來構造PageRequest我想nativeQuery用來獲取Page物件的物件。我可以在構造PageRequest物件之前訪問這個計數嗎？有什么辦法可以得到回傳的值countQuery嗎？
uj5u.com熱心網友回復：
如果您需要該頁面，只需回傳它：
@Query(value = "select * FROM Person p where p.forename = :forename and p.surname = :surname",
countQuery = "SELECT count(*) FROM Person p where p.forename = :forename",
nativeQuery = true)
Page<User> findByForenameAndSurname(@Param("surname") String lastname,
@Param("forename") String firstname);
}
Page 物件將包含您需要的所有內容。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/384405.html