Mybatis的XML文件中Oracle数据库批量插入数据
Mybatis的XML文件中Oracle数据库批量插入数据(需要:自动生成主键的时候)
<sql id="base_column_sql">
id,name,password
</sql>
<insert id="addList" parameterType="java.util.List" useGeneratedKeys="false">
<selectKey resultType="long" keyProperty="id" order="BEFORE">
SELECT seq_userinfo.NEXTVAL FROM DUAL
</selectKey>
insert into userinfo
(<include refid="base_column_sql" />)
select seq_userinfo.NEXTVAL,A.* from(
<foreach collection="list" item="item" index="index" separator="UNION ALL">
SELECT
#{item.name,jdbcType=VARCHAR},
#{item.password,jdbcType=VARCHAR}
FROM dual
</foreach>
)A
</insert>