Java DruidDataSource.setFilters方法代码示例

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean(initMethod = "init", destroyMethod = "close")
@Primary
public DruidDataSource businessDataSource() throws SQLException, DESException {
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setDriverClassName(dbConfigProperties.getDriveClass());
    druidDataSource.setUrl(dbConfigProperties.getBusinessUrl());
    druidDataSource.setUsername(dbConfigProperties.getBusinessUsername());
    druidDataSource.setPassword(dbConfigProperties.getBusinessPassword());
    druidDataSource.setInitialSize(dbConfigProperties.getInitialSize());
    druidDataSource.setMinIdle(dbConfigProperties.getMinIdle());
    druidDataSource.setMaxActive(dbConfigProperties.getMaxActive());
    druidDataSource.setMaxWait(dbConfigProperties.getMaxWait());
    druidDataSource.setTimeBetweenEvictionRunsMillis(dbConfigProperties.getTimeBetweenEvictionRunsMillis());
    druidDataSource.setMinEvictableIdleTimeMillis(dbConfigProperties.getMinEvictableIdleTimeMillis());
    druidDataSource.setValidationQuery(dbConfigProperties.getValidationQuery());//此项如果为空，下面几个test都不会生效
    druidDataSource.setTestWhileIdle(dbConfigProperties.getTestWhileIdle());
    druidDataSource.setTestOnBorrow(dbConfigProperties.getTestOnBorrow());
    druidDataSource.setTestOnReturn(dbConfigProperties.getTestOnReturn());
    druidDataSource.setPoolPreparedStatements(dbConfigProperties.getPoolPreparedStatements());//5.5以后的mysql开启，以后的关闭
    druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(dbConfigProperties.getMaxPoolPreparedStatementPerConnectionSize());
    druidDataSource.setFilters(dbConfigProperties.getFilters());
    return druidDataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean(name = ConfigConstant.NAME_DS_MASTER)
@Primary
@ConfigurationProperties(prefix = ConfigConstant.PREFIX_DS_MASTER)
public DataSource mafMasterDataSource() {
    logger.info("----- MAFIA master data source INIT -----");
    DruidDataSource ds = new DruidDataSource();
    try {
        ds.setFilters(env.getProperty("ds.filters"));
    } catch (SQLException e) {
        logger.warn("Data source set filters ERROR:", e);
    }
    ds.setMaxActive(NumberUtils.toInt(env.getProperty("ds.maxActive"), 90));
    ds.setInitialSize(NumberUtils.toInt(env.getProperty("ds.initialSize"), 10));
    ds.setMaxWait(NumberUtils.toInt(env.getProperty("ds.maxWait"), 60000));
    ds.setMinIdle(NumberUtils.toInt(env.getProperty("ds.minIdle"), 1));
    ds.setTimeBetweenEvictionRunsMillis(NumberUtils.toInt(env.getProperty("ds.timeBetweenEvictionRunsMillis"), 60000));
    ds.setMinEvictableIdleTimeMillis(NumberUtils.toInt(env.getProperty("ds.minEvictableIdleTimeMillis"), 300000));
    ds.setValidationQuery(env.getProperty("ds.validationQuery"));
    ds.setTestWhileIdle(BooleanUtils.toBoolean(env.getProperty("ds.testWhileIdle")));
    ds.setTestOnBorrow(BooleanUtils.toBoolean(env.getProperty("ds.testOnBorrow")));
    ds.setTestOnReturn(BooleanUtils.toBoolean(env.getProperty("ds.testOnReturn")));
    ds.setPoolPreparedStatements(BooleanUtils.toBoolean(env.getProperty("ds.poolPreparedStatements")));
    ds.setMaxOpenPreparedStatements(NumberUtils.toInt(env.getProperty("ds.maxOpenPreparedStatements"), 20));
    return ds;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean
  public DataSource dataSource() {
      System.out.println("注入druid！！！");
      DruidDataSource datasource = new DruidDataSource();
      datasource.setUrl(propertyResolver.getProperty("url"));
      datasource.setDriverClassName(propertyResolver.getProperty("driver-class-name"));
      datasource.setUsername(propertyResolver.getProperty("username"));
      datasource.setPassword(propertyResolver.getProperty("password"));
      datasource.setInitialSize(Integer.valueOf(propertyResolver.getProperty("initial-size")));
      datasource.setMinIdle(Integer.valueOf(propertyResolver.getProperty("min-idle")));
      datasource.setMaxWait(Long.valueOf(propertyResolver.getProperty("max-wait")));
      datasource.setMaxActive(Integer.valueOf(propertyResolver.getProperty("max-active")));
      datasource.setMinEvictableIdleTimeMillis(Long.valueOf(propertyResolver.getProperty("min-evictable-idle-time-millis")));
      try {
	datasource.setFilters("stat,wall,stat,log4j,default");
} catch (SQLException e) {
	e.printStackTrace();
}
      return datasource;
  }
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
protected DataSource createDataSource() throws SQLException {
  // special
  DruidDataSource datasource = new DruidDataSource();
  datasource.setUrl(commonProperties.getUrl());
  datasource.setUsername(commonProperties.getUsername());
  datasource.setPassword(commonProperties.getPassword());
  // common
  datasource.setDriverClassName(commonProperties.getDriverClassName());
  datasource.setInitialSize(commonProperties.getInitialSize());
  datasource.setMinIdle(commonProperties.getMinIdle());
  datasource.setMaxActive(commonProperties.getMaxActive());
  datasource.setMaxWait(commonProperties.getMaxWait());
  datasource
      .setTimeBetweenEvictionRunsMillis(commonProperties.getTimeBetweenEvictionRunsMillis());
  datasource.setMinEvictableIdleTimeMillis(commonProperties.getMinEvictableIdleTimeMillis());
  datasource.setValidationQuery(commonProperties.getValidationQuery());
  datasource.setTestWhileIdle(commonProperties.isTestWhileIdle());
  datasource.setTestOnBorrow(commonProperties.isTestOnBorrow());
  datasource.setTestOnReturn(commonProperties.isTestOnReturn());
  datasource.setPoolPreparedStatements(commonProperties.isPoolPreparedStatements());
  datasource.setMaxPoolPreparedStatementPerConnectionSize(
      commonProperties.getMaxPoolPreparedStatementPerConnectionSize());
  datasource.setFilters(commonProperties.getFilters());
  datasource.setConnectionProperties(commonProperties.getConnectionProperties());
  return datasource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean
public DataSource dataSource() {
	DruidDataSource druidDataSource = new DruidDataSource();

	/**
	 * 驱动配置
	 */
	druidDataSource.setDriverClassName(property.getDriverClassName());
	druidDataSource.setUrl(property.getUrl());
	druidDataSource.setUsername(property.getUsername());
	druidDataSource.setPassword(property.getPassword());

	/**
	 * 其它链接池配置自行完成
	 */
	druidDataSource.setConnectionProperties(property.getConnectionProperties());

	try {
		druidDataSource.setFilters(property.getFilters());
	} catch (SQLException e) {
		log.error("druid configuration initialization filter", e);
	}

	return druidDataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean
public DataSource dataSource() {
    DruidDataSource datasource = new DruidDataSource();
    datasource.setUrl(databaseConfig.getUrl());
    datasource.setDriverClassName(databaseConfig.getDriverClassName());
    datasource.setUsername(databaseConfig.getUsername());
    datasource.setPassword(databaseConfig.getPassword());
    datasource.setInitialSize(databaseConfig.getInitialSize());
    datasource.setMinIdle(databaseConfig.getMinIdle());
    datasource.setMaxWait(databaseConfig.getMaxWait());
    datasource.setMaxActive(databaseConfig.getMaxActive());
    datasource.setMinEvictableIdleTimeMillis(databaseConfig.getMinEvictableIdleTimeMillis());
    try {
        datasource.setFilters("stat,wall,log4j2");
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return datasource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean(initMethod = "init", destroyMethod = "close")
public DruidDataSource dataSource() throws SQLException {
    if (StringUtils.isEmpty(propertyResolver.getProperty("url"))) {
        System.out.println("Your database connection pool configuration is incorrect!"
                + " Please check your Spring profile, current profiles are:"
                + Arrays.toString(environment.getActiveProfiles()));
        throw new ApplicationContextException(
                "Database connection pool is not configured correctly");
    }
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setDriverClassName(propertyResolver.getProperty("driver-class-name"));
    druidDataSource.setUrl(propertyResolver.getProperty("url"));
    druidDataSource.setUsername(propertyResolver.getProperty("username"));
    druidDataSource.setPassword(propertyResolver.getProperty("password"));
    druidDataSource.setInitialSize(Integer.parseInt(propertyResolver.getProperty("initialSize")));
    druidDataSource.setMinIdle(Integer.parseInt(propertyResolver.getProperty("minIdle")));
    druidDataSource.setMaxActive(Integer.parseInt(propertyResolver.getProperty("maxActive")));
    druidDataSource.setMaxWait(Integer.parseInt(propertyResolver.getProperty("maxWait")));
    druidDataSource.setTimeBetweenEvictionRunsMillis(Long.parseLong(propertyResolver.getProperty("timeBetweenEvictionRunsMillis")));
    druidDataSource.setMinEvictableIdleTimeMillis(Long.parseLong(propertyResolver.getProperty("minEvictableIdleTimeMillis")));
    druidDataSource.setValidationQuery(propertyResolver.getProperty("validationQuery"));
    druidDataSource.setTestWhileIdle(Boolean.parseBoolean(propertyResolver.getProperty("testWhileIdle")));
    druidDataSource.setTestOnBorrow(Boolean.parseBoolean(propertyResolver.getProperty("testOnBorrow")));
    druidDataSource.setTestOnReturn(Boolean.parseBoolean(propertyResolver.getProperty("testOnReturn")));
    druidDataSource.setPoolPreparedStatements(Boolean.parseBoolean(propertyResolver.getProperty("poolPreparedStatements")));
    druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(Integer.parseInt(propertyResolver.getProperty("maxPoolPreparedStatementPerConnectionSize")));
    druidDataSource.setFilters(propertyResolver.getProperty("filters"));
    return druidDataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
public boolean start() {
	ds = new DruidDataSource();
	
	ds.setUrl(url);
	ds.setUsername(username);
	ds.setPassword(password);
	ds.setDriverClassName(driverClass);
	ds.setInitialSize(initialSize);
	ds.setMinIdle(minIdle);
	ds.setMaxActive(maxActive);
	ds.setMaxWait(maxWait);
	ds.setTimeBetweenConnectErrorMillis(timeBetweenConnectErrorMillis);
	ds.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
	ds.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
	
	ds.setValidationQuery(validationQuery);
	ds.setTestWhileIdle(testWhileIdle);
	ds.setTestOnBorrow(testOnBorrow);
	ds.setTestOnReturn(testOnReturn);
	
	ds.setRemoveAbandoned(removeAbandoned);
	ds.setRemoveAbandonedTimeoutMillis(removeAbandonedTimeoutMillis);
	ds.setLogAbandoned(logAbandoned);
	
	//只要maxPoolPreparedStatementPerConnectionSize>0,poolPreparedStatements就会被自动设定为true，参照druid的源码
	ds.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
	
	if (StrKit.notBlank(filters))
		try {ds.setFilters(filters);} catch (SQLException e) {throw new RuntimeException(e);}
	
	addFilterList(ds);
	return true;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
private void configDruid(DruidDataSource dataSource, DruidProperties properties) {
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    if (properties.getInitialSize() > 0) {
        dataSource.setInitialSize(properties.getInitialSize());
    }
    if (properties.getMinIdle() > 0) {
        dataSource.setMinIdle(properties.getMinIdle());
    }
    if (properties.getMaxActive() > 0) {
        dataSource.setMaxActive(properties.getMaxActive());
    }
    if (properties.getMaxWait() > 0 ){
        dataSource.setMaxWait(properties.getMaxWait());
    }
    if (properties.getTimeBetweenEvictionRunsMillis() > 0l){
        dataSource.setTimeBetweenEvictionRunsMillis(properties.getTimeBetweenEvictionRunsMillis());
    }
    if (properties.getMaxPoolPreparedStatementPerConnectionSize() > 0 ){
        dataSource.setMaxPoolPreparedStatementPerConnectionSize(properties.getMaxPoolPreparedStatementPerConnectionSize());
    }
    if (properties.getValidationQueryTimeout() > 0 ){
        dataSource.setValidationQueryTimeout(properties.getValidationQueryTimeout());
    }
    if (properties.getMinEvictableIdleTimeMillis() > 0l){
        dataSource.setMinEvictableIdleTimeMillis(properties.getMinEvictableIdleTimeMillis());
    }
    dataSource.setValidationQuery(properties.getValidationQuery());
    dataSource.setTestOnReturn(properties.getTestOnReturn());
    dataSource.setTestOnBorrow(properties.isTestOnBorrow());
    dataSource.setTestWhileIdle(properties.getTestWhileIdle());
    dataSource.setPoolPreparedStatements(properties.getPoolPreparedStatements());
    dataSource.setConnectProperties(properties.getConnectionProperties());
    try {
        dataSource.setFilters(properties.getFilters());
    } catch (SQLException e) {
        throw new IllegalArgumentException("please check your spring.datasource.druid.filters property.", e);
    }
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@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) {
        logger.error("druid configuration initialization filter", e);
    }
    datasource.setConnectionProperties(connectionProperties);

    return datasource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@ConfigurationProperties(prefix = "spring.datasource.master")
@Bean(name = "masterDataSource")
@Primary
public DataSource masterDataSource() {
    DruidDataSource dataSource = new DruidDataSource();
    try {
        dataSource.setFilters("stat,wall,log4j");
    } catch (SQLException e) {
        //
    }
    return dataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@ConfigurationProperties(prefix = "spring.datasource.cluster")
@Bean(name = "clusterDataSource")
public DataSource clusterDataSource() {
    DruidDataSource dataSource = new DruidDataSource();
    try {
        dataSource.setFilters("stat,wall,log4j");
        dataSource.setUseGlobalDataSourceStat(true);
    } catch (SQLException e) {
        //
    }
    return dataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
public DataSource mysqlDataSource() throws Exception{
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setUrl(this.url);
    druidDataSource.setUsername(this.username);
    druidDataSource.setPassword(this.password);
    druidDataSource.setDriverClassName(this.driverClassName);
    druidDataSource.setInitialSize(this.initialSize);
    druidDataSource.setMaxActive(this.maxActive);
    druidDataSource.setMinIdle(this.minIdle);
    druidDataSource.setMaxWait(this.maxWait);
    druidDataSource.setTimeBetweenEvictionRunsMillis(this.timeBetweenEvictionRunsMillis);
    druidDataSource.setMinEvictableIdleTimeMillis(this.minEvictableIdleTimeMillis);
    druidDataSource.setValidationQuery(this.validationQuery);
    druidDataSource.setTestWhileIdle(this.testWhileIdle);
    druidDataSource.setTestOnBorrow(this.testOnBorrow);
    druidDataSource.setTestOnReturn(this.testOnReturn);
    druidDataSource.setPoolPreparedStatements(this.poolPreparedStatements);
    druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(this.maxPoolPreparedStatementPerConnectionSize);
    druidDataSource.setFilters(this.filters);
    try {
        druidDataSource.setFilters("wall,stat");
        druidDataSource.setUseGlobalDataSourceStat(true);
        druidDataSource.init();
    } catch (Exception e) {
        throw new RuntimeException("load datasource error, dbProperties is :", e);
    }
    return druidDataSource;
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
public void init() throws Exception{  
    System.out.println("**************init"); 
    MicroMetaDao dao=MicroMetaDao.getInstance();
    String sql="select * from nh_micro_dbconf";
    List<Map<String,Object>> infoList=dao.queryObjJoinByCondition(sql);
    for(Map<String,Object> row:infoList){
    	String metaKey=(String) row.get("meta_key");
    	String dataSourceClassName=(String) row.get("datasource_classname");
    	String dbUser=(String) row.get("db_user");
    	String dbPassWord=(String) row.get("db_password");
    	if(dbPassWord.startsWith("nhjm-")){
    		String temp=dbPassWord.substring(5);
    		dbPassWord=DESUtil.decrypt(temp);
    	}
    	String dbUrl=(String) row.get("db_url");
    	DruidDataSource ds=new DruidDataSource();
    	ds.setUsername(dbUser);
    	ds.setPassword(dbPassWord);
    	ds.setUrl(dbUrl);
    	ds.setFilters("stat");
    	ds.setMaxActive(10);
    	ds.setInitialSize(1);
    	ds.setMaxWait(60000);
    	ds.setMinIdle(1);
    	ds.setTimeBetweenEvictionRunsMillis(60000);
    	ds.setMinEvictableIdleTimeMillis(60000);
    	ds.setValidationQuery("SELECT 'x'");
    	ds.setTestWhileIdle(true);
    	ds.setTestOnBorrow(false);
    	ds.setTestOnReturn(false);
    	ds.setPoolPreparedStatements(true);
    	ds.setMaxPoolPreparedStatementPerConnectionSize(10);
    	ds.setDriverClassName(dataSourceClassName);
    	ds.init();
    	JdbcTemplate jdbcTemplate=new JdbcTemplate();
    	jdbcTemplate.setDataSource(ds);
    	MicroDbHolder.getDbHolder().put(metaKey, jdbcTemplate);
    }
}
 

import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean
@Primary
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) {
    logger.error("druid configuration initialization filter", e);
  }
  datasource.setConnectionProperties(connectionProperties);

  return datasource;
}