mybatis批量插入oracle/db2

https://www.programmersought.com/article/29201075775/

适用于oracle:

<insert id="insertScoreByBatch" parameterType ="java.util.List" >
		INSERT INTO TABLE_NAME(
			
			ext_col,
			ext_col1,
			ext_col2,
			ext_col3,
			ext_col4
		) 
		(
		<foreach collection="list" item="evaScore" index="" separator="union all">
			select 
			
			#{evaScore.extCol},
			#{evaScore.extCol1},
			#{evaScore.extCol2},
			#{evaScore.extCol3},
			#{evaScore.extCol4}
		 from dual
		</foreach>
		)
	
	</insert>

如果是db2，则只需要将from dual改为from sysibm.sysdummy1就行了

<insert id="insertScoreByBatch" parameterType ="java.util.List" >
		INSERT INTO TABLE_NAME(
			
			ext_col,
			ext_col1,
			ext_col2,
			ext_col3,
			ext_col4
		) 
		(
		<foreach collection="list" item="evaScore" index="" separator="union all">
			select 
			
			#{evaScore.extCol},
			#{evaScore.extCol1},
			#{evaScore.extCol2},
			#{evaScore.extCol3},
			#{evaScore.extCol4}
		 from sysibm.sysdummy1
		</foreach>
		)
	
	</insert>