c3p0连接池(二)
2014-11-24 07:55:41
?
作者:
?
浏览: 4
atch(Exception e){
System.out.println("初始化数据库连接池异常,name:"+(name!=null name:"null"));
e.printStackTrace();
}
}
}
res = null;
configDoc = null;
}
/**
* 获取数据库连接
* @param name
* @return
* @throws SQLException
*/
public synchronized Connection getConnection(String name) throws SQLException{
ComboPooledDataSource pool = pools.get(name);
if(pool!=null){
return pool.getConnection();
}else{
System.out.println("不存在的数据源名称：" + name);
}
return null;
}
/**
* String转成int,如果异常则返回默认值
* @param value
* @param defaultValue
* @return
*/
private int string2int(String value,int defaultValue){
if(value==null)
return defaultValue;
try{
return Integer.parseInt(value);
}catch(NumberFormatException e){
System.out.println("String转成int时异常,value:"+value);
return defaultValue;
}
}
}
二、配置文件示例
< xml version="1.0" encoding="UTF-8" >
mysql.jdbc.Driver"
username="root" password="root"
jdbcUrl="jdbc:mysql://127.0.0.1:3306/nms useUnicode=true&characterEncoding=utf-8"
initialPoolSize="5" minPoolSize="3" maxPoolSize="20" acquireIncrement="3"
maxIdleTime="120" idleConnectionTestPeriod="120" checkoutTimeout="1000"/>
三、main测试
public static void main(String[] args) {
ConnPoolManager.getInstance().initial("d:/dbConfig.xml");
Connection conn = ConnPoolManager.getInstance().getConnection("jdbc/nms");
}