MyBatisPlus中删除方法deletetById、deleteBatchIds、deleteByMap的使用

﹏ヽ暗。殇╰゛Y 2023-10-18 17:30 12阅读 0赞

## 场景 ##

项目搭建专栏：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/column/info/37194][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]

基础搭建：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89407994][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]

## 实现 ##

### deleteById ###

/***
      * 通用删除操作  通过ID删除
      */
     @Test
     public void testCommomDeleteById() {
      int result=employeeMapper.deleteById(8);
      System.out.println("*******************"+result);
     }

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

### deleteByMap ###

/***
      * 通用删除操作 deleteByMap  map要写列名条件 不能是实体属性名
      */
     @Test
     public void testCommomDeleteByMap() {
      Map<String, Object> columnMap = new HashMap<String, Object>();
      columnMap.put("name", "更新测试成功");
      columnMap.put("gender", "1");
      int result=employeeMapper.deleteByMap(columnMap);
      System.out.println("*******************"+result);
      
     }

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

### deleteBatchIds ###

/***
      * 通用查询操作 deleteBatchIds 通过多个ID进行删除
      */
     @Test
     public void testCommomDeleteBatchIds() {
      List<Integer> idList = new ArrayList<Integer>();
      idList.add(5);
      idList.add(6);
      int result=employeeMapper.deleteBatchIds(idList);
      System.out.println("*******************"+result);
      
     }

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

###     ###

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11133892][https_download.csdn.net_download_badao_liumang_qizhi_11133892]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_column_info_37194]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/column/info/37194
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89407994]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89407994
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190422200331733.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190422200352591.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190422200411161.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[https_download.csdn.net_download_badao_liumang_qizhi_11133892]: https://download.csdn.net/download/badao_liumang_qizhi/11133892