目录

• 准备工作
• • MySQL数据库表
  • Result返回结果
• 1、SpringBoot+MyBatisPlus+vue+ElementUl实现批量删除
• • 1.1、演示GIF动态图
  • 1.2、实体类
  • 1.3、Dao接口
  • 1.4、Service接口
  • 1.5、ServiceImpl接口实现层
  • 1.6、Controller控制层
  • 1.7、Vue前端
• 2、SpringBoot+MyBatis+vue+ElementUl实现批量删除
• • 2.1、演示GIF动态图
  • 2.2、实体类
  • 2.3、Dao接口
  • 2.4、写SQL的xml文件
  • 2.5、Service接口
  • 2.6、ServiceImpl接口实现层
  • 2.7、Controller控制层
  • 2.8、Vue前端

准备工作

• MySQL数据库表

CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,`pwd` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

• Result返回结果

package com.zhang.springboot.common;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
public class Result {private String code;private String msg;private T data;public static Result succeed(){return new Result(Constants.CODE_200,"成功",null);}public static Result succeed(Object data){return new Result(Constants.CODE_200,"成功",data);}public static Result succeed(String msg, Object data){return new Result(Constants.CODE_200,msg,data);}public static Result succeed(String code, String msg,Object data) {return new Result(Constants.CODE_200,msg,data);}public static Result error(String code, String msg,Object data){return new Result(code,msg,null);}public static Result error(String code, String msg) {return new Result(code,msg,msg);}
}

1、SpringBoot+MyBatisPlus+vue+ElementUl实现批量删除

1.1、演示GIF动态图

1.2、实体类

package com.zhang.springboot.entity;import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("user")
public class User {@TableId(value = "id", type = IdType.AUTO)private Integer id;private String name;private String pwd;
}

1.3、Dao接口

package com.zhang.springboot.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhang.springboot.entity.User;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper extends BaseMapper {}

1.4、Service接口

package com.zhang.springboot.service;import com.baomidou.mybatisplus.extension.service.IService;
import com.zhang.springboot.entity.User;
public interface UserService extends IService {}

1.5、ServiceImpl接口实现层

package com.zhang.springboot.service.impl;import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zhang.springboot.entity.User;
import com.zhang.springboot.mapper.UserMapper;
import com.zhang.springboot.service.UserService;
import org.springframework.stereotype.Service;@Service
public class UserServiceImpl extends ServiceImpl implements UserService {}

1.6、Controller控制层

package com.zhang.springboot.controller;import com.zhang.springboot.common.Constants;
import com.zhang.springboot.common.Result;
import com.zhang.springboot.entity.User;
import com.zhang.springboot.mapper.UserMapper;
import com.zhang.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;@RestController
@RequestMapping("/user")
public class UserController {@Autowiredprivate UserService userService;/**MyBatisPlus实现批量删除*/@PostMapping("/del")public boolean del(@RequestBody List ids){return userService.removeByIds(ids);}/**查出所有数据*/@PostMapping("/listUser")public Result listUser(){List listAll =  userService.list();return Result.succeed(Constants.CODE_200,"渲染成功",listAll);}
}

1.7、Vue前端

2、SpringBoot+MyBatis+vue+ElementUl实现批量删除

2.1、演示GIF动态图

2.2、实体类

package com.zhang.springboot.entity;import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("user")
public class User {
//    @TableId(type = IdType.ASSIGN_UUID)@TableId(value = "id", type = IdType.AUTO)private Integer id;private String name;private String pwd;
}

2.3、Dao接口

	package com.zhang.springboot.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhang.springboot.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;import java.util.List;@Mapper
public interface UserMapper{/**查询全部*/List listAll();/**批量删除*/int deleteByIds(@Param("flowIds") Integer[] flowIds);
}

2.4、写SQL的xml文件

delete from user where id in#{id}select * from user

2.5、Service接口

package com.zhang.springboot.service;import com.zhang.springboot.common.Result;
public interface UserService{Result listAll();//查询全部Result deleteByIds(Integer[] flowIds);//批量删除
}

2.6、ServiceImpl接口实现层

package com.zhang.springboot.service.impl;import com.zhang.springboot.common.Result;
import com.zhang.springboot.entity.User;
import com.zhang.springboot.mapper.UserMapper;
import com.zhang.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;@Service
public class UserServiceImpl implements UserService {@Autowiredprivate UserMapper userMapper;/**** 查询全部*/@Overridepublic Result listAll() {List listAll= userMapper.listAll();return Result.succeed(Constants.CODE_200,"查出全部成功",listAll);}/**** 批量删除*/public Result deleteByIds(Integer[] flowIds) {userMapper.deleteByIds(flowIds);return Result.succeed(Constants.CODE_200,"批量删除成功");}
}

2.7、Controller控制层

package com.zhang.springboot.controller;import com.zhang.springboot.common.Result;
import com.zhang.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;@RestController
@RequestMapping("/user")
public class UserController {@Autowiredprivate UserService userService;/**批量删除*/@GetMapping("/delEmps/{ids}")public Result delEmp(@PathVariable("ids") Integer[] ids){return userService.deleteByIds(ids);}/**查询全部*/@PostMapping("/listUser")public Result listUser(){return userService.listAll();}}

2.8、Vue前端