mybatis oracle中 批量插入数据(不需要:自动生成主键的时候)
1,Mapper.xml
<insert id="addList" parameterType="java.util.List" useGeneratedKeys="false">
INSERT INTO userinfo
(
ID,
name,
password
)
<foreach item="item" index="index" collection="list" separator="union all">
(
SELECT
#{item.id},
#{item.name},
#{item.password}
FROM DUAL
)
</foreach>
</insert>
2,Mapper接口
void addList(List<Userinfo> list);
3,insert 结果: