SpringBoot整合Mybatis:
1.pom文件中依赖:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
2.pom文件的build中添加:
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
3.全局配置文件(application.properties)中添加:
serverTimezone=GMT%2B8
#数据库配置
spring.datasource.url=jdbc:mysql://lcoalhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 设置mapper映射文件
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
# 设置mybatis配置文件
mybatis.config-location=classpath:mybatis/mybatis-config.xml
# 设置开启mybatis驼峰命名方式
# mybatis.configuration.map-underscore-to-camel-case=true
4.启动类中添加注解扫描bean:
@MapperScan("com.xxx.xxx.dao")
5.创建mapper.xml文件后即可通过Mybatis接口绑定的方式访问数据库。