单例数据库连接池的创建

package com.csair.soc.shuffle;


import java.beans.PropertyVetoException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import com.mchange.v2.c3p0.ComboPooledDataSource;


public class SingleDbPool {
private volatile static SingleDbPool singleton;
private ComboPooledDataSource ds = new ComboPooledDataSource();


/** Oracle数据库连接URL */
private static String DB_URL;
/** Oracle数据库连接驱动 */
private final static String DB_DRIVER = "oracle.jdbc.OracleDriver";


/** 数据库用户名 */
private static String DB_USERNAME;
/** 数据库密码 */
private static String DB_PASSWORD;


private static void getProperties() {
// InputStream in = SingleDbPool.class.getClassLoader()
// .getResourceAsStream("czdemodbconfig.properties");
InputStream in = SingleDbPool.class.getClassLoader()
.getResourceAsStream("dbconfig.properties");
Properties properties = new Properties();
try {
properties.load(in);
// (加载文件)
} catch (IOException e) {
e.printStackTrace();
}
SingleDbPool.DB_URL = properties.getProperty("jdbcUrl");
SingleDbPool.DB_USERNAME = properties.getProperty("user");
SingleDbPool.DB_PASSWORD = properties.getProperty("password");
}


private SingleDbPool() {
try {
getProperties();
Properties prop = new Properties();
prop.setProperty("oracle.jdbc.V8Compatible", "true");
ds.setProperties(prop);
ds.setJdbcUrl(DB_URL);
ds.setUser(DB_USERNAME);
ds.setPassword(DB_PASSWORD);
ds.setMaxStatements(0);
ds.setDriverClass(DB_DRIVER);
ds.setMinPoolSize(1);
ds.setMaxPoolSize(2);
ds.setAcquireIncrement(1);
ds.setInitialPoolSize(1);
ds.setMaxIdleTime(60);


} catch (PropertyVetoException e) {
}


}


public static SingleDbPool getSingleton() {
if (singleton == null) {
synchronized (SingleDbPool.class) {
if (singleton == null) {
singleton = new SingleDbPool();
}
}
}
return singleton;
}


public static Connection getCon() {
try {
return getSingleton().ds.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
}