<insert id="insertGroupImportDetail2" parameterType="java.util.List" useGeneratedKeys="false">
INSERT INTO T_SPECIAL_AREA_PACKAGE select seq_T_special_area_package.NEXTVAL,A.* from (
<foreach collection="list" item="item" index="index" separator="union all" >
select #{item.communityName,jdbcType=VARCHAR},
#{item.productName,jdbcType=VARCHAR},#{item.packageName,jdbcType=VARCHAR},
#{item.packageCost,jdbcType=INTEGER},#{item.createTime},#{item.operId,jdbcType=VARCHAR},
#{item.companyId,jdbcType=VARCHAR} from dual
</foreach> ) A
</insert>
INSERT INTO T_SPECIAL_AREA_PACKAGE select seq_T_special_area_package.NEXTVAL,A.* from (
<foreach collection="list" item="item" index="index" separator="union all" >
select #{item.communityName,jdbcType=VARCHAR},
#{item.productName,jdbcType=VARCHAR},#{item.packageName,jdbcType=VARCHAR},
#{item.packageCost,jdbcType=INTEGER},#{item.createTime},#{item.operId,jdbcType=VARCHAR},
#{item.companyId,jdbcType=VARCHAR} from dual
</foreach> ) A
</insert>
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
