Day10-10.案例-员工管理-删除员工
1.删除员工-需求:
EmpController:
1.接受路径参数id数组
2.调用Service进行批量删除
3.响应
@DeleteMapping
@PathVariable
EmpService:
1.调用Mapper接口进行批量删除操作
EmpMapper:
1.delete from emp where id in (?, ?, ?)
使用标签来遍历集合
EmpController:
@DeleteMapping("/emps/{ids}")
public Result delete(@PathVariable List<Integer> ids){
log.info("批量删除操作:ids:{}", ids);
empService.delete(ids);
return Result.success();
}
EmpService:
public interface EmpService{
/*实现批量删除操作*/
void delete(List<Integer> ids);
}
EmpServiceImpl:
@Service
public class EmpServiceImpl implements EmpService {
@Autowired
private EmpMapper empMapper;
/*批量删除*/
@Override
public void delete(List<Integer> ids) {
empMapper.delete(ids);
}
}
EmpMapper:
@Mapper
public interface EmpMapper {
/*批量删除*/
void delete(List<Integer> ids);
}
XML文件:
批量删除员工
<delete id="delete">
delete from emp where id in
<foreach collection="ids" item="id" separator="," open="(" close=")">
#{id}
</foreach>
</delete>