java链接池实现测试类
package com.siven.connpool.test;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.xml.parsers.ParserConfigurationException;

import org.xml.sax.SAXException;

import com.siven.connpool.ConnectionPool;

public class ConnPoolTest {

ConnectionPool connPool = null;

public static void main(String args[]) throws ClassNotFoundException, SQLException, SAXException, IOException, ParserConfigurationException, InstantiationException, IllegalAccessException{
ConnPoolTest cpt=new ConnPoolTest();

cpt.test();
}

public void test() throws ClassNotFoundException, SQLException, SAXException, IOException, ParserConfigurationException, InstantiationException, IllegalAccessException{

connPool = ConnectionPool.getInstance();
System.out.println("原始链接数： "+connPool.getFreeConnections().size());
Connection conn = connPool.getConnection();
System.out.println("获得一个链接后的链接数： "+connPool.getFreeConnections().size());
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select d.rowid,d.* from security_log_for_hostdevice d where 1=1 and rownum<6");
while(rs.next()){
System.out.println(rs.getString("ID"));
}
connPool.freeConnection(conn);
System.out.println("用完之后归还的链接数： "+connPool.getFreeConnections().size());
}

}