springboot编写批量删除

springboot编写批量删除

1.创建数据库

create table student
(
    id       int auto_increment
        primary key,
    name     varchar(12)   null,
    classes  varchar(12)   null,
    score    int           null,
    isdelete int default 1 null
); 

2.编写studentmapper.xml文件

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.springboot.centersystem.dao.StudentMapper"> <resultMap id="BaseResultMap" type="com.springboot.centersystem.entity.Student" > <id column="id" property="id" jdbcType="INTEGER" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="classes" property="classes" jdbcType="VARCHAR" /> <result column="score" property="score" jdbcType="INTEGER" /> <result column="isdelete" property="isdelete" jdbcType="INTEGER"/> </resultMap> <delete id="deleteid" parameterType="com.springboot.centersystem.entity.Student"> delete from student
            where id=#{id} </delete> </mapper> 

3.编写实体类

import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.util.Date; @Data @NoArgsConstructor @AllArgsConstructor public class Student { private Integer id; private String name; // 班级 private String classes; private Integer score; } 

4.编写studentmapper

import com.springboot.centersystem.entity.Student; import org.apache.ibatis.annotations.Mapper; import java.util.List; @Mapper public interface StudentMapper { int deleteid(int id); } 

5.编写student.service

import com.springboot.centersystem.entity.Student; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.util.List; public interface StudentService { int deleteid(int id); } 

6.编写service实现类

@Service public class StudentServiceImpl implements StudentService { @Resource StudentMapper studentMapper; public int deleteid(int id){ return studentMapper.deleteid(id); } } 

7.编写controller

@RestController @RequestMapping("/poi") public class StudentController { @Autowired private StudentService studentService; @DeleteMapping("deleteid") @ResponseBody public String deleteid(@RequestBody int arr[]) { for (int a : arr) { studentService.deleteid(a); } //[5,6] return "删除成功"; } } 

8.测试

首先看到数据库两条数据

接着打开postman进行测试

查看数据库数据已经删除了

本文地址：https://blog.csdn.net/weixin_44389577/article/details/108037589