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/

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐