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.創(chuàng)建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.創(chuàng)建MyBatis 配置類
增加自定義配置：如果表的字段名有下劃線格式的，轉(zhuǎn)為駝峰命名格式
@org.springframework.context.annotation.Configurationpublic class MyBatisConfig { @Bean public ConfigurationCustomizer configurationCustomizer() { return new ConfigurationCustomizer() { @Override public void customize(Configuration configuration) { // 如果表的字段名有下劃線格式的，轉(zhuǎn)為駝峰命名格式 configuration.setMapUnderscoreToCamelCase(true); } }; }}
6.創(chuàng)建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.根據(jù)id查詢某個(gè)部門") @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.根據(jù)id刪除部門") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "需要?jiǎng)h除的部門id") }) @PostMapping("/dept/delete") public int deleteDepartment(@RequestParam Long id) { return departmentMapper.deleteDepartment(id); } @ApiOperation(value = "5.根據(jù)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); }}
重慶分公司
重慶分公司
