Druid配置使用

1.添加druid依赖包

<dependency>

  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.0.28</version>

</dependency>

2.添加数据库连接池配置

DataSource ProduceWriteDataSource() throws Exception {

      Properties props = new Properties();
      props.put("driverClassName", env.getProperty("jdbc_produce_write_datasource.driverClassName"));
      props.put("url", env.getProperty("jdbc_produce_write_datasource.url"));
      props.put("username", env.getProperty("jdbc_produce_write_datasource.username"));
      props.put("password", env.getProperty("jdbc_produce_write_datasource.password"));
      //初始化连接数量
      props.put("initialSize","5");
      //最小空闲连接数
      props.put("minIdle","5");
      //最大空闲连接数
      props.put("maxIdle","20");
      //最大连接数
      props.put("maxActive","200");
      //配置获取连接等待超时的时间
      props.put("maxWait","50000");
      //配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
      props.put("timeBetweenEvictionRunsMillis","60000");
      //配置一个连接在池中最小生存的时间，单位是毫秒
      props.put("minEvictableIdleTimeMillis","300000");
      //连接被泄露时是否打印
      props.put("logAbandoned","true");
      //是否自动回收超时连接
      props.put("removeAbandoned","true");
      //超时时间(以秒数为单位)
      props.put("removeAbandonedTimeout","10");
      //SQL查询,用来验证从连接池取出的连接,在将连接返回给调用者之前.如果指定,则查询必须是一个SQL SELECT并且必须返回至少一行记录
      props.put("validationQuery","SELECT 1");
      //生产线上一般不启动
      //指明是否在从池中取出连接前进行检验,如果检验失败,则从池中去除连接并尝试取出另一个
      props.put("testOnBorrow","false");
      //指明是否在归还到池中前进行检验.设置为true后如果要生效,validationQuery参数必须设置为非空字符串
      props.put("testOnReturn","false");
      //指明连接是否被空闲连接回收器(如果有)进行检验.如果检测失败,则连接将被从池中去除.
      props.put("testWhileIdle","true");
      //配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
      //stat:统计监控信息
      props.put("filters","stat,wall,log4j");
      //是否合并sql语句
      props.put("druid.useGlobalDataSourceStat","true");
      //通过connectProperties属性来打开mergeSql功能；慢SQL记录
      props.put("connectionProperties","druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000");
      return DruidDataSourceFactory.createDataSource(props);
  }

3.添加servlet、filter

@Bean

  public ServletRegistrationBean druidServlet() {
      ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
      //白名单：
      servletRegistrationBean.addInitParameter("allow","127.0.0.1,106.39.78.2,10.2.123.174");
      //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
      servletRegistrationBean.addInitParameter("deny","192.168.1.1");
      //登录查看信息的账号密码.
      servletRegistrationBean.addInitParameter("loginUsername","admin");
      servletRegistrationBean.addInitParameter("loginPassword","123456");
      //是否能够重置数据.
      servletRegistrationBean.addInitParameter("resetEnable","true");
      return servletRegistrationBean;
  }

  @Bean
  public FilterRegistrationBean filterRegistrationBean() {
      FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
      filterRegistrationBean.setFilter(new WebStatFilter());
      filterRegistrationBean.addUrlPatterns("/*");
      添加不需要忽略的格式信息
      filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
      filterRegistrationBean.addInitParameter("sessionStatMaxCount","1000");
      filterRegistrationBean.addInitParameter("profileEnable","true");
      return filterRegistrationBean;
  }
  

4.访问方式

http:<host>:<port>/druid/index.html