SpringBoot1.5.x+druid1.0.x配置数据源

痛定思痛。 2022-05-17 06:05 202阅读 0赞

1.引入maven配置

<dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.31</version>
            </dependency>

2.配置文件 application.yml添加数据源配置

spring:
      application:
        name: spring-boot-study
      datasource:
        name: druid-dev
        url: jdbc:mysql://127.0.0.1/study?useUnicode=true&characterEncoding=utf8
        username: root
        password: root
        type: com.alibaba.druid.pool.DruidDataSource
        driverClassName: com.mysql.jdbc.Driver
        filters: stat
        maxActive: 20
        initialSize: 1
        maxWait: 60000
        minIdle: 1
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: select 'x'
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        maxOpenPreparedStatements: 20

3.添加数据源配置注入

import org.springframework.beans.factory.annotation.Value;
    import org.springframework.boot.bind.RelaxedPropertyResolver;
    import org.springframework.context.EnvironmentAware;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.core.env.Environment;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    
    import javax.sql.DataSource;
    import java.sql.SQLException;
    
    /**
     * @author: ZhouMingming
     * @data: Create on 2018/7/27.
     */
    @Configuration
    @EnableTransactionManagement
    public class DruidAutoConfiguration implements EnvironmentAware {
    
        private RelaxedPropertyResolver propertyResolver;
    
        @Override
        public void setEnvironment(Environment environment) {
            this.propertyResolver = new RelaxedPropertyResolver(environment, "spring.datasource.");
        }
    
        @Value("${spring.datasource.url}")
        private String myUrl;
    
        @Bean(destroyMethod = "close", initMethod = "init")
        public DataSource writeDataSource() {
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setUrl(propertyResolver.getProperty("url"));
            dataSource.setUsername(propertyResolver.getProperty("username"));
            dataSource.setPassword(propertyResolver.getProperty("password"));
            dataSource.setDriverClassName(propertyResolver.getProperty("driverClassName"));
            dataSource.setInitialSize(Integer.parseInt(propertyResolver.getProperty("initialSize")));
            dataSource.setMaxActive(Integer.parseInt(propertyResolver.getProperty("maxActive")));
            dataSource.setMinIdle(Integer.parseInt(propertyResolver.getProperty("minIdle")));
            dataSource.setMaxWait(Integer.parseInt(propertyResolver.getProperty("maxWait")));
            dataSource.setUseUnfairLock(Boolean.valueOf(propertyResolver.getProperty("useUnfairLock")));
            dataSource.setValidationQuery(propertyResolver.getProperty("validationQuery"));
            dataSource.setTestOnBorrow(Boolean.valueOf(propertyResolver.getProperty("testOnBorrow")));
            dataSource.setTestOnReturn(Boolean.valueOf(propertyResolver.getProperty("testOnReturn")));
            dataSource.setTestWhileIdle(Boolean.valueOf(propertyResolver.getProperty("testWhileIdle")));
            dataSource.setTimeBetweenEvictionRunsMillis(Integer.parseInt(propertyResolver.getProperty("timeBetweenEvictionRunsMillis")));
            dataSource.setMinEvictableIdleTimeMillis(Integer.parseInt(propertyResolver.getProperty("minEvictableIdleTimeMillis")));
            try {
                dataSource.setFilters(propertyResolver.getProperty("filters"));
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
            return dataSource;
        }
    
    }

4.配置数据源拦截配置

import com.alibaba.druid.support.http.StatViewServlet;
    
    import javax.servlet.annotation.WebInitParam;
    import javax.servlet.annotation.WebServlet;
    
    /**
     * @author: ZhouMingming
     * @data: Create on 2018/7/27.
     */
    @WebServlet(urlPatterns = "/druid/*", initParams = {@WebInitParam(name = "allow", value = "192.168.1.72,127.0.0.1"), // IP白名单 默认所有可以访问
            @WebInitParam(name = "deny", value = "192.168.1.73"), // IP黑名单 (存在共同时，deny优先于allow)
            @WebInitParam(name = "loginUsername", value = "root"),
            @WebInitParam(name = "loginPassword", value = "root"),
            @WebInitParam(name = "resetEnable", value = "false")// 禁用HTML页面上的“Reset All”功能
    })
    public class DruidStatViewServlet extends StatViewServlet {
    
        private static final long serialVersionUID = 1776463055477495407L;
    
    }

5.配置数据过滤

import com.alibaba.druid.support.http.WebStatFilter;
    
    import javax.servlet.annotation.WebFilter;
    import javax.servlet.annotation.WebInitParam;
    
    /**
     * 过滤
     * @author: ZhouMingming
     * @data: Create on 2018/7/27.
     */
    @WebFilter(filterName = "druidWebStatFilter", urlPatterns = "/*",
            initParams = {@WebInitParam(name = "exclusions", value = "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")})
    public class DuriStatFilter extends WebStatFilter {
    }

这样就配置完成可以使用了