Druid后台监控功能

悄悄的卷死他们

已于 2022-08-28 20:01:40 修改

阅读量141

点赞数

文章标签： java 前端数据库

于 2022-08-28 17:10:36 首次发布

本文链接：https://blog.csdn.net/qq_56742368/article/details/126571775

版权

@Configuration
public class DruidConfig {

    //绑定配置文件
    @ConfigurationProperties(prefix ="spring.datasource")
    @Bean
    public DataSource druidDataSource(){
        return new DruidDataSource();
    }

    //后台监控功能
    @Bean
    public ServletRegistrationBean statViewServlet(){
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        //后台需要有人登录，账号密码配置
        HashMap<String,String> initParameters = new HashMap<>();

        //增加配置
        initParameters.put("loginUsername","admin");  //登录的key 是固定的 loginUsername  loginPassword
        initParameters.put("loginPassword","123456");

        //允许谁能访问
        initParameters.put("allow","");

        //禁止谁能访问
       /* initParameters.put("kuangshen","198.123.123.123");*/

        bean.setInitParameters(initParameters);  //设置初始化参数
        return bean;
    }
}

yml配置文件

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8
    driver-class-name: com.mysql.cj.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: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    userGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true; druid.stat.slowSqlMillis=500