1, 配置数据
- spring:
- datasource:
- username: root
- password: 12312323
- url: jdbc:MySQL://17.114.216.204:3306/zlgc
- # 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
- # schema:
- # - classpath:department.sql
2, 源码
- package com.example.jdbc.config;
- import com.alibaba.druid.pool.DruidDataSource;
- import com.alibaba.druid.support.http.StatViewServlet;
- import com.alibaba.druid.support.http.webStatFilter;
- import org.springframework.boot.context.properties.ConfigurationProperties;
- import org.springframework.boot.Web.servlet.FilterRegistrationBean;
- import org.springframework.boot.Web.servlet.ServletRegistrationBean;
- import org.springframework.context.annotation.Bean;
- import org.springframework.context.annotation.Configuration;
- import javax.sql.DataSource;
- import java.util.Arrays;
- import java.util.HashMap;
- import java.util.Map;
- /**
- * @author liwen406
- * @Title: DruidConfig
- * @Description:
- * @date 2018/12/21 / 22:43
- */
- @Configuration
- public class DruidConfig {
- @ConfigurationProperties(prefix = "spring.datasource")
- @Bean
- public DataSource druid() {
- return new DruidDataSource();
- }
- // 配置 Druid 的监控
- //1, 配置一个管理后台的 Servlet
- @Bean
- public ServletRegistrationBean statViewServlet() {
- ServletRegistrationBean bean = 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", "192.168.1.2"); // 拒绝谁访问
- bean.setInitParameters(initParams);
- return bean;
- }
- //2, 配置一个 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;
- }
- }
3, 效果
使用在线转换 logo[ http://www.bitbug.net/]logo ]
:
来源: http://www.bubuko.com/infodetail-2894270.html