package com.chenyang.stu.exdruid.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.sql.DataSource;
import java.sql.SQLException;

@configuration
public class DruidDataSourceConfig {

/**
 * druid数据库连接池配置
 */
@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.driverClassName}")
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 int maxWait;  
@Value("${spring.datasource.druid.time-between-eviction-runs-millis}")
private int timeBetweenEvictionRunsMillis;  
@Value("${spring.datasource.druid.min-evictable-idle-time-millis}")
private int minEvictableIdleTimeMillis;  
@Value("${spring.datasource.druid.validation-query}")
private String validationQuery;
@Value("${spring.datasource.druid.pool-prepared-statements}")
private boolean poolPreparedStatements;  
@Value("${spring.datasource.druid.max-open-prepared-statements}")
private int maxPoolPreparedStatementPerConnectionSize;  
@Value("${spring.datasource.druid.filters}")
private String filters;  
@Value("${spring.datasource.druid.connection-properties}")
private String connectionProperties;  

/**
 * 创建druid数据库连接池bean
 * @return
 */
@Bean
@Primary
public DataSource dataSource(){  
    DruidDataSource datasource = new DruidDataSource();  
    datasource.setUrl(this.dbUrl);  
    datasource.setUsername(username);  
    datasource.setPassword(password);  
    datasource.setDriverClassName(driverClassName);  
    datasource.setInitialSize(initialSize);  
    datasource.setMinIdle(minIdle);  
    datasource.setMaxActive(maxActive);  
    datasource.setMaxWait(maxWait);          
    datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);  
    datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);  
    datasource.setValidationQuery(validationQuery);  
    datasource.setPoolPreparedStatements(poolPreparedStatements);
    datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
    try {
        datasource.setFilters(filters);  
    } catch (SQLException e) {  
        e.printStackTrace();
    }  

    datasource.setConnectionProperties(connectionProperties);  

    return datasource;  
}

}