48.数据访问-druid数据源starter整合方式
1:导包。
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.17</version>
</dependency>
2:application.yaml编写配置
#配置数据库
spring:
datasource:
url: jdbc:mysql://localhost:3306/test
username: root
password: 010429
driver-class-name: com.mysql.cj.jdbc.Driver
druid:
aop-patterns: com.xiaoze.* #监控SpringBean
filters: stat,wall # 底层开启功能,stat(sql监控),wall(防火墙)
stat-view-servlet: # 配置监控页功能
enabled: true
login-username: admin
login-password: admin
resetEnable: false
web-stat-filter: # 监控web
enabled: true
urlPattern: /*
exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
filter:
stat: # 对上面filters里面的stat的详细配置
slow-sql-millis: 1000
logSlowSql: true
enabled: true
wall:
enabled: true
config:
drop-table-allow: false
3:在Test中测试(测试用的时lombok中的方法@Slf4j)
package com.xiaoze;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.lang.model.element.VariableElement;
import javax.sql.DataSource;
@Slf4j
@SpringBootTest
class DemoApplicationTests {
@Autowired
DataSource dataSource;
@Test
void contextLoads() {
log.info("数据源的类型是:"+dataSource.getClass());
}
}