引入pom.xml文件
<!-- alibaba 连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
修改配置文件:
#端口设置
server:
port: 9999
#mybatis连接设置
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
url: jdbc:mysql://127.0.0.1:3306/ehuoyuan?useUnicode=true&characterEncoding=utf8
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
maxActive: 20 #最大活跃度
initialSize: 1 #初始化数量
maxWait: 60000 #超时配置
poolPreparedStatements: true #打开PSCache
maxPoolPreparedStatementPerConnectionSize: 20 #制定每个PSCache 大小
validation-query: select 1
validationQueryTimeout: 5
testWhileIdle: true
#mybatis 配置文件映射
mybatis:
mapper-locations: classpath*:mapper/**/*.xml
添加读取配置文件类:
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.alibaba.druid.pool.DruidDataSource;
@Configuration
public class DruidConfiguration {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DruidDataSource druid() {
return new DruidDataSource();
}
}
运行验证: