sql循环插入
oracle
<insert id ="saveSupervise" parameterType="java.util.List">
INSERT INTO MSP_USER_CUSTOMER_SUPERVISE
(USERID,
CUSTOMERNO,
MEMO,
ISDELETE,
CREATID,
CREATDATETIME,
UPDATEID,
UPDATEDATETIME)
SELECT A.*
FROM(
<foreach collection="list" item="form" index="index" separator="UNION ALL">
SELECT
#{form.userId,jdbcType=VARCHAR} USERID,
#{form.customerNo,jdbcType=VARCHAR} CUSTOMERNO,
#{form.memo,jdbcType=VARCHAR} MEMO,
0 ISDELETE,
#{form.creatorId,jdbcType=VARCHAR} CREATID,
SYSDATE CREATDATETIME,
#{form.updateId,jdbcType=VARCHAR} UPDATEID,
SYSDATE UPDATEDATETIME
FROM dual
</foreach>
)A
</insert >
mysql
<insert id ="saveStuCou" parameterType="java.util.List">
insert into student_course_management
(course_management_id,
student_curriculum_id,
student_data_id,
curriculum_type_id,
curriculum_manage_id,
teacher_data_id,
teaching_type,
campus_id,
is_delete,
creator_id,
creator_time,
update_id,
update_time)
values
<foreach collection ="list" item="form" index= "index" separator =",">
(
#{form.courseManagementId},
#{form.studentCurriculumId},
#{form.studentDataId},
#{form.curriculumTypeId},
#{form.curriculumManageId},
#{form.teacherDataId},
#{form.teachingType},
#{form.campusId},
0,
#{form.creatorId},
NOW(),
#{form.updateId},
NOW()
)
</foreach >
</insert >
版权声明:本文为weixin_39921836原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。