当前位置:Gxlcms > 数据库问题 > mybatis oracle 批量新增

mybatis oracle 批量新增

时间:2021-07-01 10:21:17 帮助过:12人阅读

table u_info{ id NUMBER not null, info_no VARCHAR2(32) not null, name VARCHAR2(32) not null, birthday DATE, age NUMBER, create_date DATE not null } -- 自动按天数分区 -- tablespace TBS_DATA --partition by range (create_date) interval (numtodsinterval(1, ‘DAY‘)) --(partition P20190101 values less than (TO_DATE(‘2019-01-01 00:00:00‘, ‘SYYYY-MM-DD HH24:MI:SS‘, ‘NLS_CALENDAR=GREGORIAN‘))) ; --create unique index IU_INFO_NO_DATE on u_info (info_no,create_date) tablespace TBS_IDX online local; -- Add comments comment on table u_info is 用户信息表; comment on column u_info.id is 主键; comment on column u_info.info_no is 用户编号; comment on column u_info.name is 姓名; comment on column u_info.birthday is 生日; comment on column u_info.age is 年龄; comment on column u_info.create_date is 创建时间;

 

二、mybatis xml(传入集合参数,建议批量数量控制在3000以内)

  1. <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;">
  2. /**UserInfoMapper.insertBatch*/
  3. INSERT INTO u_info(
  4. id,
  5. info_no,
  6. name,
  7. birthday,
  8. age,
  9. create_date
  10. )
  11. SELECT
  12. S.*,
  13. SYSDATE
  14. FROM(
  15. </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;">
  16. SELECT
  17. #{bean.id, jdbcType=DECIMAL},
  18. #{bean.infoNo, jdbcType=VARCHAR},
  19. #{bean.name, jdbcType=VARCHAR},
  20. #{bean.birthday, jdbcType=TIMESTAMP},
  21. #{bean.age, jdbcType=DECIMAL}
  22. FROM DUAL
  23. </span><span style="color: #0000ff;"></</span><span style="color: #800000;">foreach</span><span style="color: #0000ff;">></span><span style="color: #000000;">
  24. ) S
  25. </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   

人气教程排行