oracle mybatis 批量新增带序列 爱被打了一巴掌 2022-12-05 12:09 157阅读 0赞 <insert id="insertTbSpecialABatch" parameterType="java.util.List" useGeneratedKeys="false"> insert into DZHMONITOR.tb_special_a(aid, is_delete, sid, prodoct_code, prodoct_sort, prodoct_type, new_issue, income_range, prodoct_label, jump_url, btn_copy, create_time, update_time ) select DZHMONITOR.SEQ_SPECIAL_A.nextval,A.* from( <foreach collection="list" item="item" index="index" separator="UNION ALL"> SELECT #{item.is_delete} as is_delete,#{item.sid} as sid,#{item.prodoct_code} as prodoct_code,#{item.prodoct_sort} as prodoct_sort ,#{item.prodoct_type} as prodoct_type,#{item.new_issue} as new_issue,#{item.income_range} as income_range,#{item.prodoct_label} as prodoct_label,#{item.jump_url} as jump_url,#{item.btn_copy} as btn_copy,#{item.create_time} as create_time,#{item.update_time} as update_time FROM DUAL </foreach> ) A </insert>
还没有评论,来说两句吧...