spring:
datasource:
name: druidDataSource
type: com.alibaba.druid.pool.DruidDataSource
druid:
driver-class-name: com.mysql.jdbc.Driver
url: ...
username: ...
password: ...
filters: stat,wall,log4j,config
filter:
#配置StatFilter (SQL监控配置)
stat:
enabled: true #开启 SQL 监控
slow-sql-millis: 1000 #慢查询
log-slow-sql: true #记录慢查询 SQL
#配置WallFilter (防火墙配置)
wall:
enabled: true #开启防火墙
config:
update-allow: true #允许更新操作
drop-table-allow: false #禁止删表操作
insert-allow: true #允许插入操作
delete-allow: true #删除数据操作
log4j:
enabled: true #开启日志
result-set-log-enabled: false
result-set-log-error-enabled: true
# result-set-open-after-log-enabled: false
# result-set-close-after-log-enabled: false
statement-log-enabled: true
statement-log-error-enabled: true
statement-parameter-set-log-enabled: true
# statement-create-after-log-enabled: false
# statement-close-after-log-enabled: false
# statement-prepare-after-log-enabled: true
# statement-prepare-call-after-log-enabled: true
# statement-executable-sql-log-enable: true
# statement-execute-after-log-enabled: true
# statement-execute-query-after-log-enabled: true
# statement-execute-update-after-log-enabled: true
public static void main(String[] args) {
System.setProperty("druid.log.rs","false");
System.setProperty("druid.log.stmt","true");
SpringApplication.run(MyApplication.class, args);
}
这篇文字介绍了druid的配置方式:
https://www.mianshigee.com/note/detail/223642sqd/