¹¦ÄÜÍêÉƵÄJavaÁ¬½Ó³Øµ÷ÓÃʵÀý

/**
* Title: ConnectPool.java
* Description: Á¬½Ó³Ø¹ÜÀíÆ÷
* Copyright: Copyright (c) 2002/12/25
* Company:
* Author :
* Version 2.0
*/
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/**
* ¹ÜÀíÀàDBConnectionManagerÖ§³Ö¶ÔÒ»¸ö»ò¶à¸öÓÉÊôÐÔÎļþ¶¨ÒåµÄÊý¾Ý¿âÁ¬½Ó
* ³ØµÄ·ÃÎÊ.¿Í»§³ÌÐò¿ÉÒÔµ÷ÓÃgetInstance()·½·¨·ÃÎʱ¾ÀàµÄΨһʵÀý.
*/
public class ConnectPool
{
static public ConnectPool instance; // ΨһʵÀý
static public int clients;
public Vector drivers = new Vector(); //Çý¶¯
public PrintWriter log;
public Hashtable pools = new Hashtable(); //Á¬½Ó
/**
* ·µ»ØΨһʵÀý.Èç¹ûÊǵÚÒ»´Îµ÷Óô˷½·¨,Ôò´´½¨ÊµÀý
*
* @return DBConnectionManager ΨһʵÀý
*/
static synchronized public ConnectPool getInstance()
{
if (instance == null)
{
instance = new ConnectPool();
}
clients++;
return instance;
}
/**
* ½¨¹¹º¯Êý˽ÓÐÒÔ·ÀÖ¹ÆäËü¶ÔÏó´´½¨±¾ÀàʵÀý
*/
public ConnectPool() {
init();
}
/**
* ½«Á¬½Ó¶ÔÏ󷵻ظøÓÉÃû×ÖÖ¸¶¨µÄÁ¬½Ó³Ø
*
* @param name ÔÚÊôÐÔÎļþÖж¨ÒåµÄÁ¬½Ó³ØÃû×Ö
* @param con Á¬½Ó¶ÔÏó
*/
public void freeConnection(String name, Connection con)
{
DBConnectionPool pool = (DBConnectionPool) pools.get(name);
if (pool != null)
{
pool.freeConnection(con);
}
else
{
System.out.println("pool ==null");
}
clients--;
}
/**
* »ñµÃÒ»¸ö¿ÉÓõÄ(¿ÕÏеÄ)Á¬½Ó.Èç¹ûûÓпÉÓÃÁ¬½Ó,ÇÒÒÑÓÐÁ¬½ÓÊýСÓÚ×î´óÁ¬½ÓÊý
* ÏÞÖÆ,Ôò´´½¨²¢·µ»ØÐÂÁ¬½Ó
*
* @param name ÔÚÊôÐÔÎļþÖж¨ÒåµÄÁ¬½Ó³ØÃû×Ö
* @return Connection ¿ÉÓÃÁ¬½Ó»ònull
*/
public Connection getConnection(String name)
{
DBConnectionPool pool = (DBConnectionPool) pools.get(name);
if (pool != null)
{
//return pool.getConnection();
return pool.returnConnection();
}
return null;
}
/**
* »ñµÃÒ»¸ö¿ÉÓÃÁ¬½Ó.ÈôûÓпÉÓÃÁ¬½Ó,ÇÒÒÑÓÐÁ¬½ÓÊýСÓÚ×î´óÁ¬½ÓÊýÏÞÖÆ,
* Ôò´´½¨²¢·µ»ØÐÂÁ¬½Ó.·ñÔò,ÔÚÖ¸¶¨µÄʱ¼äÄڵȴýÆäËüÏß³ÌÊÍ·ÅÁ¬½Ó.
*
* @param name Á¬½Ó³ØÃû×Ö
* @param time ÒÔºÁÃë¼ÆµÄµÈ´ýʱ¼ä
* @return Co