1、拿到所有的主键,封装成List集合,进行1000条删除一次,小于1000条则跳出循环进行删除
for (ImportCustomerInfoDO m : memberList) {
// 删除外部客户会员
ids.add(m.getId());
if(ids.size()>1000){
n = importCustomerInfoRepository.deleteByIds(ids);
ids.clear();
}
}
if(ids.size()!=0){
n = importCustomerInfoRepository.deleteByIds(ids);
}
2、Mapper代码如下
<delete id="deleteByIds" parameterType="java.util.List">
delete from IMPORT_CUSTOMER_INFO
<where>
<foreach collection="list" item="id" index="index" open="(" close=")" separator="or">
id=#{id}
</foreach>
</where>
</delete>