自己开发的一个数据库连接池，包含代码，在oracle测试了一下，请各位对代码指正。
使用的方法如下：
1.在工程里面加入以下jar文件：mydatasource.jar,dom4j.jar,ojdbc14.jar
2.在工程目录任意位置放入连接池配置文件，如pool.xml,其内容如下：
<?xml version="1.0" encoding="UTF-8" ?>
<pools>
<pool name="default">
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<url>jdbc:oracle:thin:@192.168.1.7:1521:TESTDB</url>
<username>appuser</username>
<password>111111</password>
<maxPoolSize>1</maxPoolSize>
</pool>
<pool name="elite">
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<url>jdbc:oracle:thin:@192.168.1.151:1521:myDB</url>
<username>admin</username>
<password>admin</password>
<maxPoolSize>1</maxPoolSize>
</pool>
</pools>
public static void main(String[] args)
{
String conf = "/org/sky/proxy/pool.xml";
try
{
IConnectionPool pool = ConnectionPoolFactory.buildConnectionPoolFactory(conf).getConnectionPool("default");
IConnection conn = pool.getConnection();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from TB_EVENTS");
while(rs.next()){
System.out.println(rs.getString(1));
}
conn.close();
//pool.realseConnection(conn);
}
catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
