SpringBoot整合Mybatis

• 首先引入mybatis-springboot整合坐标

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

• 在application.yaml配置文件中配置数据源以及mybatis配置

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///company
    username: root
    password: qqzj121466
mybatis:
  config-location: classpath:com/mybatis/mybatis-config.xml #主配置文件
  mapper-locations: classpath:com/mybatis/mapper/*.xml #映射文件配置
  configuration: #可以用该配置项来代替上面的主配置文件，两者只能存在一个

• 编写哦Mapper接口：

@Mapper
public interface DeptMapper{
	//用注解代替映射文件
    @Select("select * from dept where deptno=#{deptno}")
    @Results(@Result(column = "loc",property = "loca")) //ResultMap配置
    public Department getDepartment(int deptno);
}

• 自动注入该接口对象后，直接调用对应方法执行SQL语句：

//Controller
  @Autowired
    DeptService deptService;
    @GetMapping("dept")
    public Department getDept(@RequestParam("id") int deptno){
        Department department = deptService.getDepartment(deptno);
        System.out.println(department);
        return department;
    }