oracle 批量更新

来源:互联网 发布:淘宝提示清洗怎么办 编辑:程序博客网 时间:2024/06/07 09:02
<update id="checkPreJobPlan" parameterType="java.util.List" databaseId="oracle">    BEGIN    <foreach collection="eduCourse.courseMembers" item="member" separator=";">        update numas_employee_train_record        set audit_status = #{member.auditStatus} where course_id = #{eduCourse.id} and employee_id = (select id from numas_employee_archive where        code = #{member.code})    </foreach>    ;end;</update>
0 0
原创粉丝点击