mybatis批量插入xml
oracle使用
java代码:
public int batchInsertAlarmSmsSend(List<AlarmSmsSendEntity> smsSendList);
xml代码:
<insert id="batchInsertAlarmSmsSend">
insert into bus_sms (id,send_to,content,event_id,event_title,create_date)
<foreach collection="list" item="item" index="index" separator=" UNION ALL " >
SELECT
#{item.id},#{item.sendTo},#{item.content},#{item.eventId},#{item.eventTitle},#{item.createDate}
FROM DUAL
</foreach>
</insert>
mysql使用
xml代码:
insert into t_train_record (add_time,emp_id,activity_id,flag)
values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.addTime},#{item.empId},#{item.activityId},#{item.flag})
</foreach>
mysql使用