1.在<select>标签中使用:
SELECT
su.user_id
FROM
sys_user su
<where>
<if test="roleCode != null">
su.user_id like concat('%', concat(#{ roleCode }, '%'))
</if>
</where>
2.在<insert>标签中使用:
INSERT INTO
hdp_cmcc_coa_role (
COA_ID,
ROLE_LEVEL,
ROLE_ID )
VALUES
(
#{ coaId } ,
#{ roleLevel },
<if test='roleLevel == "ROLE"'>
( SELECT role_id FROM sys_role_b WHERE ROLE_NAME = #{ roleName })
</if>
<if test='roleLevel == "USER"'>
( SELECT user_id FROM sys_user WHERE user_name = #{ roleName })
</if>
)
如果有多个if,可以使用choose替代:
<choose>
<when test='roleLevel == "USER"'>
( SELECT user_id FROM sys_user WHERE user_name = #{ roleName })
</when>
<otherwise>
( SELECT role_id FROM sys_role_b WHERE ROLE_NAME = #{ roleName })
</otherwise>
</choose>