[Java知识库]Mybatis-分页插件Pagehelper

1. Maven中添加相应依赖

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.3.0</version>
        </dependency>

2. 配置文件注册插件

    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    </plugins>

3. JAVA程序

    public void test() throws Exception {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
            //开启分页，参数一为页号，参数二为一页几条记录
            PageHelper.startPage(2, 3);
            List<Employee> list = mapper.selectAll();
            //参数一为查询结果，参数二为分页导航栏中显示的页码数。
            //PageInfo中有许多分页信息，如是否是第一页，生成的分页导航栏中的页码
            PageInfo pageInfo = new PageInfo(list, 4);
            for (Employee employee : list) {
                System.out.println(employee.toString());
            }
            for (int navigatepageNum : pageInfo.getNavigatepageNums()) {
                System.out.println(navigatepageNum);
            }
        }finally {
            sqlSession.close();
        }
    }

输出

Employee(id=4, name=赵六, deptId=2)
Employee(id=5, name=威爷, deptId=3)
Employee(id=12, name=Ben, deptId=2)
1
2
3