oracel
------------------------------------------insert-------------------------------
<insert id="saveShop1Mess" useGeneratedKeys="false" parameterType="java.util.List">
insert into sfa_shop1(test,testo,testt,testth)
select SEQ_SFASHOP1.NEXTVAL,test.* from (
<foreach collection="list" item="item" separator="UNION ALL" >
select
#{item.testo,jdbcType=VARCHAR},
#{item.testt,jdbcType=VARCHAR},
#{item.testth,jdbcType=VARCHAR}
from dual
</foreach>
) test
</insert>
//注意useGeneratedKeys="false",oracle不支持自增长列,insert的时候有主键,所以该属性设置为false。
------------------------------------------update-------------------------------
<update id="updateSfaShop1" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update sfa_shop1
set
testo=#{item.testo,jdbcType=VARCHAR},
testt=#{item.testt,jdbcType=VARCHAR},
testth=#{item.testth,jdbcType=VARCHAR}
where test = #{item.test,jdbcType=NUMERIC}
</foreach>
</update>
------------------------------------------delete-------------------------------
<delete id="deleteSaf1" parameterType="java.util.List">
delete from sfa_shop1 where test in
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item.test,jdbcType=NUMERIC}
</foreach>
</delete>
------------------------------------------insert-------------------------------
<insert id="saveShop1Mess" useGeneratedKeys="false" parameterType="java.util.List">
insert into sfa_shop1(test,testo,testt,testth)
select SEQ_SFASHOP1.NEXTVAL,test.* from (
<foreach collection="list" item="item" separator="UNION ALL" >
select
#{item.testo,jdbcType=VARCHAR},
#{item.testt,jdbcType=VARCHAR},
#{item.testth,jdbcType=VARCHAR}
from dual
</foreach>
) test
</insert>
//注意useGeneratedKeys="false",oracle不支持自增长列,insert的时候有主键,所以该属性设置为false。
------------------------------------------update-------------------------------
<update id="updateSfaShop1" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update sfa_shop1
set
testo=#{item.testo,jdbcType=VARCHAR},
testt=#{item.testt,jdbcType=VARCHAR},
testth=#{item.testth,jdbcType=VARCHAR}
where test = #{item.test,jdbcType=NUMERIC}
</foreach>
</update>
------------------------------------------delete-------------------------------
<delete id="deleteSaf1" parameterType="java.util.List">
delete from sfa_shop1 where test in
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item.test,jdbcType=NUMERIC}
</foreach>
</delete>