MyBatis的分页插件介绍

<?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>
	<settings>
		<setting name="cacheEnabled" value="false" />
		<setting name="useGeneratedKeys" value="true" />
		<setting name="defaultExecutorType" value="REUSE" />
	</settings>
	<typeAliases>
		<package name="com.keweisoft.kdp.model" />
	</typeAliases>

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

在mybatis核心配置文件中配置PageHelper。

Mavel依赖如下：

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

使用步骤：

                Integer rows = Integer.valueOf(request.getParameter("rows")); //5 
		Integer page = Integer.valueOf(request.getParameter("page"));  //1
		PageHelper.startPage(page, rows); 
		
		Map<String, Object> result = new HashMap<String, Object>();
		List<OrganBuss> organBuss = organBussService.findAllOrganBuss();
		long total;
		
 
		
		PageInfo<OrganBuss> pageInfo = new PageInfo<OrganBuss>(organBuss);
		total = pageInfo.getTotal();  //总记录条数

慢慢体会去············································