myBatis分页插件pagehelper的使用

1.maven引入相关jar包

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

2.在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>
	<typeAliases>
		<package name="xin.dapengge.crud.beans"/>
	</typeAliases>
	<plugins>
		<plugin interceptor="com.github.pagehelper.PageInterceptor">
		</plugin>
	</plugins>
</configuration>

3.使用

@Controller
public class EmployeeController {
	
	@Autowired
	EmployeeService employeeService;
	
	@RequestMapping(value="/emps")
	public String getEmps(@RequestParam(value="pn",defaultValue="1")Integer pn,
			Model model) {
		//设定要查询的页码，和每一页的信息数量
		PageHelper.startPage(pn, 5);
		//下面紧跟的查询就是分页查询
		List<Employee> emps = employeeService.getAll();
		//把查询出的结果保存到PageInfo中
		PageInfo<Employee> pageInfo = new PageInfo<>(emps,5);
		model.addAttribute("pageInfo", pageInfo);
		return "list";
	}
}