mybatis plus合并两个wrapper

最新推荐文章于 2024-07-23 18:05:23 发布

廖泽松

最新推荐文章于 2024-07-23 18:05:23 发布

阅读量4.4k

点赞数

分类专栏： java mybatis plus

本文链接：https://blog.csdn.net/weixin_35928208/article/details/118805946

版权

java 同时被 2 个专栏收录

9 篇文章 1 订阅

订阅专栏

mybatis plus

1 篇文章 0 订阅

订阅专栏

该博客详细介绍了如何在MyBatisPlus中使用QueryWrapper进行复杂查询，包括联合查询、自定义SQL片段以及参数合并等操作。通过示例代码展示了如何查询未生成基准报警的基准缺陷，涉及数据表连接、条件构造等核心概念。

摘要由CSDN通过智能技术生成

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.guotie.mdc.base.po.datumdefect.DatumDefectPO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author liaoz
 */
@Mapper
public interface DatumDefectDao extends BaseMapper<DatumDefectPO> {
    /**
     * 查询未生成基准报警的基准缺陷
     *
     * @param frameTable 关联表 可能是 data_alarm_frame_w data_alarm_frame_g data_alarm_frame_s
     */
    @Select("SELECT d.* FROM e01d d LEFT JOIN ( " +
            "SELECT f.datum_defect_id FROM ${frameTable} f LEFT JOIN ${alarmTable} a ON f.alarm_id = a.id ${ew.customSqlSegment} " +
            ") as fa ON fa.datum_defect_id = d.f01 ${sql}")
    List<DatumDefectPO> selectUnMark(@Param("frameTable") String frameTable, @Param("alarmTable") String alarmTable, @Param(Constants.WRAPPER) QueryWrapper<?> dataWrapper, @Param("sql") String sql);
}

        QueryWrapper<DatumDefectPO> wrapper = new QueryWrapper<>();
        rangeFrameWrapper(wrapper, query);
        rangeAlarmWrapper(wrapper, query);

        QueryWrapper<DatumDefectPO> dWrapper = new QueryWrapper<>();
        rangeUnMarkWrapper(dWrapper, query);
        dWrapper.isNull(FA_HEAD + "datum_defect_id");

        //warn: 此处骚操作   作用为将两个wrapper合并
        String dSql = StrUtil.replace(dWrapper.getCustomSqlSegment(), "ew.paramNameValuePairs.", "ew.paramNameValuePairs._");
        Map<String, Object> map = wrapper.getParamNameValuePairs();
        dWrapper.getParamNameValuePairs().forEach((key, value) -> map.put("_" + key, value));

        String domainStr = "w";
        List<DatumDefectPO> pos = datumDefectDao.selectUnMark("data_alarm_frame_" + domainStr, "data_alarm_" + domainStr, wrapper, dSql);