mybatis动态循环拼接SQL，动态拼接字段和动态拼接 LEFT JOIN

RyFit

于 2024-02-04 10:54:20 发布

阅读量694

点赞数 6

分类专栏： SQL记录文章标签： mybatis sql java

本文链接：https://blog.csdn.net/qq_45619439/article/details/136022079

版权

SQL记录专栏收录该内容

4 篇文章 0 订阅

订阅专栏

mybatis动态循环拼接SQL，动态拼接字段和动态拼接 LEFT JOIN

 select T.BUSINESS_KEY_ "businessKey",
        D.JHBM "jhbm",
        D.JHBM || DO.DOC_NAME AS "designDoc",
        T.PROC_INST_ID_ "lcId",
        TO_CHAR( T.END_TIME_, 'yyyy-MM-dd hh24:mi:ss') "cjsj"
        <foreach collection="mapList" item="join">
            ,decode(${join.tablename}.f_count, '', '未结构化', '已结构化') as "${join.tablename}",
            (SELECT TABLECHINESE FROM DOC_STRUCTURED_QUERY_CONFIG WHERE TABLENAME = '${join.tablename}')
            "${join.tablename}MC"
        </foreach>
        FROM ACT_HI_PROCINST T
        <foreach collection="mapList" item="join" separator="">
            LEFT JOIN (select lcid, count(1) as f_count
            from ${join.tablename}
            group by lcid) ${join.tablename} ON T.PROC_INST_ID_ = ${join.tablename}.LCID
        </foreach>
        LEFT JOIN V_DJJCXX D
        ON D.JHDM = T.BUSINESS_KEY_
        LEFT JOIN DOC_FLOW_INSTANCE_INFO DI
        ON DI.PROCESS_INSTANCE_ID = T.PROC_INST_ID_
        LEFT JOIN DOC_INFO DO
        ON DO.DOC_KEY = DI.DOC_KEY
        <where>
            D.JHBM IS NOT NULL
            <if test="jhbm != null and jhbm != ''">
                AND D.JHBM LIKE '%' || #{jhbm} || '%'
            </if>
        </where>
        ORDER BY T.END_TIME_