Mybatis 动态sql语句动态传入表名和条件参数

最新推荐文章于 2023-08-31 14:46:52 发布

wjm0519

最新推荐文章于 2023-08-31 14:46:52 发布

阅读量1.9k

点赞数

分类专栏： Mybatis 文章标签： sql 数据库

本文链接：https://blog.csdn.net/wjm0519/article/details/123065868

版权

Mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

出现的错误

插入的参数

// 组装查询条件
        HePage<AbnormalDataVo> hePage = new HePage<AbnormalDataVo>(dto.getPage(), dto.getLimit());
        hePage.getParamsMap().put("end", IotUtils.getTimeString(end));
        hePage.getParamsMap().put("mn", dto.getMn());
        hePage.getParamsMap().put("start", IotUtils.getTimeString(start));
        hePage.getParamsMap().put("tableName",
                ""+user.getUnitCode()+"_"+
                        CommonUtils.stringToLocalDateTime(dto.getEnd()).getYear()+"_"+
                        dto.getMn()+"_lot_ehs_data");
        HePage<AbnormalDataVo> getAbnormalData = enIotProMapper.getAbnormalDataList(hePage);

xml sql语句

 <select id="getAbnormalDataList"
            resultType="com.cqhhh.facade.enterprise.eniot.iotpro.pojo.vo.AbnormalDataVo">
        SELECT
        a.id,
        a.DateTime as dataTime,
        a.Avg,
        a.Flag as status,
        b.name as pollutant
        FROM
        #{paramsMap.tableName} as a
        LEFT JOIN sys_label_poll_factor b ON a.pollution_num = b.`code`
        WHERE
        a.status = 1
        AND a.DateTime >= #{paramsMap.start}
        AND a.DateTime &lt;= #{paramsMap.end}
        ORDER BY a.DateTime DESC
    </select>

错误原因是由于表名属于固定因数的用$表示而非条件的#表示

<select id="getAbnormalDataList"
            resultType="com.cqhhh.facade.enterprise.eniot.iotpro.pojo.vo.AbnormalDataVo">
        SELECT
        a.id,
        a.DateTime as dataTime,
        a.Avg,
        a.Flag as status,
        b.name as pollutant
        FROM
        ${paramsMap.tableName} as a
        LEFT JOIN sys_label_poll_factor b ON a.pollution_num = b.`code`
        WHERE
        a.status = 1
        AND a.DateTime >= #{paramsMap.start}
        AND a.DateTime &lt;= #{paramsMap.end}
        ORDER BY a.DateTime DESC
    </select>

最后结果