pom添加mybatis依赖和mysql依赖
<!-- mysql驱动依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<!-- spring boot mybatis依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
application.properties添加数据源和mybatis的配置
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=199616
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis.type-aliases-package=com.li.entity
mybatis.mapper-locations=classpath:mappers/*.xml
mybatis.type-aliases-package指向实体包的路径
mybatis.mapper-locations为mapper xml文件地址
Application应用启动类:
@SpringBootApplication
@MapperScan("com.li.mapper")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
@MapperScan注解扫描mapper接口
项目的目录结构如下:
spring boot mybatis依赖一开始使用1.2.0版本时
会报下面这个错误
Caused by: java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
换成
1.3.0
就可以了