Spring Boot项目配置Druid数据源(druid)

Spring Boot项目配置Druid数据源(druid)

本章中使用的druid依赖是

　　com.alibaba　　druid　　1.1.15

不是

com.alibaba druid-spring-boot-starter 1.1.22

两种依赖的配置方式不同, 如果你使用的是druid-spring-boot-starter的依赖方式, 请看(Spring Boot项目配置Druid数据源(druid-spring-boot-starter))

yml文件配置

具体配置也可以参考(Spring Boot项目配置Druid数据源(druid-spring-boot-starter))

spring: datasource: username: root password: XXX url: jdbc:mysql://XXX.XX.XX.XXX:33306/数据库名?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai 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 'x' testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙 filters: stat,wall,slf4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

Druid Config

druid依赖的方式还需要创建对应的config类

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

配置Durid的监控

/** * 数据库链接池druid监控平台的配置 * 访问路径 * */@Configuration@Slf4jpublic class DruidConfiguration { @Bean public ServletRegistrationBean druidServlet() { logger.info("init Druid Servlet Configuration "); ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*"); // IP白名单// servletRegistrationBean.addInitParameter("allow", "*"); // IP黑名单(共同存在时，deny优先于allow)// servletRegistrationBean.addInitParameter("deny", "127.0.0.1"); //控制台管理用户 servletRegistrationBean.addInitParameter("loginUsername", "admin"); servletRegistrationBean.addInitParameter("loginPassword", "admin"); //是否能够重置数据 禁用HTML页面上的“Reset All”功能 servletRegistrationBean.addInitParameter("resetEnable", "false"); return servletRegistrationBean; } @Bean public FilterRegistrationBean filterRegistrationBean() { FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter()); filterRegistrationBean.addUrlPatterns("/*"); filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return filterRegistrationBean; }}

其他使用参考(druid-spring-boot-starter))

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。