标准连接池的实现

来源：互联网发布：手机怎样关闭淘宝店铺编辑：程序博客网时间：2024/04/28 14:59

package com.mysql.utils;

import java.io.PrintWriter;
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.sql.SQLFeatureNotSupportedException;
import java.util.LinkedList;
import java.util.logging.Logger;

import javax.sql.DataSource;

public class DatabaseSource implements DataSource {
// 声明一个池管理对象
private LinkedList pool = new LinkedList();
// 在初始化这个类子类时在构造方法中实现设置多个连接
public DatabaseSource() {
  try {
   Class.forName("com.mysql.jdbc.Driver");
   String url ="jdbc:mysql://127.0.0.1:1306/mydb1?useUnicode=true&characterEncoding=UTF-8";
   for (int i =0; i < 3; i++) {
    finalConnection conn = DriverManager.getConnection(url,
      "root","root");

    ObjectproxyConn = Proxy.newProxyInstance(
      DatabaseSource.class.getClassLoader(),
      newClass[]{Connection.class}, new InvocationHandler() {

       publicObject invoke(Object proxy, Method method,
         Object[]args) throws Throwable {
        if(method.getName().equals("close")) {
         synchronized(pool) {
          pool.addLast((Connection)proxy);
          pool.notify();
         }
         returnnull;
        }
        ObjectreturnValue = method.invoke(conn, args);
        returnreturnValue;
       }
      });

    //放入连接池
    pool.add((Connection)proxyConn);
   }
  } catch (ClassNotFoundExceptione) {
   e.printStackTrace();
  } catch (SQLException e){
   e.printStackTrace();
  } finally {

}
}

public Connection getConnection() throwsSQLException {
  synchronized (pool) {
   if(pool.size() == 0) {
    try{
     pool.wait();
    }catch (InterruptedException e) {
     e.printStackTrace();
    }
    returngetConnection();
   }
   returnpool.removeFirst();
  }
}

@Override
public PrintWriter getLogWriter() throwsSQLException {
// TODO Auto-generated methodstub
return null;
}

@Override
public void setLogWriter(PrintWriter out) throwsSQLException {
// TODO Auto-generated methodstub

}

@Override
public void setLoginTimeout(int seconds) throwsSQLException {
// TODO Auto-generated methodstub

}

@Override
public int getLoginTimeout() throws SQLException{
// TODO Auto-generated methodstub
return 0;
}

@Override
public Logger getParentLogger() throwsSQLFeatureNotSupportedException {
// TODO Auto-generated methodstub
return null;
}

@Override
public T unwrap(Class iface) throws SQLException{
// TODO Auto-generated methodstub
return null;
}

@Override
public boolean isWrapperFor(Class

0 0