不用框架时想用数据库连接池的工具类和配置


#连接超时
connectionTimeout=60000
#生效超时
validationTimeout=60000
#闲置超时
idleTimeout=60000
#最大的生命时间
maxLifetime=600000000
#最大的缓冲池大小
username=root
password=chaoxinghenan
initializationFailTimeout=6000
connectionTestQuery=SELECT 1
driverClassName=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://127.0.0.1:3306/pbl?useUnicode=true&characterEncoding=UTF-8&useSSL=true

  代码:

import com.zaxxer.hikari.HikariDataSource;

public class PblHikariCPDataSource {

	public static PblHikariCPDataSource getInstance() {
		return instance;
	}

	private HikariDataSource dataSource;

	public HikariDataSource getDataSource() {
		synchronized (this) {
			if (dataSource == null) {
				// 初始化数据连接池
				String path = Thread.currentThread().getContextClassLoader().getResource("hikariCP.properties")
						.getPath();
				System.setProperty("hikaricp.configurationFile", path);
				dataSource = new HikariDataSource();
			}
			return dataSource;
		}
	}

	private PblHikariCPDataSource() {
	}

	private static final PblHikariCPDataSource instance = new PblHikariCPDataSource();
}

相关