Question

mybatis怎样批量插入数据到oracle，就算id自动增长问题

Answer 1

<insert id="addTrainRecordBatch" useGeneratedKeys="true" parameterType="java.util.List">
	<selectKey resultType="long" keyProperty="id" order="AFTER">
		SELECT
		LAST_INSERT_ID()
	</selectKey>
	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>
</insert>