Springboot + MySQL+ JPA Ⅲ delete方法详解

青旅半醒 2023-10-02 15:26 13阅读 0赞

#### **一、deleteById（通过id进行单条删除）** ####

Service层中添加deleteById方法（deleteById是三方件自带接口**不需要**再dao层中添加）

@Transactional
    public void deleteById(Integer id){
    	userDao.deleteById(id);
    }

control层

/**
     * 通过id进行删除数据
     * @param id
     */
    @GetMapping("/deleteById")
    public void deleteById(Integer id){
    	userService.deleteById(id);
    }

删除id为20的名单，测试成功！

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_8_color_FFFFFF_t_70_g_se_x_16][]

后台执行了两条sql，先进行select再进行delete

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

####  **二、deleteAllById（通过id进行批量删除）** ####

Service层中添加deleteAllById方法（deleteAllById是三方件自带接口**不需要**再dao层中添加）

@Transactional
    public void deleteAllById(Iterable ids){
    	userDao.deleteAllById(ids);
    }

control层

/**
     * 通过id进行批量删除
     * @param ids
     */
    @GetMapping("/deleteAllById")
    public void deleteAllById(Integer[] ids){
    	userService.deleteAllById(Arrays.asList(ids));
    }

删除id为18和19的名单，测试成功！

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_8_color_FFFFFF_t_70_g_se_x_16 1][]

后台执行了四条sql，逐条进行select然后进行delete![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 3][]

####  **三、deleteAllByIdInBatch（通过id进行批量删除）** ####

Service层中添加deleteAllByIdInBatch方法（deleteAllByIdInBatch是三方件自带接口**不需要**再dao层中添加）

@Transactional
    public void deleteAllByIdInBatch(Iterable ids){
    	userDao.deleteAllByIdInBatch(ids);
    }

control层

/**
     * 通过id进行批量删除
     * @param ids
     */
    @GetMapping("/deleteAllByIdInBatch")
    public void deleteAllByIdInBatch(Integer[] ids){
    	userService.deleteAllByIdInBatch(Arrays.asList(ids));
    }

删除id为14,17的名单，测试成功！

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_19_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_10_color_FFFFFF_t_70_g_se_x_16][]

后台只进行了一条sql，这个应该**比deleteAllById性能高**一点吧（还没有测试过）

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_16_color_FFFFFF_t_70_g_se_x_16][]

#### **四、deleteAllInBatch（删除所有数据）** ####

Service层中添加deleteAllInBatch方法（deleteAllInBatch是三方件自带接口**不需要**再dao层中添加）

@Transactional
    public void deleteAllInBatch(){
    	userDao.deleteAllInBatch();
    }

control层

/**
     * 删除所有数据
     */
    @GetMapping("/deleteAllInBatch")
    public void deleteAllInBatch(){
    	userService.deleteAllInBatch();
    }

测试成功！

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_17_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_11_color_FFFFFF_t_70_g_se_x_16][]

后台只有一行sql

![013380a601fd4196b0ed77bfecf121c7.png][]

#### **五、deleteAll（删除所有数据）** ####

Service层中添加deleteAll方法（deleteAll是三方件自带接口**不需要**再dao层中添加）

@Transactional
    public void deleteAll(){
    	userDao.deleteAll();
    }

control层

/**
     * 删除所有数据
     */
    @GetMapping("/deleteAll")
    public void deleteAll(){
    	userService.deleteAll();
    }

测试成功！

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_15_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_11_color_FFFFFF_t_70_g_se_x_16][]

后台执行了7个sql，**性能应该不如上一个deleteAllInBatch**

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/49e05e1a439b4c2dbf83e58478c8b8d1.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_8_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/ea8f4315320d445f938de93f62843303.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_8,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/5091b4587f0141af97f2d212f8d7061e.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/bea0b200bb004fd8a49abf1fe71d08f5.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_8_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/742c727b66094535b3e96dcb7fbb2f90.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_8,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/07c30c937c464554ba9b4075f2c48f80.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_19_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/258c49fe5fc7488d85c15c68bb194d2f.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_19,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_10_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/d42819177aee45d983bfb178f298052a.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_10,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_16_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/70b256adbe9d44f9b0b5af9d52e529d4.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_16,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_17_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/c4c8dfefa513496595aa51f9ad9a49f1.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_17,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_11_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/9109a35fd80a46dd8ecef89dac0b6104.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_11,color_FFFFFF,t_70,g_se,x_16
[013380a601fd4196b0ed77bfecf121c7.png]: https://img-blog.csdnimg.cn/013380a601fd4196b0ed77bfecf121c7.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_15_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/2537cc91c6a9457081759ad1d22f8a0d.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_15,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/22212599ff8e4ce183a4c41aa2c4d970.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16