springBoot整合MySQL+MyBatis

MySql依赖

<!-- mysql -->
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- 注意jar版本问题 -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<scope>runtime</scope>
</dependency>

MySql配置项(非yml格式)

spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF8&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

MyBatis依赖

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

MyBatis配置项(非yml格式)

mybatis.type-aliases-package=com.skeqi.pojo
mybatis.mapperLocations=classpath:mappers/*.xml

启动类加注解(dao层的地址)

@MapperScan("com.skeqi.dao")

找到项目的 src/main/resources,在这个目录下创建mappers的文件夹，mapper文件就放在这下面；

如果不想放在这下面可以修改MyBatis 的配置项