springboot+mybatis-plus实战使用

项目需要需要组合查询数据数据表，其中需要订单的日期范围。使用mybatis-plus就是香

MPJLambdaWrapper<WithdrawDto> wrapper=new MPJLambdaWrapper<WithdrawDto>()
                .selectAll(WithdrawDto.class)
                .orderByDesc(WithdrawDto::getCreateTime);
        if(StrUtil.isNotEmpty(memberId)){
            wrapper.eq(WithdrawDto::getMemberId,memberId);
        }
        if(StrUtil.isNotEmpty(groupId)){
            wrapper.eq(WithdrawDto::getGroupId,groupId);
        }
        if(StrUtil.isNotEmpty(roleType)){
            wrapper.eq(WithdrawDto::getRoleType,roleType);
        }
        if(StrUtil.isNotEmpty(status)){
            wrapper.eq(WithdrawDto::getMoneyStatus,status);
        }
        if(StrUtil.isNotEmpty(startTime)&&StrUtil.isNotEmpty(endTime)){
            wrapper.gt(WithdrawDto::getCreateTime, LocalDateTime.parse(startTime, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
            wrapper.lt(WithdrawDto::getCreateTime, LocalDateTime.parse(endTime, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));

        }
        if(StrUtil.isNotEmpty(accountBookNo)){
            wrapper.eq(WithdrawDto::getYpAccountBookNo,accountBookNo);
        }
        Page<WithdrawDto> listPage=memberWithdrawMapper.selectJoinPage(new Page<>(page, 10), WithdrawDto.class, wrapper);

欢迎点赞收藏转发