package com.jackson0714.springboot.entity; public class Department { private Long id; private String departmentName; public void setId(Long id) { this.id = id; } public Long getId() { return id; } public void setDepartmentName(String departmentName) { this.departmentName = departmentName; } public String getDepartmentName() { return departmentName; }}
4.创建Mapper映射类，并将SQL注解到方法上
增删改查，你要的都在这里：
@Mapperpublic interface DepartmentMapper { @Select("select * from department") List> getAllDepartment(); @Select("select * from department where id=#{id}") Department getDepartmentById(Long id); @Delete("delete from department where id=#{id}") int deleteDepartment(Long id); @Insert("insert into department(department_name) values(#{departmentName})") int createDepartment(String departmentName); @Update("update department set department_name=#{departmentName} where id=#{id}") int updateDepartmentById(Long id, String departmentName);}
5.创建MyBatis 配置类
增加自定义配置：如果表的字段名有下划线格式的，转为驼峰命名格式
@org.springframework.context.annotation.Configurationpublic class MyBatisConfig { @Bean public ConfigurationCustomizer configurationCustomizer() { return new ConfigurationCustomizer() { @Override public void customize(Configuration configuration) { // 如果表的字段名有下划线格式的，转为驼峰命名格式 configuration.setMapUnderscoreToCamelCase(true); } }; }}
6.创建DepartmentController
@Api(value = "DepartmentController", description = "部门controller")@RequestMapping("/v1/client")@RestControllerpublic class DepartmentController { @Autowired DepartmentMapper departmentMapper; @ApiOperation(value = "1.查询所有部门") @GetMapping("/dept/getAllDepartment") public List> getAllDepartment() { return departmentMapper.getAllDepartment(); } @ApiOperation(value = "2.根据id查询某个部门") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "需要查询的部门id") }) @GetMapping("/dept/{id}") public Department getDepartmentById(@PathVariable Long id) { return departmentMapper.getDepartmentById(id); } @ApiOperation(value = "3.新增部门") @ApiImplicitParams({ @ApiImplicitParam(name = "name", value = "部门名称") }) @PostMapping("/dept/create") public int createDepartment(@RequestParam String name) { return departmentMapper.createDepartment(name); } @ApiOperation(value = "4.根据id删除部门") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "需要删除的部门id") }) @PostMapping("/dept/delete") public int deleteDepartment(@RequestParam Long id) { return departmentMapper.deleteDepartment(id); } @ApiOperation(value = "5.根据id更新部门名称") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "需要更新的部门id"), @ApiImplicitParam(name = "name", value = "需要更新的部门名称") }) @PostMapping("/dept/update") public int updateDepartmentById(@RequestParam Long id, @RequestParam String name) { return departmentMapper.updateDepartmentById(id, name); }}
