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