@Query(value = "select * from Commodity C where C.name like CONCAT('%',:name,'%') ORDER BY ?#{#pageable}", countQuery = "SELECT count(*) FROM Commodity C where C.name like CONCAT('%',:name,'%') ", nativeQuery = true) Page<Commodity> findByName(@Param("name") String name, Pageable pageable);其中 ORDER BY ?#{#pageable}
is forPageable
.countQuery
is forPage<>
.