<update id="delete" parameterType="hashMap">
<selectKey keyProperty='id' resultType='java.lang.Long' order='BEFORE'>
SELECT
(select id FROM sys_user WHERE
name = #{name})id
from DUAL
</selectKey>
UPDATE sys_user SET
Enable=2
WHERE
name = #{name}
</update>
原文请看:https://blog.csdn.net/u012373815/article/details/73864866