首頁猿問使用SpringBoot+Myba...

使用SpringBoot+MybatisPlus做了一個單個刪除DOM，請問批量怎么刪除呢

Java

慕標(biāo)琳琳 2019-04-18 14:15:53

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,"刪除失敗"); }請問如果改為批量刪除呢

查看完整描述

3 回答

慕容708150

TA貢獻1831條經(jīng)驗獲得超4個贊

批量刪除你要傳一個list
通過mybatis 的動態(tài)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>

反對回復(fù) 2019-05-16