本次使用的数据源为Druid,引入相关依赖,在build.gradle中的dependencies里编写
implementation 'org.mybatis:mybatis:3.5.9'
implementation 'com.alibaba:druid:1.2.8'
implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.2.1'
implementation 'mysql:mysql-connector-java:8.0.28'
在application.yml文件中编写如下配置:
spring:
mxzero:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/ssmblog
username: root
password: mysqladmin
mybatis:
config-location: classpath:META-INF/mybatis/mybatis-config.xml
type-aliases-package: top.mxzero.po
mapper-locations: classpath:META-INF/mybatis/mapper/**/*.xml
创建一个配置类:
@Configuration
public class DruidConfig {
@Bean
public DataSource dataSource(
@Value("${spring.mxzero.datasource.driver-class-name}")
String driverClassName,
@Value("${spring.mxzero.datasource.url}")
String url,
@Value("${spring.mxzero.datasource.username}")
String username,
@Value("${spring.mxzero.datasource.password}")
String password
){
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driverClassName);
druidDataSource.setUrl(url);
druidDataSource.setUsername(username);
druidDataSource.setPassword(password);
return druidDataSource;
}
}
在resource目录下创建META-INF子目录,再在META-INF下创建mybatis子目录,目录结构在application.yml中配置相对应
在resource/META-INF/mybatis下创建mybatis配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>