Springboot整合Druid数据源

最新推荐文章于 2022-10-16 21:01:50 发布

takujo

最新推荐文章于 2022-10-16 21:01:50 发布

阅读量197

点赞数

分类专栏： java 文章标签： Springboot druid 数据源

本文链接：https://blog.csdn.net/takujo/article/details/83501025

版权

java 专栏收录该内容

14 篇文章 1 订阅

订阅专栏

yml文件

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource 
    initialSize: 5
    maxActive: 20  
    maxWait: 60000  
    minIdle: 5
    timeBetweenEvictionRunsMillis: 60000  
    minEvictableIdleTimeMillis: 300000  
    validationQuery: SELECT 'x'  
    testWhileIdle: true  
    testOnBorrow: false  
    testOnReturn: false  
    
#   配置监控统计拦截
    filters: stat,wall
    connectionProperties: druid.stat.mergeSql=true,druid.stat.slowSqlMillis=5000
    useGlobalDataSourceStat: true

java DruidConfig

@Configuration
public class DruidConfig {

	@ConfigurationProperties(prefix = "spring.datasource")
	@Bean
	public DataSource druid() {
		return new DruidDataSource();
	}

	/**
	 * 向容器添加状态视图servlet
	 * 
	 * @return
	 */
	@Bean
	public ServletRegistrationBean<Servlet> statViewServlet() {
		ServletRegistrationBean<Servlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
		Map<String, String> map = new HashMap<>();
		map.put("loginUsername", "admin");
		map.put("loginPassword", "123456");
		map.put("allow", "");// 默认允许所有访问
		bean.setInitParameters(map);
		return bean;
	}

	/**
	 * 向容器添加web状态过滤器
	 * 
	 * @return
	 */
	@Bean
	public FilterRegistrationBean<Filter> webStatFilter() {
		FilterRegistrationBean<Filter> bean = new FilterRegistrationBean<>();
		bean.setFilter(new WebStatFilter());
		Map<String, String> map = new HashMap<>();
		map.put("exclusions", "*. js ,*. gif ,*. jpg ,*. png ,*. css ,*. ico ,/druid/*");
		bean.setInitParameters(map);
		bean.setUrlPatterns(Arrays.asList("/*"));
		return bean;
	}

}

以 localhost:port/context/druid 访问控制台，登录名为admin，密码为123456