MyBatis: 分页插件PageHelper直接传递分页参数的用法

一、加分页插件依赖

<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.13</version>
        </dependency>

二、配置分页插件，并配置相关属性：

<plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <property name="supportMethodsArguments" value="true"/>
        </plugin>
    </plugins>

三、定义mapper,并在接口中定义页号和页大小（参数通常不能改）

<select id="selectCountry2" resultType="cn.edu.tju.domain.Country" >
        select  * from country
    </select>

List<Country> selectCountry2(@Param("pageNum")int pageNum, @Param("pageSize")int pageSize);

四、调用时传入页号和页大小：

package cn.edu.tju.test;

import cn.edu.tju.domain.Country;
import cn.edu.tju.mapper.PersonMapper;
import com.github.pagehelper.PageHelper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.util.List;

public class MyBatisTest10 {
    public static void main(String[] args) throws IOException {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(

                Resources.getResourceAsStream("mybatis-config.xml"));


        SqlSession sqlSession = sqlSessionFactory.openSession();
        List<Country> countries = sqlSession.getMapper(PersonMapper.class).selectCountry2(1, 2);
        System.out.println(countries.size());
        System.out.println(countries);
    }
}