使用SpringBoot+MybatisPlus做了一个单个删除DOM，请问批量怎么删除呢

Question

ContentCatService//删除     public void delete(Integer id);public class ContentCatServiceImpl implements ContentCatService{//删除     public void delete(Integer id){         List<Integer> idList = new ArrayList<>();         idList.add(id);         contentCatMapper.deleteBatchIds(idList);     }public class ContentCatController { //删除     private SysResult delete(@PathVariable Integer id){         try {             contentCatService.delete(id);             return SysResult.ok();         }catch (Exception e){             e.printStackTrace();             return SysResult.build(201,"删除失败");         }请问如果改为批量删除呢

Answer 1

批量删除你要传一个list
通过mybatis 的动态sql 拼接

<delete id="batchDelete" parameterType="java.util.List">
    delete from tm_user where user_id in (
    values
    <foreach collection="instances" item="item" index="index" separator=",">
        #{item.userId}
    </foreach>
    )
</delete>

批量新增差不多
<insert id="batchInsert" parameterType="java.util.List">
    insert into tm_e_coupon_instance(e_coupon_id,batch_no)
    values
    <foreach collection="instances" item="item" index="index" separator=",">
        (#{item.eCouponId},#{item.batchNo})
    </foreach>

</insert>