使用mybatis-generator生成的Example,快速分页查询模板代码

controller接口

/**
 * 分页列表查询
 *
 * @param pageNum  页号
 * @param pageSize 页面大小
 * @param sortType 排序
 * @return BaseResult
 */
@GetMapping(value = "/getCustomerByPage")
public BaseResult getCustomerByPage(@RequestParam("pageNum") Integer pageNum, @RequestParam("pageSize") Integer pageSize, String sortType) {
	PageResult<Customer> pageResult = customerService.getCustomerByPage(pageNum, pageSize);
	return new BaseResult(200, "查询成功", pageResult.getData(), pageResult.getTotalCount());
}

serviceImpl实现

@Override
public PageResult<Customer> getCustomerByPage(Integer pageNum, Integer pageSize, String name) {
	CustomerExample example = new CustomerExample();
	example.setOrderByClause(" update_time desc");
	CustomerExample.Criteria criteria = example.createCriteria();

	// TODO 处理查询逻辑
	if (StringUtils.isNotEmpty(name)) {
		criteria.andNameLike("%" + name + "%");
	}
	//计算总数
	int totalCount = customerMapper.countByExample(example);
	if (pageSize != null && pageNum != null) {
		example.setLimitStart((pageNum - 1) * pageSize);
		example.setLimitEnd(pageSize);
	}
	//分页查询
	List<Customer> list = customerMapper.selectByExample(example);

	return new PageResult<>(totalCount, list);
}

PageResult

@Data
@NoArgsConstructor
@AllArgsConstructor
public class PageResult<T> {
    int totalCount;
    List<T> data;
}