mybatis分页插件pagehelper

pom.xml添加依赖

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

mybatis配置文件添加节点

<!-- 
    plugins在配置文件中的位置必须符合要求，否则会报错，顺序如下:
    properties?, settings?, 
    typeAliases?, typeHandlers?, 
    objectFactory?,objectWrapperFactory?, 
    plugins?, 
    environments?, databaseIdProvider?, mappers?
-->

<plugins>
    <plugin interceptor="com.github.pagehelper.PageHelper">
        <!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->
        <property name="helperDialect" value="Mysql"/>
    </plugin>
</plugins>

方法

public void demo(){

    SqlSession session = MyBatisUtil.getSession();
    HuaMapper huaMapper = session.getMapper(HuaMapper.class);
    //pageNum 页码 pageSize 每页显示多少条
    PageHelper.startPage(2,8);
    ArrayList<Hua> list = huaMapper.getHuaList();

    PageInfo<Hua> list1 = new PageInfo<Hua>(list);
    for(Hua h : list){
        System.out.println("id="+h.getId()+"  name="+h.getName());
    }
}