springboot+druid

1  springboots的项目创建

    创建一个maven项目，引入springboot的相关依赖包

2  引入springboot-druid的jar

 到druid的git中https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter  进行引入

<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid-spring-boot-starter</artifactId>
   <version>1.1.10</version>
</dependency>

3  配置yml文件

spring:
   datasource:
      druid:
         url: jdbc:oracle:thin:@172.16.2.172:1521:SIEBELDB
         username: SIEBEL
         password: SIEBEL
         driver-class-name: oracle.jdbc.driver.OracleDriver
         initial-size: 10
         max-active: 10000
         min-idle: 2
         max-wait: 100000
         timeBetweenEvictionRunsMillis: 60000
         minEvictableIdleTimeMillis: 300000
         #  是否缓存preparedStatement，也就是PSCache。PSCache对支持游标的数据库性能提升巨大，比如说oracle。在mysql下建议关闭。
         pool-prepared-statements: true
         # 要启用PSCache，必须配置大于0，当大于0时，poolPreparedStatements自动触发修改为true。在Druid中，不会存在Oracle下PSCache占用内存过多的问题，可以把这个数值配置大一些，比如说100
         max-open-prepared-statements: 100
         validation-query: select 1 from dual
         validation-query-timeout: 100000
         # 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 建议false
         test-on-borrow: false
         # 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 ，建议false
         test-on-return: false
         test-while-idle: true
         max-pool-prepared-statement-per-connection-size: 20
         filters: stat

4  配置druid数据源连接池

@Configuration
public class DBDruidConfig {

    private static Logger logger = LogManager.getLogger(DBDruidConfig.class);

    @Value("${spring.datasource.druid.url}")
    private String dbUrl;

    @Value("${spring.datasource.druid.username}")
    private String username;

    @Value("${spring.datasource.druid.password}")
    private String password;

    @Value("${spring.datasource.druid.driver-class-name}")
    private String driverClassName;

    @Value("${spring.datasource.druid.initial-size}")
    private int initialSize;

    @Value("${spring.datasource.druid.min-idle}")
    private int minIdle;

    @Value("${spring.datasource.druid.max-active}")
    private int maxActive;

    @Value("${spring.datasource.druid.max-wait}")
    private long maxWait;

    @Value("${spring.datasource.druid.timeBetweenEvictionRunsMillis}")
    private long timeBetweenEvictionRunsMillis;

    @Value("${spring.datasource.druid.minEvictableIdleTimeMillis}")
    private long minEvictableIdleTimeMillis;

    @Value("${spring.datasource.druid.validation-query}")
    private String validationQuery;

    @Value("${spring.datasource.druid.validation-query-timeout}")
    private int validationQueryTimeout;

    @Value("${spring.datasource.druid.test-while-idle}")
    private boolean testWhileIdle;

    @Value("${spring.datasource.druid.test-on-borrow}")
    private boolean testOnBorrow;

    @Value("${spring.datasource.druid.test-on-return}")
    private boolean testOnReturn;

    @Value("${spring.datasource.druid.pool-prepared-statements}")
    private boolean poolPreparedStatements;

    @Value("${spring.datasource.druid.max-pool-prepared-statement-per-connection-size}")
    private int maxPoolPreparedStatementPerConnectionSize;

    @Value("${spring.datasource.druid.filters}")
    private String filters;

    /*
    meger操作
    @Value("{spring.datasource.connectionProperties}")
    private String connectionProperties;*/

    @Bean(name = "druidDataSource")     //声明其为Bean实例
    @Primary  //在同样的DataSource中，首先使用被标注的DataSource
    public DruidDataSource dataSource(){
        DruidDataSource datasource = new DruidDataSource();

        datasource.setUrl(this.dbUrl);
        datasource.setUsername(username);
        datasource.setPassword(password);
        datasource.setDriverClassName(driverClassName);

        //configuration
        datasource.setInitialSize(initialSize);
        datasource.setMinIdle(minIdle);
        datasource.setMaxActive(maxActive);
        datasource.setMaxWait(maxWait);
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
        datasource.setValidationQuery(validationQuery);
        datasource.setValidationQueryTimeout(validationQueryTimeout);
        datasource.setTestWhileIdle(testWhileIdle);
        datasource.setTestOnBorrow(testOnBorrow);
        datasource.setTestOnReturn(testOnReturn);
        datasource.setPoolPreparedStatements(poolPreparedStatements);
        datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
        try {
            datasource.setFilters(filters);
        } catch (SQLException e) {
            logger.error("druid configuration initialization filter", e);
        }
        //datasource.setConnectionProperties(connectionProperties);

        return datasource;
    }

}

5  使用中

@Resource(name = "linkDruidDataSource")
private DruidDataSource druidDataSource;

  

6  操作

   

DruidPooledConnection conn = druidDataSource.getConnection();