目录：

（1）部门管理：查询-添加-删除

（2）部门管理：修改

（1）部门管理：查询-添加-删除

在DepartmentController中添加方法：

这里getAllDeps方法上篇已写 

//获取所有部门请求，并跳转到部门页面@RequestMapping("/departments")public String departments(Model model){model.addAttribute("deps",departmentService.getAllDeps());return "departments";}

 删除固定的内容：

 给添加部门form表单添加action：

在DepartmetntController中提那家这个接口：

/*** 增加部门** @param departmentname 部门名称* @return 重定向到获取所有部门的页面*/@PostMapping("/addDepartments")public String addDepartments(String departmentname,Model model){Department depByName = departmentService.getDepByName(departmentname);//根据名字查询部门if (depByName != null){model.addAttribute("error","部门名字重复");}else {departmentService.addDepartments(departmentname);model.addAttribute("error","部门添加成功！！");}return "redirect:/admin/departments";}

 在DepartmentService：添加这个方法：

 //根据名字查询部门public Department getDepByName(String departmentname) {return departmentMapper.getDepByName(departmentname);}

 //增加部门public Integer addDepartments(String departmentname) {return departmentMapper.addDepartments(departmentname);}

 在添加这个方法：

 DepartmentMapper：添加最后两个方法

//根据名字查询部门Department getDepByName(String departmentname);

 //增加部门Integer addDepartments(String departmentname);

DepartmentMapper.xml写两个sql语句：

 select *from departmentwhere departmentname = #{departmentName}

insert into department(departmentname)values (#{departmentName})

给删除按钮添加：删除请求

 在DepartmentController添加删除请求：

 /*** 根据id删除部门** @param departmentid 部门编号* @return Integer*/@RequestMapping("/deletedep")public String deletedep(Integer departmentid){departmentService.deletedepById(departmentid);return "redirect:/admin/departments";}

 在DepartmentService添加删除方法：

 //根据id删除部门public Integer deletedepById(Integer departmentid) {return departmentMapper.deletedepById(departmentid);}

 在DepartmentMapper添加：

//根据id删除部门Integer deletedepById(Integer departmentid);

 DepartmentMapper.xml添加sql语句：

 deletefrom departmentwhere departmentid = #{departmentId}

点击222删除 

 （2）部门管理：修改

修改部门页面：添加id onclick

${dep.departmentId}${dep.departmentName}编辑取消删除

添加js：

更新请求：在DepartmentControlle添加更新请求

/*** 更新部门** @param id   部门编号* @param name 部门名称* @return success或者error给前端ajax*/@RequestMapping("/updatedep")@ResponseBodypublic String updatedep(Integer id,String name){Integer result = departmentService.updatedep(id,name);if (result == 1){return "success";}return "error";}

在DepartmentService添加方法：

 //更新部门public Integer updatedep(Integer id, String name) {return departmentMapper.updatedep(id,name);}

 在DepartmentMapper添加更新方法：

//更新部门Integer updatedep(@Param("id") Integer id,@Param("name") String name);

DepartmentMapper.xml添加sql语句：

 update departmentset departmentname = #{name}where departmentid = #{id}