mybatis分页助手的使用

MyBatis核心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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/mybatis/example/BlogMapper.xml"/>
    </mappers>
</configuration>

MyBatis映射文件的外部依赖

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.mybatis.example.BlogMapper">
    <select id="selectBlog" resultType="Blog">
        select * from Blog where id = #{id}
    </select>
</mapper>

MyBatis快速入门（Dao）

InputStream inputStream = MybatisTest.class.getClassLoader().getResourceAsStream("mybatisConfig.xml");
System.out.println(inputStream);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sessionFactory.openSession();
userMapper = sqlSession.getMapper(UserMapper.class);

MyBatis分页助手的使用

1.引入Maven依赖

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>3.7.5</version>
</dependency>
<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>1.2</version>
</dependency>

2.在MyBatis核心配置文件中声明分页插件

<plugins>
    <plugin interceptor="com.github.pagehelper.PageHelper">
        <property name="dialect" value="mysql"/>
    </plugin>
</plugins>

3.在封装数据之前开启分页

PageHelper.startPage(1,3);
List<User> userList = userMapper.findAll();
for (User user : userList) {
    System.out.println(user);
}

4.分页助手的相关方法及其所代表的含义

PageInfo<User> pageInfo = new PageInfo<>(userList);
System.out.println(pageInfo.getPageNum() + "当前页");
System.out.println(pageInfo.getPages() + "总页数");
System.out.println(pageInfo.getTotal()+"总记录数");
System.out.println(pageInfo.getPrePage() + "上一页");
System.out.println(pageInfo.getNextPage() + "下一页");
System.out.println(pageInfo.isIsFirstPage() + "是否是第一页");
System.out.println(pageInfo.isIsLastPage() + "是否是最后一页");