<insert id="saveManyPopInfo" parameterType="java.util.List">
insert into popinfo (popid,popname,remark)
select seq_popid.nextval,p.* from (
<foreach collection="list" item="pop" separator="union all">
select #{pop.popname},#{pop.remark} from dual
</foreach>
) p
</insert>
该代码可以实现批量新增的问题,但是我希望用的是union all的方法,即:
<insert id="saveManyPopInfo" parameterType="java.util.List">
<!--这里的selectKey 感觉只是执行了一次,因为会报一个叫插入重复的错误-->
<selectKey keyProperty="p1" order="BEFORE" resultType="int">
select seq_popid.nextval from dual
</selectKey>
insert into popinfo (popid,popname,remark)
<foreach collection="list" item="pop" separator="union all">
select #{p1},#{pop.popname},#{pop.remark} from dual
</foreach>
</insert>
怎么可以用union all来解决批量新增的问题?