mybatis使用case when进行批量更新

/**
 * 更新员工表
 * @method: updateEmp
 * @param list
 * @return {@link }
 * @Author: zwx
 * @Date: 2021/3/11 19:53
 */
void updateEmp(@Param("list") List<String> list);

mapper.xml层

<update id="updateEmp" parameterType="java.util.List">
    UPDATE hr_emp_employee
        SET `on_job` = CASE
        WHEN `status` IN
        <foreach collection="list" index="index" item="id" open="(" separator="," close=")">
         #{id}
        </foreach> THEN 0
        ELSE 1
        END
        WHERE 1=1
</update>