mybatis 嵌套插叙的方式

qq_33451502

于 2022-02-15 17:50:56 发布

阅读量440

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA 文章标签：蓝桥杯 linq p2p

本文链接：https://blog.youkuaiyun.com/qq_33451502/article/details/122949633

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>