mybatis中迭代List集合（List<Map>、List<User>）方式

1、mybatis中迭代List中存储Map内容

 <insert id="batchInsertIc89" parameterType="java.util.List">
		insert into IC89(AAZ343 ,
					  AAZ341 ,
					  AAB299 ,
					  AAB301 ,
					  AAA227 ,
					  AAA226 ,
					  AAE270,
					  AAE140 ,
					  AAE473 , 
					  AAE803 ,
					  AAC001 ,
					  AAC003 ,
					  AAC004 ,
					  AAC002 ,
					  AAE009 ,
					  AAC080 ,
					  AAC155 ,
					  AAC078,
					  AAE006,
					  AAE007,
					  AAE005,
					  AAE011,
					  AAE036,
					  AAE013,
					  
					  AAE241 ,
					  AAE158,
					  INTIME )
		<foreach collection="list" index="index" item="map" separator="union all">
			(select
		     #{map.aaz343,jdbcType=DOUBLE},
		     #{map.aaz341,jdbcType=DOUBLE},
			#{map.aab299,jdbcType=VARCHAR},
			#{map.aab301,jdbcType=VARCHAR},
			'',
			'',
			#{map.aae270,jdbcType=VARCHAR},
			#{map.aae140,jdbcType=VARCHAR},
			#{map.aae473,jdbcType=VARCHAR},
			#{map.aae803,jdbcType=VARCHAR},
			#{map.aac001,jdbcType=VARCHAR},
			#{map.aac003,jdbcType=VARCHAR},
			#{map.aac004,jdbcType=VARCHAR},
			#{map.aac002,jdbcType=VARCHAR},
			#{map.aae009,jdbcType=VARCHAR},
			#{map.aac080,jdbcType=VARCHAR},
			#{map.aac155,jdbcType=VARCHAR},
			#{map.aac078,jdbcType=VARCHAR},
			#{map.aae006,jdbcType=VARCHAR},
			#{map.aae007,jdbcType=VARCHAR},
			#{map.aae005,jdbcType=VARCHAR},
			#{map.aae011,jdbcType=VARCHAR},
			to_date(#{map.aae036,jdbcType=VARCHAR},'yyyyMMdd'),
			#{map.aae013,jdbcType=VARCHAR},
			#{map.aae140,jdbcType=VARCHAR},
			#{map.aae158,jdbcType=VARCHAR},
			sysdate
			from dual
			)
		</foreach>

2、mapper中迭代List集合中存储的实体

<insert id="batchInsertIc87" parameterType="java.util.List">
		insert into IC87(AAZ343 ,
		AAZ341 ,
		AAB301 ,
		AAB299 ,
		AAE408 ,
		AAE803 ,
		AAE140 ,
		AAE241 ,
		AAC003 ,
		AAC004 ,
		AAC002 ,
		AAC010 ,
		AAB300 ,
		AAE006 ,
		AAE007 ,
		AAE005 ,
		AAE011,
		AAE036 ,
		AAE013 ,
		AAE383,
		INTIME,
		AAE158 )

		<foreach collection="list" index="" item="ic87List" separator="union all">
			(select
			#{ic87List.aaz343,jdbcType=DOUBLE},
			#{ic87List.aaz341,jdbcType=DOUBLE},
			#{ic87List.aab301,jdbcType=VARCHAR},
			#{ic87List.aab299,jdbcType=VARCHAR},
			#{ic87List.aae408,jdbcType=VARCHAR},
			#{ic87List.aae803,jdbcType=VARCHAR},
			#{ic87List.aae140,jdbcType=VARCHAR},
			#{ic87List.aae241,jdbcType=VARCHAR},
			#{ic87List.aac003,jdbcType=VARCHAR},
			#{ic87List.aac004,jdbcType=VARCHAR},
			#{ic87List.aac002,jdbcType=VARCHAR},
			#{ic87List.aac010,jdbcType=VARCHAR},
			#{ic87List.aab300,jdbcType=VARCHAR},
			#{ic87List.aae006,jdbcType=VARCHAR},
			#{ic87List.aae007,jdbcType=VARCHAR},
			#{ic87List.aae005,jdbcType=VARCHAR},
			#{ic87List.aae011,jdbcType=VARCHAR},
			#{ic87List.aae036,jdbcType=DOUBLE},
			#{ic87List.aae013,jdbcType=VARCHAR},
			#{ic87List.aae383,jdbcType=DOUBLE},
			sysdate,
			#{ic87List.aae158,jdbcType=VARCHAR}
			from dual
			)
		</foreach>

	</insert>