常用连接池 Hikari和druid

package org.hu.jdbc.pool;

import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

import javax.sql.DataSource;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Properties;

public class PoolDemo {
//DataSource ds=null;
private static HikariDataSource dataSource=null;
private static DataSource druiddataSource=null;

public static void main(String[] args) throws Exception {
//System.out.println(getProp("src/main/resources/db.properties").getProperty("mysql.url"));
System.out.println(getDS().getConnection());
}

public static DataSource getDruiddataSource() throws Exception {
if (druiddataSource != null) {
return druiddataSource;
} else {
Properties prop = getProp("src/main/resources/db.properties");
String durl = prop.getProperty("mysql.url");
String duser = prop.getProperty("mysql.user");
String dpwd = prop.getProperty("mysql.pwd");

druiddataSource = DruidDataSourceFactory.createDataSource(prop);
return druiddataSource;
}
}
public static DataSource getDS() throws IOException {
if (dataSource != null) {
return dataSource;
} else {
Properties prop = getProp("src/main/resources/db.properties");
String durl = prop.getProperty("mysql.url");
String duser = prop.getProperty("mysql.user");
String dpass = prop.getProperty("mysql.pwd");
HikariConfig config = new HikariConfig();
config.setJdbcUrl(durl);
config.setUsername(duser);
config.setPassword(dpass);
dataSource = new HikariDataSource(config);
return dataSource;
}
}

public static Properties getProp(String durl) throws IOException {
Properties prop = new Properties();
FileInputStream fin=new FileInputStream(new File(durl));
prop.load(fin);

return prop;
}

}