删除员工DE

删除一个用户也是批量 删除的一种形式，所以写一种方法就够了

controller:

//方法一： /*@DeleteMapping public Result delete( Integer[] ids){ log.info("删除员工:{}", Arrays.toString(ids)); //empService.delete(ids); return Result.success(); }*/ //方法二： @DeleteMapping public Result delete(@RequestParam List<Integer> ids){ log.info("删除员工:{}", ids); empService.delete(ids); return Result.success(); }

Service:

@Transactional(rollbackFor = {Exception.class}) @Override public void delete(List<Integer> ids) { //1.删除员工信息 empMapper.deleteByIds(ids); //2.删除员工经历信息 empExprMapper.deleteByEmpIds(ids); }

EmpMapper:

/* * 根据id批量删除员工的信息 * */ void deleteByIds(List<Integer> ids);

EmpMapper.xml:

<!--批量删除员工的基本信息--> <delete id="deleteByIds"> delete from emp where id in <foreach item="id" collection="ids" separator="," open="(" close=")"> #{id} </foreach> </delete>

EmpExprMapper:

void deleteByEmpIds(List<Integer> empIds);

EmpExprMapper.xml:

<!--根据员工id批量删除员工经历--> <delete id="deleteByEmpIds"> delete from emp_expr where emp_id in <foreach collection="empIds" item="empId" separator="," open="(" close=")"> #{empId} </foreach> </delete>