MyBatis-扩展-PageHelpler分页插件使用

pagehelper-5.0.0-rc.jar

jsqlparser-0.9.5.jar

<!--

    plugins在配置文件中的位置必须符合要求，否则会报错，顺序如下:

    properties?, settings?,

    typeAliases?, typeHandlers?,

    objectFactory?,objectWrapperFactory?,

    plugins?,

    environments?, databaseIdProvider?, mappers?

-->

<plugins>

<!-- com.github.pagehelper为PageHelper类所在包名 -->

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

        <!-- 使用下面的方式配置参数，后面会有所有的参数介绍 -->

        <property name="param1" value="value1"/>

</plugin>

</plugins>

public void getEmps() throws Exception{

SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();

SqlSession openSession = sqlSessionFactory.openSession(true);

try {

EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);

Page<Object> page = PageHelper.startPage(1, 5);

List<Employee> emps = mapper.getEmps();

//传入要连续显示多少页

PageInfo<Employee> info = new PageInfo<>(emps, 5);

for (Employee employee : emps) {

System.out.println(employee);

}

/*

System.out.println("当前页码："+page.getPageNum());

System.out.println("总记录数："+page.getTotal());

System.out.println("每页的记录数："+page.getPageSize());

System.out.println("总页码："+page.getPages());

*/

//xxx

System.out.println("当前页码："+info.getPageNum());

System.out.println("总记录数："+info.getTotal());

System.out.println("每页的记录数："+info.getPageSize());

System.out.println("总页码："+info.getPages());

System.out.println("是否第一页："+info.isIsFirstPage());

System.out.println("连续显示的页码：");

int[] nums = info.getNavigatepageNums();

for (int i = 0; i < nums.length; i++)   {

System.out.println(nums[i]);

}

} finally {

// TODO: handle finally clause

openSession.close();

}

}