MyBatis使用分页助手PageHelper进行查询分页数据库

1.在pom.xml导入jar依赖包

<dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.4</version>
    </dependency>
    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>0.9.1</version>
    </dependency>

2.sqlMapConfig.xml进行配置

     <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <!--分页参数合理化  -->
            <property name="reasonable" value="true"/>
        </plugin>
    </plugins>

3.使用

//设置分页相干参数
      PageHelper.startPage(1,3);//参数为开始页面，查询条数
      List<User> userList =mapper.findAllUser();
      for (User user:userList
           ) {
          System.out.println(user.getUsername());
      }

结果：

log4j:WARN No appenders could be found for logger (org.apache.ibatis.logging.LogFactory).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
波波
bb
hhh