mybatis/mybatisplus的一个搜索框对应多个属性

未-恙

已于 2023-06-07 15:07:49 修改

阅读量216

点赞数

文章标签： mybatis java sql

于 2023-06-07 15:04:55 首次发布

本文链接：https://blog.csdn.net/glf_CSDN/article/details/131088040

版权

1. mp方式的LambdaQueryWrapper

        IPage<SmsRecord> iPage = new Page<>(page, pageSize);
        LambdaQueryWrapper<SmsRecord> wrapper = new LambdaQueryWrapper<>();

        wrapper.and(new Consumer<LambdaQueryWrapper<SmsRecord>>() {
            @Override
            public void accept(LambdaQueryWrapper<SmsRecord> smsRecordLambdaQueryWrapper) {
                smsRecordLambdaQueryWrapper.like(StringUtils.isNotBlank(keyword), SmsRecord::getSmsTitle, keyword)
                        .or().like(StringUtils.isNotBlank(keyword), SmsRecord::getSmsContent, keyword)
                        .or().like(StringUtils.isNotBlank(keyword), SmsRecord::getPhone, keyword);
            }
        });

        //推送时间 处理日期格式
        if (sendTime == null) {
            sendTime = new Date();
        }
        Date startDate = DateUtil.getStartDate(sendTime);
        Date endDate = DateUtil.getEndDate(sendTime);
        wrapper.between(SmsRecord::getSendTime, startDate, endDate);

        wrapper.eq(storeFront != null, SmsRecord::getStoreFront, storeFront);

        wrapper.eq(status != null, SmsRecord::getStatus, status);

        //上面已经解决,没用到xml文件
//        List<SmsRecord> smsRecords = baseMapper.getSmsRecords(startDate, endDate, storeFront, status, keyword);
//        log.info("SmsRecords:{}", smsRecords);

        IPage<SmsRecord> smsRecordIPage = baseMapper.selectPage(iPage, wrapper);

2.xml配置文件方式

    <select id="getSmsRecords" resultType="com.muxu.cashier.transmission.sms.entity.SmsRecord">
        select id,store_front,phone,sms_title,sms_content,biz_id,send_time,status,cost from sms_record
        <where>
            <if test="keyword != null and keyword != ''">
                and (sms_title like concat('%',#{keyword},'%') or sms_content like concat('%',#{keyword},'%') or phone
                like concat('%',#{keyword},'%'))
            </if>
            <if test="startDate != null and endDate != null">
                and send_time between #{startDate} and #{endDate}
            </if>
            <if test="storeFront != null and storeFront != ''">
                and store_front = #{storeFront}
            </if>
            <if test="status != null">
                and status = #{status}
            </if>
        </where>
    </select>