ibates批量删除和添加

<delete id="Import_Terminal_deleteBatchTerminal" parameterClass="java.util.List">
delete from EOC_GW_IMPORT_TERMINAL
where DEVICE_ID in
<iterate conjunction="," open="(" close=")">
#imeiList[]#
</iterate>

</delete>

 

批量删除

 

 

<insert id="Terminal_DELETE_batchInsert" parameterClass="java.util.List">
insert into EOC_GW_IMPORT_TERMINAL_DELETE
(IMPORT_TERMINAL_ID,
APP_KEY,
CREATE_DATE,
UPDATE_DATE,
BUSINESS_ID,
APP_KEY_TYPE,
DEVICE_ID,
IMEI,
REGISTER_TIME,
PROGRAMME_PROVIDER_ID,
BATCH,
DEVICE_MOBILE,
RECORD_USER,
RECORD_DATE) values
<iterate conjunction=",">
(#list[].importTerminalId#,
#list[].appKey#,
#list[].createDate#,
#list[].updateDate#,
#list[].businessId#,
#list[].appKeyType#,
#list[].deviceId#,
#list[].imei#,
#list[].registerTime#,
#list[].programmeProviderId#,
#list[].batch#,
#list[].deviceMobile#,
#list[].recordUser#,
#list[].recordDate#)
   </iterate>
  </insert>

 

批量添加