SpringBoot | Mybatis通用mapper的分页查询

方法一

    @Test
    public void findByPage() {
        PageHelper.startPage(1, 10, " id desc");
        PageInfo<Country> pageInfo = new PageInfo<>(this.countryMapper.selectAll());
        //pageInfo.getList().size():10
        //sql==>>SELECT Id, countryname, countrycode FROM country order by id desc LIMIT ?
        System.out.println("pageInfo.getList().size():"+pageInfo.getList().size());
        System.out.println("pageInfo = " + pageInfo);
    }

方法二

  @Test
    public void findByPage2() {
        List<Country> countries = this.countryMapper.selectAll();
        PageHelper.startPage(1, 10, " id desc");
        PageInfo<Country> pageInfo = new PageInfo<>(countries);
        //pageInfo.getList().size():183
        //sql==>> SELECT Id,countryname,countrycode FROM country
        System.out.println("pageInfo.getList().size():"+pageInfo.getList().size());
        System.out.println("pageInfo = " + pageInfo);
    }

可以看出不能直接把数据放入PageInfo中，这样起不到分页查询的效果。还可以分页查询使用limit关键字，支持mysql数据库，