<!-- 批量保存教师信息S_TEACHER_INFO -->
<insert id="saveTeacherList" parameterType="teacherBean">
INSERT INTO S_TEACHER_INFO
(id,uuid,createDate,password,sex,name,type,age,phone,codeId,auditStatus)
SELECT S_QUESTIONNAIRE_USER_INFO_SEQ.NEXTVAL,a.* FROM(
<foreach collection="list" item="teacher" index="index" separator="union all">
SELECT
#{teacher.uuid},SYSDATE,#{teacher.password},#{teacher.sex},#{teacher.name},#{teacher.type}
,#{teacher.age},#{teacher.phone},#{teacher.codeId},'1' FROM DUAL
</foreach>
) a
</insert>
<insert id="saveTeacherList" parameterType="teacherBean">
INSERT INTO S_TEACHER_INFO
(id,uuid,createDate,password,sex,name,type,age,phone,codeId,auditStatus)
SELECT S_QUESTIONNAIRE_USER_INFO_SEQ.NEXTVAL,a.* FROM(
<foreach collection="list" item="teacher" index="index" separator="union all">
SELECT
#{teacher.uuid},SYSDATE,#{teacher.password},#{teacher.sex},#{teacher.name},#{teacher.type}
,#{teacher.age},#{teacher.phone},#{teacher.codeId},'1' FROM DUAL
</foreach>
) a
</insert>
463
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
