热卖商品
新闻详情
springboot 配置整合 阿里 druid 连接池-fhspringcloud的博客-51...
来自 : 51CTO技术博客
发布时间:2021-03-24
dependency groupId org.springframework.boot /groupId artifactId spring-boot-starter-data-jdbc /artifactId /dependency配置文件配置连接池
spring: datasource: username: root password: 5201314 url: jdbc:mysql:///jqmb?serverTimezone=UTC driver-class-name: com.mysql.cj.jdbc.Driverspringboot默认的连接池
//java项目www.fhadmin.org @Autowired DataSource dataSource; @Test void contextLoads() { System.out.println(dataSource.getClass()); System.out.println(\"____________________________________\"); }
dependency groupId com.alibaba /groupId artifactId druid /artifactId version 1.0.18 /version /dependency配置文件配置druid的属性
#java项目www.fhadmin.orgspring: datasource: username: root password: 5201314 url: jdbc:mysql:///jqmb?serverTimezone=UTC 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 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true filters: stat,wall,log4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500配置类中对druid属性进行绑定
//java项目www.fhadmin.org@Configurationpublic class DataSource_Druid_Configure { @ConfigurationProperties(prefix = \"spring.datasource\") @Bean public DruidDataSource getDataSour(){ 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\",\"123456\");//登录密码 initParams.put(\"allow\",\"\");//默认就是允许所有访问 initParams.put(\"deny\",\"192.168.15.21\");//拒绝访问 bean.setInitParameters(initParams); return bean; }
本文链接: http://benaglobal.immuno-online.com/view-711790.html
发布于 : 2021-03-24
阅读(0)
最新动态
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
2021-03-24
联络我们