mybatis分页查询

数据id 0-100，以下mysql本地执行，从offset开始，获取limit条信息

取8条数据，从2开始，取id3、4、5...10
select * from service_data order by id asc limit 8 OFFSET 2

需要注意区分以逗号分隔的情况
# 从第10条数据开始，查询2条数据，查询结果为id 11、id 12
select * from service_data order by id asc limit 10,2

# 查询结果为id 21、id 22、id 23、id 24、id 25
select * from service_data order by id asc limit 20,5

分页查询

DO

   List<McDO> selectByPage(@Param("limit") Integer limit, @Param("offset") Integer offset);

mapper

  <select id="selectByPage"  resultMap="ResultMapWithBLOBs">
    select
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from service_data
    limit #{limit} offset #{offset}
  </select>

Controller

@RequestMapping("getAll")
@ResponseBody
public Object getPage(@RequestParam(name = "limit") Integer limit, @RequestParam(name = "page") Integer page) {
    Object obj = mapper.selectByPage(limit, (page-1)*limit);
    return LayUtil.layResonse(obj);
}