db2带序列批量插入以及批量更新

db2带序列的批量插入,mybatis写法

<insert id="sdfsdf" parameterType="java.util.List">
	INSERT INTO TABLE_A(ID,NAME,AGE)
		SELECT SEQ_TABLE_A.nextval,A.* FROM(
			<foreach collection='list' item='item' separator='union'>
				SELECT
						#{name},
						#{age}
				FROM
						sysibm.sysdummy1		
			</foreach>
	)A
</insert>

db2批量更新,mybatis写法

<update id="sdfsdf" parameterType="java.util.List">
	UPDATE TABLE_A  SET AGE=
		<foreach collection='list' item='item' index='index' open='case ID' 
			separator=' ' close='end'>
			WHEN ${item.id} THEN
			${item.age}		
		</foreach>
		WHERE ID IN
		<foreach collection='list' item='item' index='index' open='('
			 separator=',' close=')'>
			${item.id} 		
		</foreach>
</update>