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>