springboot 整合阿里的数据库连接池druid

╰+攻爆jí腚メ 2023-01-13 10:29 162阅读 0赞

*  # 使用springboot默认的连接池 #
 *  ### 导入springboot data-jdbc依赖 ###

<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.Driver

*  ### springboot默认的连接池 ###

//java项目www.fhadmin.org
        @Autowired
          DataSource dataSource;
        @Test
        void contextLoads() {
            System.out.println(dataSource.getClass());
            System.out.println("____________________________________");
        }

![e390ce8fc0f3f69be33d2a403b845108.png][]

*  #  使用连接池druid #
 *  ### 导入druid依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.18</version>
            </dependency>

*  ### 配置文件配置druid的属性 ###

#java项目www.fhadmin.org
    spring:
      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

![8fe0d51e2ef938828f90a29e366b9058.png][]

*  ### **配置类中对druid属性进行绑定** ###

//java项目www.fhadmin.org
    @Configuration
    public class DataSource_Druid_Configure {
    
        @ConfigurationProperties(prefix = "spring.datasource")
        @Bean
        public DruidDataSource getDataSour(){
            return new DruidDataSource();
        }

![f941641ce717ca6ef0b593f947676cd8.png][]

*  ### 配置Druid的监控后台 ###

//配置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;
        }
    
    
        //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;
        }

*  ###  访问 localhost:8090/druid/login.html ###

![ed031c9b39822be3e39b2999cbfe3324.png][]

*  ###  如果sql监控失效需要导入log4j 依赖 ###

[e390ce8fc0f3f69be33d2a403b845108.png]: /images/20221022/2af524cbee384c6da3afeec4ce867897.png
[8fe0d51e2ef938828f90a29e366b9058.png]: /images/20221022/bea8668def984475acbd350b717d8440.png
[f941641ce717ca6ef0b593f947676cd8.png]: /images/20221022/4fd8a5d2d7b54786822f0b34ac288821.png
[ed031c9b39822be3e39b2999cbfe3324.png]: /images/20221022/46a10a084c6f4d728d762318d30d6a4d.png