数据源配置类

首页 > 代码库 > 数据源配置类

2024-10-18 10:28:39 211人阅读

package com.ustcinfo.hibernate.dbSourseConfig;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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 org.springframework.context.annotation.PropertySource;

import com.alibaba.druid.pool.DruidDataSource;

/**
 * 数据源配置类
 */
@Configuration
@PropertySource("classpath:datasource.properties") // 选择配置文件的来源
public class DruidDBConfig {

private static Logger LOG_DB = LoggerFactory.getLogger(DruidDBConfig.class);

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

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

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

@Value("${spring.datasource.driverClassName}")
	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(name = "dataSource") // 声明其为Bean实例
	@Primary // 在同样的DataSource中，首先使用被标注的DataSource
	public DataSource dataSource() {

DruidDataSource datasource = new DruidDataSource();

datasource.setUrl(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.setTestWhileIdle(testWhileIdle);
		datasource.setTestOnBorrow(testOnBorrow);
		datasource.setTestOnReturn(testOnReturn);
		datasource.setPoolPreparedStatements(poolPreparedStatements);
		datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
		try {
			datasource.setFilters(filters);
		} catch (SQLException e) {
			LOG_DB.error("druid configuration initialization filter", e);
		}
		datasource.setConnectionProperties(connectionProperties);

return datasource;
	}
}

数据源配置类

声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉：投诉/举报工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。

联系
我们

首页 > 代码库 > 数据源配置类

数据源配置类

看完仍有疑问？有类似问题直接问程序猿