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);}
}