Mybatis根据id批量的逻辑删除（更新单个字段）

场景：传入参数，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&#