场景:传入参数,id数组 String[] userIds,进行逻辑删除,将对应记录的is_delete字段设置为1
<!--根据id批量逻辑删除 -->
<update id="logicDeleteCDlmUserByIds" parameterType="String">
update c_dlm_user
<trim prefix="set" suffixOverrides=",">
<trim prefix="is_delete=case" suffix="end,">
<foreach collection="array" item="userId">
when user_id=#{userId} then 1
</foreach>
</trim>
</trim>
where user_id in
<foreach item="userId" collection="array" open="(" separator="," close=")">
#{userId}
</foreach>
</update>
<!--根据id批量删除 -->
<delete id&#