SpringBoot的Mybatis注解版数据库操作

<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>

@MapperScan(value  = "com.zch.springboot_mybatis.Mapper"

package com.zch.springboot_mybatis.Mapper;
import com.zch.springboot_mybatis.bean.Department;
import org.apache.ibatis.annotations.*;
//@Mapper
public interface DepaertmentMapper {
// mybatis的注解版
@Select("select * from department where id=#{id}")
public Department getDdeptByid(Integer id);
@Delete("delete from department where id=#{id}")
public int deleteDeptByid(Integer id);
@Options(useGeneratedKeys = true ,keyProperty = "id")
@Insert("insert into department(departmentName) values(#{departmentName})")
public int insertDept(Department department);
@Update("update department set departmentName=#department where id={#id}")
public int updateDept(Department depaertment);
}

package com.zch.springboot_mybatis.Controller;
 
import com.zch.springboot_mybatis.Mapper.DepaertmentMapper;
import com.zch.springboot_mybatis.bean.Department;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;
 
@RestController
public class DeptController {
@Autowired
DepaertmentMapper depaertmentMapper;
private Department deleteDepartment;
Department department=new Department();
 
//select实现
@GetMapping("/dept/{id}")
public Department getDepartment(@PathVariable("id") Integer id){
return depaertmentMapper.getDdeptByid(id);
}
//delete实现
@GetMapping("/dept/delete/{id}")
public Department deleteDepartment(@PathVariable("id") Integer id){
depaertmentMapper.deleteDeptByid(id);
return deleteDepartment;
}
//insert实现
@GetMapping("/dept")
public Department insertDept(Department department){
depaertmentMapper.insertDept(department);
return department;
}
//update实现（失败）
@GetMapping("/dept/update")
public Department updateDepartment(@PathVariable("id") Department id ,@PathVariable("departmentName" )Department departmentname){
depaertmentMapper.updateDept(department);
return deleteDepartment;
}
}