【mybatis-plus】分页实现

/**
 * 分页查询
 * @param gasTimedTask
 * @return
 */
IPage<GasTimedTask> findByPage(GasTimedTask gasTimedTask);

@Override
public IPage<GasTimedTask> findByPage(GasTimedTask gasTimedTask) {
	IPage<GasTimedTask> iPage = new Page<>(gasTimedTask.getCurrentPage(), gasTimedTask.getPageSize());
	QueryWrapper<GasTimedTask> qw = new QueryWrapper<GasTimedTask>();
	qw.orderByDesc("create_time");
	return this.page(iPage, qw);
}

/**
 * 分页查询
 * @param houseSpaceAssay
 * @return
 */
IPage<HouseSpaceAssay> findByPage(HouseSpaceAssay houseSpaceAssay);

@Override
public IPage<HouseSpaceAssay> findByPage(HouseSpaceAssay houseSpaceAssay) {
	Page<HouseSpaceAssay> page = new Page<>(houseSpaceAssay.getCurrentPage(), houseSpaceAssay.getPageSize(),houseSpaceAssayMapper.selectCount(new QueryWrapper<>()));
	List<HouseSpaceAssay> list = houseSpaceAssayMapper.findByPage(new PageAdapter(houseSpaceAssay.getCurrentPage() - 1, houseSpaceAssay.getPageSize()));
	page.setRecords(list);
	return page;
}

/**
 * 分页查询
 * @param pageAdapter
 * @return
 */
List<HouseSpaceAssay> findByPage(@Param("pageAdapter") PageAdapter pageAdapter);

<select id="findByPage" resultMap="BaseResultMap">
	select *
	from camera_region
	order by seq
	limit #{pageAdapter.begin},#{pageAdapter.size}
</select>