mysql ibatis 批量插入_ibatis 批量插入逻辑

ibatis oracle 批量插入配置

insert into T_LAW_STATISTICS_CLASSIFY(ID,TEMPLATE,ALIAS,CONTENT,BACKUP1,BACKUP2)

SELECT SEQ_ID_COMMON.NEXTVAL , TEMPLATE,ALIAS,CONTENT,BACKUP1,BACKUP2 FROM (

SELECT #[].Template# as Template,#[].Alias# as Alias,#[].Content# as Content,#[].Backup1# as Backup1,#[].Backup2# as Backup2 from dual

)

解析后，oracle 批量插入语句，这里select再包多一层，是因为序列和 union all不能同时存在

insert into people(id, name)

SELECT seq_people.nextVal,C FROM (

select 'zhangsan' C  from dual

union all

SELECT 'lisi'C  from dual

union all

SELECT  'wangwu'C  from dual);

ibatis mysql 批量插入配置

INSERT INTO ()

VALUES

(

#[].D_MAC_ADDRESS#,

#[].D_MAC_PASSWORD#,

#[].D_MARK_CODE#,

#[].D_STATUS#

);

SELECT @@IDENTITY AS value;

同理mysql可以多个insert 同时执行，用 “;” 分号分开即可。