mybatis 嵌套插叙的方式

最新推荐文章于 2023-08-23 21:07:07 发布

原创最新推荐文章于 2023-08-23 21:07:07 发布 · 457 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#蓝桥杯 #linq #p2p

JAVA 专栏收录该内容

7 篇文章

订阅专栏

<sql id="getLatestVersionId">
    SELECT id
    FROM config_project_version
    WHERE group_code = #{req.groupCode}
      AND project_id = #{req.projectId}
      AND table_name = 'config_module_space_rel'
    ORDER BY version DESC LIMIT 1
</sql>


select
<include refid="baseCol"/>
from config_module_space_rel
where 1=1
<choose>
    <when test="req.versionId != null and req.versionId != '' ">
        and version_id = #{req.versionId}
    </when>
    <otherwise>
        and version_id = (<include refid="getLatestVersionId" />)
    </otherwise>
</choose>