时间:2021-07-01 10:21:17 帮助过:12人阅读
二、mybatis xml(传入集合参数,建议批量数量控制在3000以内)
- <span style="color: #0000ff;"><</span><span style="color: #800000;">insert </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="insertBatch"</span><span style="color: #ff0000;"> parameterType</span><span style="color: #0000ff;">="java.util.List"</span><span style="color: #0000ff;">></span><span style="color: #000000;">
- /**UserInfoMapper.insertBatch*/
- INSERT INTO u_info(
- id,
- info_no,
- name,
- birthday,
- age,
- create_date
- )
- SELECT
- S.*,
- SYSDATE
- FROM(
- </span><span style="color: #0000ff;"><</span><span style="color: #800000;">foreach </span><span style="color: #ff0000;">item</span><span style="color: #0000ff;">="bean"</span><span style="color: #ff0000;"> index</span><span style="color: #0000ff;">="index"</span><span style="color: #ff0000;"> collection</span><span style="color: #0000ff;">="list"</span><span style="color: #ff0000;"> separator</span><span style="color: #0000ff;">="UNION ALL"</span><span style="color: #0000ff;">></span><span style="color: #000000;">
- SELECT
- #{bean.id, jdbcType=DECIMAL},
- #{bean.infoNo, jdbcType=VARCHAR},
- #{bean.name, jdbcType=VARCHAR},
- #{bean.birthday, jdbcType=TIMESTAMP},
- #{bean.age, jdbcType=DECIMAL}
- FROM DUAL
- </span><span style="color: #0000ff;"></</span><span style="color: #800000;">foreach</span><span style="color: #0000ff;">></span><span style="color: #000000;">
- ) S
- </span><span style="color: #0000ff;"></</span><span style="color: #800000;">insert</span><span style="color: #0000ff;">></span>
mybatis oracle 批量新增
标签:分区 bat XML ESS sda tis arc local gre