SpringBoot进阶之JPA实现分页、排序

116 阅读 0 评论 77 点赞

我是靠谱客的博主无情世界，这篇文章主要介绍SpringBoot进阶之JPA实现分页、排序，现在分享给大家，希望可以做个参考。

---------------repository类代码------------

复制代码

1
2
3
4
5
6
public interface GirlRepository extends JpaRepository<Girl,Integer> {
    //分页、排序
    Page<Girl> findByName(String name,Pageable pageable);

}

--------------------Controller代码----------------------------

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
  @PostMapping(value = "/getid")
    @ResponseBody
    public Msg getId(@RequestParam(value = "name", defaultValue = "ASD") String name,
                    @RequestParam(value = "page", defaultValue = "0") Integer page,      //从第0个开始查
                    @RequestParam(value = "size", defaultValue = "15") Integer size,    //每页展示几个
                     @RequestParam(value = "sorts", defaultValue = "id") String sorts){   //排序的字段
        Sort sort = new Sort(Sort.Direction.DESC, sorts);    //排序
        Pageable pageable =new PageRequest(page,size,sort);
        Page<Girl> pages =girlRepository.findByName(name, pageable);
        Iterator<Girl> it=pages.iterator();
        while (it.hasNext()){
           logger.info("---------------------->id:" + ((Girl) it.next()).getId());
        }
        return ResultUtil.success(it);
   }