配置datasource
package com.ahli.filesystem.config;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import lombok.Data;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import javax.sql.DataSource;
@Configuration
@Data
public class DruidConfig {
@Primary
@Bean(name = "dataSource")
public DataSource druidDataSource() {
return DruidDataSourceBuilder.create().build();
}
}
配置yml,不用配置wallfilter的config,不生效
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
druid:
username: root
password: password
url: jdbc:mysql://127.0.0.1:3306/filesystem?useSSL=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
initial-size: 20
min-idle: 5
max-active: 20
max-wait: 60000
aop-patterns: "com.springboot.template.dao.*"
filters: wall,stat
web-stat-filter:
enabled: true
url-pattern: /*
session-stat-enable: true
session-stat-max-count: 1000
stat-view-servlet:
enabled: true
url-pattern: /druid/*
login-username: root
login-password: 123456
filter:
stat:
enabled: true
db-type: mysql
log-slow-sql: true
slow-sql-millis: 2000
wall:
enabled: true
main方法,SpringApplication.run(SystemApplication.class, args)前设置系统参数,这里举例selectLimit
System.setProperty("druid.wall.selectLimit", String.valueOf(100));
暂时这么用吧,希望有人能说一下哪里配置导致不生效