spring boot +Thymeleaf+mybatis 集成通用PageHelper，做分页

controller：

/**
* 分页查询用户
* @param request
* @param response
* @return
* @throws Exception
*/
@RequestMapping(value="/queryList",method=RequestMethod.GET)
public String query(HttpServletRequest request,
HttpServletResponse response,
@RequestParam(defaultValue = "1") Integer pageNum,
@RequestParam(defaultValue = "5") Integer pageSize) throws Exception{
PageHelper.startPage(pageNum, pageSize);
List<SecUser> list =service.queryByList();
PageInfo<SecUser> pageInfo = new PageInfo<SecUser>(list);

//获得当前页
request.setAttribute("pageNum", pageInfo.getPageNum());
//获得一页显示的条数
request.setAttribute("pageSize", pageInfo.getPageSize());
//是否是第一页
request.setAttribute("isFirstPage", pageInfo.isIsFirstPage());
//获得总页数
request.setAttribute("totalPages", pageInfo.getPages());
//是否是最后一页
request.setAttribute("isLastPage", pageInfo.isIsLastPage());
//所有导航页号
request.setAttribute("naviPageNums", pageInfo.getNavigatepageNums());

request.setAttribute("list", list);
return "user/list";
}

service：

public List<SecUser> queryByList(){
return dao.queryByList();
}

dao：

public List<SecUser> queryByList();

mapper：

<select id="queryByList" resultMap="userMap" >
select
id,
<include refid="requiredColumn" />
from
userbase
where
1=1
</select>

页面：