弱小和无知不是生存的障碍,傲慢才是
**

  1. spring:
  2. datasource:
  3. url: jdbc:mysql://127.0.0.1:3306/java58
  4. username: root
  5. password: admin
  6. driver-class-name: com.mysql.cj.jdbc.Driver
  7. type: com.alibaba.druid.pool.DruidDataSource
  8. # 数据源其他配置
  9. initialSize: 5
  10. minIdle: 5
  11. maxActive: 20
  12. maxWait: 60000
  13. timeBetweenEvictionRunsMillis: 60000
  14. minEvictableIdleTimeMillis: 300000
  15. validaionQuery: SELECT 1 FROM DUAL
  16. testWhileIdle: true
  17. testOnBorrow: false
  18. testOnReturn: false
  19. poolPreparedStatements: true
  20. # 配置监控统计拦截的filters 去掉后监控界面sql无法统计,‘wall’用于防火墙
  21. filters: stat,wall,log4j
  22. maxPoolPreparedStatementPerConnectionSize: 20
  23. useGlobalDataSourceStat: true
  24. connectionProperties: druid.stat.mergeSql=true,druid.stat.slowSqlMills=500
  25. server:
  26. port: 8080

从initialSize开始往后的在DataSourceProperties中并无属性,所以这些数据默认是不起作用的,

是加载不到druid数据源中

所以编写配置类

新版本似乎解决了(未验证)

  1. import com.alibaba.druid.pool.DruidDataSource;
  2. import com.alibaba.druid.support.http.StatViewServlet;
  3. import com.alibaba.druid.support.http.WebStatFilter;
  4. import org.springframework.boot.context.properties.ConfigurationProperties;
  5. import org.springframework.boot.web.servlet.FilterRegistrationBean;
  6. import org.springframework.boot.web.servlet.ServletRegistrationBean;
  7. import org.springframework.context.annotation.Bean;
  8. import org.springframework.context.annotation.Configuration;
  9. import java.util.HashMap;
  10. import java.util.Map;
  11. @Configuration
  12. public class DruidConfig {
  13. @Bean
  14. @ConfigurationProperties(prefix = "spring.datasource")
  15. public DataSource druid() {
  16. return new DruidDataSource();
  17. }
  18. //配置servlet filter
  19. @Bean
  20. public ServletRegistrationBean myServlet() {
  21. ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
  22. Map<String, String> initParams = new HashMap<>();
  23. initParams.put("loginUsername", "admin");
  24. initParams.put("loginPassword", "123456");
  25. initParams.put("allow", "");// 如果不写就是默认允许所有
  26. initParams.put("deny", "127.0.0.1");
  27. //是否能够重置数据.
  28. bean.addInitParameter("resetEnable", "false");
  29. bean.setInitParameters(initParams);
  30. return bean;
  31. }
  32. @Bean
  33. public FilterRegistrationBean myFilter() {
  34. FilterRegistrationBean bean = new FilterRegistrationBean();
  35. bean.setFilter(new WebStatFilter());
  36. Map<String, String> initParams = new HashMap<>();
  37. initParams.put("exclusions", "*.js,*.css,/druid/*");
  38. bean.setInitParameters(initParams);
  39. bean.addUrlPatterns("/*");
  40. return bean;
  41. }
  42. }

浏览器访问:http://localhost:8080/druid/login.html