基于JPA的分页排序

public interface TaskDao extends JpaRepository<Task, Long> {
  @Query("select * from tb_task t where t.task_name = ?1 order by ?2", nativeQuery = true)
  Task findByTaskName(String taskName,int chip);
}

    @Test
    public void test() {
        Sort sort=Sort.by(Sort.Direction.DESC,"gold");//排序规则，条件字段为list，可以多个
        Pageable pageable=PageRequest.of(0,20,sort);//分页范围，排序
        Page<User> userPage = userDao.findAll(pageable);
        log.info("userPage:{}", userPage.getContent());
    }