Oracle+MyBatis实现批量添加的写法
<!--批量添加-->
Dao写法:Integer insertBatchUser(List<User> list);
写法一:
<insert id="insertBatchUser" parameterType="java.util.List" useGeneratedKeys="false">
INSERT INTO USER_TABLE (ID, USERNAME, PASSWORD, PHONE, IDCARD,ADDRESS)
<foreach collection="list" item="item" index="index" separator="union all">
( select
#{item.id,jdbcType=VARCHAR},
#{item.userName,jdbcType=VARCHAR},
#{item.password,jdbcType=VARCHAR},
#{item.phone,jdbcType=VARCHAR},
#{item.idCard,jdbcType=VARCHAR},
#{item.address,jdbcType=VARCHAR}
from DUAL
)
</foreach>
</insert>
写法二:
<insert id="insertBatchUser" parameterType="