使用MybatisPlus进行分页

1.controller层

 /**
     * 分页查询所有数据
     *
     * @param page     分页对象
     * @param pageSize 分页大小
     * @return 所有数据
     */
    @GetMapping("/page")
    public R<Page> page(int page,int pageSize,String title) {
        //分页构造器
        Page<TArticle> pageInfo = new Page<>(page,pageSize);
        //条件构造器
        LambdaQueryWrapper<TArticle> queryWrapper = new LambdaQueryWrapper<>();
        //进行分页查询.page是mybatisplus自带的
        pageInfo = tArticleService.page(pageInfo,queryWrapper);
        return success(pageInfo);
}

2.Dao层（MPJBaseMapper是连表查）

Dao:public interface ZyOwnerParkDao extends MPJBaseMapper<ZyOwnerPark>

3.Service层

Result getOwnerParkList(OwnerParkListDto ownerParkListDto, Page page);

4.ServiceImpl

/**
 * 得到车位信息
 *
 * @param ownerParkListDto 车位审核列表
 * @param page             分页
 * @return {@link Result}
 */
@Override
public Result getOwnerParkList(OwnerParkListDto ownerParkListDto, Page page) {
    Result result = new Result();
    MPJLambdaWrapper<ZyOwnerPark> zyOwnerParkMPJLambdaWrapper = new MPJLambdaWrapper<>();
    zyOwnerParkMPJLambdaWrapper.selectAll(ZyOwner.class)
            .select(ZyCommunity::getCommunityName)
            .select(ZyPark::getParkCode)
            .select(ZyOwnerPark::getCreateTime)
            .select(ZyOwnerPark::getOwnerParkId)
            .select(ZyPark::getParkType)
            .select(ZyPark::getParkId)
            .select(ZyOwner::getOwnerNickname)
            .select(ZyOwner::getOwnerRealName)
            .select(ZyOwner::getOwnerGender)
            .select(ZyOwner::getOwnerAge)
            .select(ZyOwner::getOwnerIdCard)
            .leftJoin(ZyPark.class,ZyPark::getParkId,ZyOwnerPark::getParkId)
            .leftJoin(ZyCommunity.class,ZyCommunity::getCommunityId,ZyPark::getCommunityId)
            .leftJoin(ZyOwner.class,ZyOwner::getOwnerId,ZyOwnerPark::getOwnerId)
            .like(StringUtil.isNotEmpty(ownerParkListDto.getOwnerNickname()),ZyOwner::getOwnerNickname,ownerParkListDto.getOwnerNickname())
            .like(StringUtil.isNotEmpty(ownerParkListDto.getOwnerRealName()),ZyOwner::getOwnerRealName,ownerParkListDto.getOwnerRealName())
            .like(StringUtil.isNotEmpty(ownerParkListDto.getOwnerIdCard()),ZyOwner::getOwnerIdCard,ownerParkListDto.getOwnerIdCard())
            .like(StringUtil.isNotEmpty(ownerParkListDto.getOwnerPhoneNumber()),ZyOwner::getOwnerPhoneNumber,ownerParkListDto.getOwnerPhoneNumber())
            .eq(StringUtil.isNotEmpty(ownerParkListDto.getCommunityId()),ZyCommunity::getCommunityId,ownerParkListDto.getCommunityId())
            .eq(ZyOwnerPark::getParkOwnerStatus,"Binding");
    IPage<OwnerParkListDto> ownerParkListDtoIPage = this.baseMapper.selectJoinPage(page, OwnerParkListDto.class, zyOwnerParkMPJLambdaWrapper);
    if (ownerParkListDtoIPage.getTotal()>=0)
    {
        result.setMeta(ResultTool.success(ResultCode.SUCCESS));
        result.setData(ownerParkListDtoIPage);
    }
    return result;
}

Controller:@GetMapping("/getOwnerParkList")
public Result getOwnerParkList(OwnerParkListDto ownerParkListDto, Page page ) {
    return zyOwnerParkService.getOwnerParkList(ownerParkListDto, page);
}