1. 环境准备
1.1 创建项目
创建一个新的项目(选中web、jdbc、mysql和mybatis环境)
项目新增的mybatis依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
查看依赖树
1.2 整合mybatis步骤
-
配置数据源相关属性(详细见上一学习笔记Druid)
-
加入依赖
<!--引入druid数据源--> <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.8</version> </dependency>
如果后面启动有报log4j的错误,就加上log4j的依赖
<!-- https://mvnrepository.com/artifact/log4j/log4j --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency>
-
配置yml
spring: datasource: # 数据源基本配置 username: root password: root driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC type: com.alibaba.druid.pool.DruidDataSource # 追加配置,使得这两个sql文件能顺利执行 schema: - classpath:sql/department.sql - classpath:sql/employee.sql initialization-mode: always #springboot2.x以上需要加这一句配置,不然无法执行sql和建表 # 数据源其他
-