使用yaml的配置方式这里
druid官方github地址
https://github.com/alibaba/druid
分析自动配置
- 扩展配置项 spring.datasource.druid
- DruidSpringAopConfiguration.class, 监控SpringBean的;配置项:spring.datasource.druid.aop-patterns
- DruidStatViewServletConfiguration.class, 监控页的配置:spring.datasource.druid.stat-view-servlet;默认开启
- DruidWebStatFilterConfiguration.class, web监控配置;spring.datasource.druid.web-stat-filter;默认开启
- DruidFilterConfiguration.class}) 所有Druid自己filter的配置
导入依赖
<!-- druid的starter自动配置(包含了druid的jar)--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.17</version> </dependency> <!-- log4j--> <!-- https://mvnrepository.com/artifact/log4j/log4j --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency>
写配置
#配置数据源 spring: datasource: url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC username: root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver # druid配置 druid: aop-patterns: com.example.* # spring监控 filters: stat,wall,log4j # 底层开启功能,stat(sql监控),wall(防火墙) # 配置监控功能 stat-view-servlet: enabled: true #开启监控 login-username: admin #账号 login-password: 123456 #密码 # #配置web监控 web-stat-filter: enabled: true #开启 url-pattern: /* #所有路径 exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*' #不监控路径 # 对开启的参数修改 filter: stat: # 对上面filters里面的stat的详细配置 slow-sql-millis: 1000 #响应吵一秒为慢加载 logSlowSql: true enabled: true #开启sql监控 wall: enabled: true #开启防火墙 config: drop-table-allow: false #不允许修改表
即可