MyBatis-分页插件PageHelper

1.添加依赖

<!--        分页插件依赖-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.2.0</version>
        </dependency>

2.在mybatis配置文件中设置分页插件

<!--    设置分页插件-->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
        </plugin>
    </plugins>

3.dao和mapper

 //分页查询
    List<Emp> selectAllEmp();



    <select id="selectAllEmp" resultType="Emp">
        select * from emp
    </select>

4.测试

public class PageHelperTest {
    public static SqlSessionFactory ssf = null;

    static {
        try {
            //读取配置文件
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            //通过配置文件读取创建sql会话工厂
            ssf = new SqlSessionFactoryBuilder().build(is);

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    /*
    * PageInfo{pageNum=1, pageSize=3, size=3, startRow=1, endRow=3, total=12, pages=4,
    * list=Page{count=true, pageNum=1, pageSize=3, startRow=0, endRow=3, total=12, pages=4,
    * reasonable=false, pageSizeZero=false}
    * [Emp(emp_id=1, emp_name=ccc, age=20, gender=男),
    * Emp(emp_id=2, emp_name=mmm, age=22, gender=男),
    * Emp(emp_id=3, emp_name=sss, age=21, gender=男)],
    * prePage=0, nextPage=2, isFirstPage=true, isLastPage=false, hasPreviousPage=false, hasNextPage=true,
    *  navigatePages=3, navigateFirstPage=1, navigateLastPage=3, navigatepageNums=[1, 2, 3]}
    * */
    @Test
    public void pageHelper() {
        SqlSession sqlSession = ssf.openSession(true);
        EmpDao mapper = sqlSession.getMapper(EmpDao.class);
        //查询功能之前开启分页功能
        Page<Object> page = PageHelper.startPage(3, 3);
        List<Emp> list = mapper.selectAllEmp();
        //查询功能之后获取分页相关的所有数据
        PageInfo<Emp> pageInfo = new PageInfo<>(list,3);
        list.forEach(System.out::println);
        //System.out.println(page);
        System.out.println(pageInfo);
    }
}

 分页插件的详细数据介绍

出现分页插件添加依赖问题无效 可以重新install一下