我这边插入时的id是用的序列,每次插入时需要获取序列的下一个值来作为id 序列创建方法
create sequence your_sequence
minvalue 1
maxvalue 99999999999999999999
start with 1
increment by 1
cycle;
mybatis中的插入xml应该这样写
<insert id="insertXXXX" parameterType="java.util.List">
insert into your_tablename(id,name,value)
select your_sequence.nextval, a.* from(
<foreach collection="list" item="item" index="index" separator="union all">
select #{item.name},#{item.value} from dual
</foreach>) a
</insert>