mybatis分页

1. 添加插件依赖

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

2.注入bean

@Bean
public PageHelper pageHelper(){
    PageHelper pageHelper = new PageHelper();
    Properties properties = new Properties();
    properties.setProperty("offsetAsPageNum","true");
    properties.setProperty("rowBoundsWithCount","true");
    properties.setProperty("reasonable","true");
    properties.setProperty("dialect","mysql");    
    pageHelper.setProperties(properties);
    return pageHelper;
}

3.EmpMapper.xml

<select id="selectByPage" resultMap="BaseResultMap">
  SELECT *
  FROM hw_emp
</select>

4.EmpMapper类

@Component
public interface EmpMapper {
    List<Emp> selectByPage();
}

5.测试

@RequestMapping(value = "getByPage", method = RequestMethod.GET)
public List<Emp> getEmp(@RequestParam(value = "currentPage") int currentPage, @RequestParam(value = "pageSize") int pageSize){
    PageHelper.startPage(currentPage,pageSize);
    List<Emp> empList = empMapper.selectByPage();
    return empList;
}

6.返回结果如下：
请求：http://localhost:8080/emp/getByPage?currentPage=3&pageSize=2
结果：
[{“id”:5,”empId”:”D00005”,”empName”:”emp_5”,”empWork”:”android”},{“id”:6,”empId”:”D00006”,”empName”:”emp_6”,”empWork”:”IOS”}]