一、PageHelper的使用
使用步骤:
第一步:添加依赖:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.6</version>
</dependency>
第二步:配置pageHelper插件
配置pageHelper插件有两种方式:(1)在mybatis-config.xml文件中(2)在Spring的配置文件中(后面学习)
在mybatis-config.xml文件中:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.vince.pojo"></package>
</typeAliases>
<plugins>
<!-- com.github.pagehelper为PageHelper类所在包名 -->
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 页号自动回归到合理数值 -->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
<!-- 和spring整合后 environments配置将废除 -->
<environments default="development">
<environment id="development">
<!-- 使用jdbc事务管理 -->
<transactionManager type="JDBC" />
<!-- 数据库连接池 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://localhost:3306/bookdb?useSSL&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="123456" />
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.vince.mapper"></package>
</mappers>
</configuration>
项目测试:
public class BookServiceimpl implements BookService {
@Override
public PageInfo<BookInfo> findAll(Integer pageNum, Integer pageSize) {
SqlSession sqlSession = MyBatisUtils.openSession();
BookInfoMapper mapper = sqlSession.getMapper(BookInfoMapper.class);
// 分页查询
PageHelper.startPage(pageNum, pageSize);
List<BookInfo> booklist = mapper.findAll();
PageInfo<BookInfo> pageInfo = new PageInfo<>(booklist);
sqlSession.close();
return pageInfo;
}
pageInfo里面封装了有关分页的所有数据。
如:pageNum. ,pageSize ,totalSize .........
页面效果: