第6节：SpringBoot整合Mybatis

# 1.SpringBoot整合MyBatis

①依赖的导入

<!-- MySQL驱动依赖 -->
<dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
 <version>5.1.40</version>
</dependency>
<!-- MyBatis整合包依赖 -->
<dependency>
 <groupId>org.mybatis.spring.boot</groupId>
 <artifactId>mybatis-spring-boot-starter</artifactId>
 <version>1.3.2</version>
</dependency>
<!-- Druid数据源整合包依赖 -->
<dependency>
 <groupId>com.alibaba</groupId>
 <artifactId>druid-spring-boot-starter</artifactId>
 <version>1.1.10</version>
</dependency>

②Java文件结构的准备

实体类：

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Job implements Serializable {
 private static final long serialVersionUID = 2388129295668997933L;
 private Integer jobId;
 private String jobTitle;
 private Double minSalary;
 private Double maxSalary;
}

Mapper接口：

@Repository
public interface JobMapper {
 List<Job> queryAllJob();
}

Mapper映射文件：

<?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="com.qf.springbootmybatis.mapper.JobMapper">
 <select id="queryAllJob" resultType="job">
 select * from Job
 </select>
</mapper>

③SpringBoot整合MyBatis

1.修改启动类，自动扫描所有Mapper接口：

@SpringBootApplication
@MapperScan(basePackages = "com.qf.testspringboot.mapper") 
public class TestSpringBootApplication {
 public static void main(String[] args) {
 SpringApplication.run(TestSpringBootApplication.class, args);
 }
}

2.配置文件整合Druid数据源：

spring:
 datasource:
 driver-class-name: com.mysql.jdbc.Driver
 url: jdbc:mysql://localhost:3306/company
 username: root
 password: root
 type: com.alibaba.druid.pool.DruidDataSource

3.配置文件整合Mybatis：

mybatis:
 mapper-locations: classpath:mapper/*.xml
 type-aliases-package: com.qf.testspringboot.pojo
 configuration:
 map-underscore-to-camel-case: true
 lazy-loading-enabled: true