亚洲伊人久久综合,亚洲a网,亚洲网站免费

1、引入依賴包

									<!--druid-->

									<dependency>

									  <groupId>com.alibaba</groupId>

									  <artifactId>druid</artifactId>

									  <version>1.0.27</version>

									</dependency>

2、配置application.properties

									spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

									spring.datasource.url=jdbc:mysql://localhost:3306/xxxxx?characterEncoding=utf8&useSSL=true&verifyServerCertificate=false

									spring.datasource.username=root

									spring.datasource.password=xxxxx

									spring.datasource.driver-class-name=com.mysql.jdbc.Driver

									# 初始化大小，最小，最大

									spring.datasource.initialSize=5

									spring.datasource.minIdle=5

									spring.datasource.maxActive=20

									# 配置獲取連接等待超時的時間

									spring.datasource.maxWait=60000

									# 配置間隔多久才進行一次檢測，檢測需要關閉的空閑連接，單位是毫秒

									spring.datasource.timeBetweenEvictionRunsMillis=60000

									# 配置一個連接在池中最小生存的時間，單位是毫秒

									spring.datasource.minEvictableIdleTimeMillis=300000

									spring.datasource.validationQuery=SELECT 1 FROM DUAL

									spring.datasource.testWhileIdle=true

									spring.datasource.testOnBorrow=false

									spring.datasource.testOnReturn=false

									# 打開PSCache，并且指定每個連接上PSCache的大小

									spring.datasource.poolPreparedStatements=true

									spring.datasource.maxPoolPreparedStatementPerConnectionSize=20

									# 配置監控統計攔截的filters，去掉后監控界面sql無法統計，'wall'用于防火墻

									spring.datasource.filters=stat,wall,log4j

									# 通過connectProperties屬性來打開mergeSql功能；慢SQL記錄

									spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

									# 合并多個DruidDataSource的監控數據

									#spring.datasource.useGlobalDataSourceStat=true

									spring.jpa.database=mysql

									spring.jpa.show-sql=true

									spring.jpa.hibernate.ddl-auto=update

									spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

									#懶加載配置

									spring.jpa.properties.hibernate.enable_lazy_load_no_trans=true

3、目前Spring Boot中默認支持的連接池有dbcp,dbcp2, tomcat, hikari三種連接池。由于Druid暫時不在Spring Bootz中的直接支持，故需要進行配置信息的定制

100

101

102

103

104

105

106

									import com.alibaba.druid.pool.DruidDataSource;

									import com.alibaba.druid.support.http.StatViewServlet;

									import com.alibaba.druid.support.http.WebStatFilter;

									import org.springframework.beans.factory.annotation.Value;

									import org.springframework.boot.web.servlet.FilterRegistrationBean;

									import org.springframework.boot.web.servlet.ServletRegistrationBean;

									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 DruidConfiguration {

									  @Value("${spring.datasource.url}")

									  private String dbUrl;

									  @Value("${spring.datasource.username}")

									  private String username;

									  @Value("${spring.datasource.password}")

									  private String password;

									  @Value("${spring.datasource.driver-class-name}")

									  private String driverClassName;

									  @Value("${spring.datasource.initialSize}")

									  private int initialSize;

									  @Value("${spring.datasource.minIdle}")

									  private int minIdle;

									  @Value("${spring.datasource.maxActive}")

									  private int maxActive;

									  @Value("${spring.datasource.maxWait}")

									  private int maxWait;

									  @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")

									  private int timeBetweenEvictionRunsMillis;

									  @Value("${spring.datasource.minEvictableIdleTimeMillis}")

									  private int minEvictableIdleTimeMillis;

									  @Value("${spring.datasource.validationQuery}")

									  private String validationQuery;

									  @Value("${spring.datasource.testWhileIdle}")

									  private boolean testWhileIdle;

									  @Value("${spring.datasource.testOnBorrow}")

									  private boolean testOnBorrow;

									  @Value("${spring.datasource.testOnReturn}")

									  private boolean testOnReturn;

									  @Value("${spring.datasource.poolPreparedStatements}")

									  private boolean poolPreparedStatements;

									  @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")

									  private int maxPoolPreparedStatementPerConnectionSize;

									  @Value("${spring.datasource.filters}")

									  private String filters;

									  @Value("{spring.datasource.connectionProperties}")

									  private String connectionProperties;

									  @Bean   //聲明其為Bean實例

									  @Primary //在同樣的DataSource中，首先使用被標注的DataSource

									  public DataSource 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.setTestWhileIdle(testWhileIdle);

									    datasource.setTestOnBorrow(testOnBorrow);

									    datasource.setTestOnReturn(testOnReturn);

									    datasource.setPoolPreparedStatements(poolPreparedStatements);

									    datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);

									    try {

									      datasource.setFilters(filters);

									    } catch (SQLException e) {

									      System.err.println("druid configuration initialization filter: "+ e);

									    }

									    datasource.setConnectionProperties(connectionProperties);

									    return datasource;

									  }

									  @Bean

									  public ServletRegistrationBean statViewServle(){

									    ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");

									    // IP白名單

									    servletRegistrationBean.addInitParameter("allow","192.168.1.218,127.0.0.1");

									    // IP黑名單(共同存在時，deny優先于allow)

									    servletRegistrationBean.addInitParameter("deny","192.168.1.100");

									    //控制臺管理用戶

									    servletRegistrationBean.addInitParameter("loginUsername","druid");

									    servletRegistrationBean.addInitParameter("loginPassword","761341");

									    //是否能夠重置數據

									    servletRegistrationBean.addInitParameter("resetEnable","false");

									    return servletRegistrationBean;

									  }

									  @Bean

									  public FilterRegistrationBean statFilter(){

									    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());

									    //添加過濾規則

									    filterRegistrationBean.addUrlPatterns("/*");

									    //忽略過濾的格式

									    filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

									    return filterRegistrationBean;

									  }

									}