Mybatis操作ORACLE和mysql批量插入数据

oracle批量插入[jdbcType类型应与数据库一致]

INSERT INTO STUDENT(ID,NAME,AGE,SEX)
SELECT t.* FROM(
	<foreach collection="list" index="index" item="item" separator="UNION ALL">
  			select
  				#{item.id,jdbcType=DECIMAL} ID,#{item.name,jdbcType=VARCHAR} NAME,
  				#{item.age,jdbcType=VARCHAR} AGE,#{item.sex,jdbcType=VARCHAR} SEX
  			from dual
  </foreach>
)

mysql批量插入

INSERT INTO STUDENT(ID,NAME,AGE,SEX)
VALUES
	<foreach collection="list" index="index" item="item" separator=",">
  			(
					#{item.id,jdbcType=DECIMAL} ID,#{item.name,jdbcType=VARCHAR} NAME,
  				#{item.age,jdbcType=VARCHAR} AGE,#{item.sex,jdbcType=VARCHAR} SEX
			)
  </foreach>