文章目录
前后端分离CRUD和工具-svn
1 后端crud接口完整实现(掌握)
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-LwyrmunD-1575815951668)(C:\Users\Administrator\AppData\Roaming\Typora\typora-user-images\1575814890512.png)]
@Controller
@RequestMapping("/department")
@CrossOrigin
public class DepartmentController {
@Autowired
private IDepartmentService departmentService;
//查询所有
@RequestMapping(value ="/list",method = RequestMethod.PATCH)
@ResponseBody
public List<Department> list(){
return departmentService.findAll();
}
//查询一条数据
@RequestMapping(value ="/{id}",method = RequestMethod.GET)
@ResponseBody
public Department findOne( @PathVariable long id){
System.out.println("查询的id"+id);
return departmentService.findOne(id);
}
//添加 数据
@RequestMapping(method = RequestMethod.PUT)
@ResponseBody
public AjaxResult save(@RequestBody Department department) {
departmentService.save(department);
return new AjaxResult();
}
//修改数据
@RequestMapping(method = RequestMethod.POST)
@ResponseBody
public AjaxResult update(@RequestBody Department department) {
departmentService.update(department);
return new AjaxResult();
}
//删除 数据
@RequestMapping(value = "/{id}",method = RequestMethod.DELETE)
@ResponseBody
public AjaxResult delete(@PathVariable long id) {
System.out.println("删除的"+id);
departmentService.delete(id);
return new AjaxResult();
}
1.2 mapper.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="cn.itsource.crm.mapper.DepartmentMapper">
<select id="findAll" resultType="Department">
select * from department
</select>
<select id=