黑马 总结二：Java 数据连接池简单实现

一个简单的数据连接池的实现。作为程序员，每天都要和很多的池打交道，连接池，线程池等等。基本所有的池化概念都是有一个基本的理念

就是，把许多浪费资源的程序，在服务器初始化的时候一次性的创建并保存起来。最总达到程序的执行速度提高的目的。所以，池化的概念是一个程序员的基本概念。

package com.skycn.database; import java.io.IOException; import java.io.InputStream; import java.lang.reflect.InvocationHandler; import java.lang.reflect.Method; import java.lang.reflect.Proxy; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.LinkedList; import java.util.Properties; public class DateSource { //private static ThreadLocal<Connection> local = new ThreadLocal<Connection>(); private LinkedList<Connection> list = new LinkedList<Connection>(); private static DateSource source = new DateSource(); private String DRIVER; private String URL; private String USER; private String PASSWORD; private int MAX; private int INIT; private int count = 0; @SuppressWarnings("unused") private static DateSource newInstance() { return source; } private DateSource() { init(); } private void init() { InputStream in = DateSource.class.getClassLoader().getResourceAsStream( "DateSource.properties"); Properties properties = new Properties(); try { properties.load(in); DRIVER = properties.getProperty("DRIVER"); URL = properties.getProperty("URL"); USER = properties.getProperty("USER"); PASSWORD = properties.getProperty("PASSWORD"); MAX = Integer.parseInt(properties.getProperty("MAX")); INIT = Integer.parseInt(properties.getProperty("INIT")); for (int i = 0; i < INIT; i++) { try { createConnection(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public Connection getConnection() { synchronized (list) { if ((list.size() == 0) && (count <= MAX)) { try { createConnection(); return list.remove(); } catch (SQLException e) { e.printStackTrace(); } } return list.remove(); } } @SuppressWarnings("unused") private void createConnection() throws SQLException { try { Class.forName(DRIVER); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } final Connection con = DriverManager.getConnection(URL, USER, PASSWORD); final Connection proxyCon = (Connection) Proxy.newProxyInstance(DateSource.class .getClassLoader(), new Class[] { Connection.class }, new InvocationHandler() { public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { if (method.getName().equals("close")) { close((Connection) proxy); return null; } return method.invoke(con, args); } }); list.add(proxyCon); count++; } private void close(Connection con) { list.add(con); } }