Java DB Conn Pool

Java DB Conn Pool 是一个 Java 的数据库连接池组件。

使用示例代码：

public class TestPool
{
	public static void main (String[] args)
	{
		DataSource ds = null;
		//PrintWriter log = null; //uncomment to turn on logging
		try
		{
			//log = new PrintWriter(new FileWriter("dblog"), true); //uncomment to turn on logging
			Properties p = new Properties();
			p.setProperty("logLevel", "1"); //debug = 4, info = 3, warn = 2, error = 1, fatal = 0
			p.setProperty("autoCommit", "false");
			p.setProperty("description", "Oracle");
			p.setProperty("driverClass", "oracle.jdbc.driver.OracleDriver");
			p.setProperty("maxCount", "2");
			p.setProperty("minCount", "1");
			p.setProperty("user", "test");
			p.setProperty("password", "test");
			p.setProperty("url", "jdbc:oracle:thin:@127.0.0.1:1565:test");
			p.setProperty("loginTimeout", "0"); //in seconds
			p.setProperty("holdTimeout", "1000"); //in seconds
			p.setProperty("waitTimeout", "10000"); //in milliseconds
			p.setProperty("checkQuery", "select SYSDATE from dual");
			p.setProperty("statementCacheSize", "10");
			
			//ds = new RPDataSource(p, log); //use this instead of the next line to turn on logging
			ds = new RPDataSource(p);
			Connection con = ds.getConnection();
			Statement s = con.createStatement();
			ResultSet rs = s.executeQuery("select SYSDATE from dual");
			if (rs.next())
			{
				System.out.println (rs.getString(1));
			}
			rs.close();
			s.close();
			con.close();
			con = ds.getConnection();
			s = con.createStatement();
			rs = s.executeQuery ("select SYSDATE from dual");
			if (rs.next())
			{
				System.out.println (rs.getString(1));
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				RPDataSource rp = (RPDataSource)ds;
				rp.destroy();
			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
		}
	}
}