springboot配置druid数据源

深藏阁楼爱情的钟 2022-05-14 03:05 308阅读 0赞

application.yml

spring:
      datasource:
        username: root
        password: root
        url: jdbc:mysql://192.168.25.131:3306/jdbc?autoReconnect=true
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        #   数据源其他配置
        initialSize: 5
        minIdle: 5
        maxActive: 20
        maxWait: 60000
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: SELECT 1 FROM DUAL
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
    #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
        filters: stat,wall,log4j
        maxPoolPreparedStatementPerConnectionSize: 20
        useGlobalDataSourceStat: true
        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

DataSourceConfig

@Configuration
    public class DataSourceConfig {
    
        @Bean
        @ConfigurationProperties("spring.datasource")
        public DataSource dataSource() {
            DruidDataSource dataSource = new DruidDataSource();
            return dataSource;
        }
    
        //配置Druid的监控
        //配置一个管理后台的Servlet
        @Bean
        public ServletRegistrationBean statViewServlet() {
            ServletRegistrationBean registrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
    
            Map<String, String> initParams = new HashMap<>();
            initParams.put("loginUsername","admin");    //登录名
            initParams.put("loginPassword","admin");    //登录密码
            initParams.put("allow","");//默认就是允许所有访问
            //initParams.put("deny","127.0.0.1");       //拒接访问
            registrationBean.setInitParameters(initParams);
            return registrationBean;
        }
    
        //配置一个web监控的filter
        @Bean
        public FilterRegistrationBean webStatFilter(){
            FilterRegistrationBean bean = new FilterRegistrationBean();
            bean.setFilter(new WebStatFilter());
    
            Map<String,String> initParams = new HashMap<>();
            initParams.put("exclusions","*.js,*.css,/druid/*");
    
            bean.setInitParameters(initParams);
    
            bean.setUrlPatterns(Arrays.asList("/*"));
    
            return  bean;
        }
    }

druid监控

![70][]

[70]: /images/20220514/01a660ab511c4d3bbce5f71c300ac5b2.png