dbpoolutil.java

一个用java编写的服务器,对于学习网络编程的人来说是个很好的例子

/*
 * This file is part of the QuickServer library 
 * Copyright (C) 2003-2005 QuickServer.org
 *
 * Use, modification, copying and distribution of this software is subject to
 * the terms and conditions of the GNU Lesser General Public License. 
 * You should have received a copy of the GNU LGP License along with this 
 * library; if not, you can download a copy from <http://www.quickserver.org/>.
 *
 * For questions, suggestions, bug-reports, enhancement-requests etc.
 * visit http://www.quickserver.org
 *
 */

package echoserver;

import org.quickserver.net.*;
import org.quickserver.net.server.*;
import org.quickserver.sql.*;
import org.quickserver.util.xmlreader.*;

import java.io.*;
import java.util.logging.*;
import java.util.*;
import java.sql.*;

public class DBPoolUtil implements org.quickserver.sql.DBPoolUtil {
	private HashMap dbPool;

	public void setDatabaseConnections(Iterator iterator) 
			throws Exception {
		dbPool = new HashMap();
		while(iterator.hasNext()) {
			DatabaseConnectionConfig dcc = 
				(DatabaseConnectionConfig)iterator.next();
			dbPool.put(dcc.getId(), dcc);
		}
	}

	public boolean initPool() {
		if(dbPool==null)
			throw new IllegalStateException("Call setDatabaseConnections first.!!");
		Iterator iterator = dbPool.keySet().iterator();
		try {
			while(iterator.hasNext()) {
				DatabaseConnectionConfig dcc = (DatabaseConnectionConfig) 
					dbPool.get(	(String)iterator.next() );
				Class.forName(dcc.getDriver());
			}
			return true;
		} catch(Exception e) {
			System.err.println("In DBPoolUtil.initPool : "+e);
			return false;
		} 
	}

	public boolean clean() {
		dbPool = null;
		return true;
	}

	public Connection getConnection(String id) throws Exception {
		DatabaseConnectionConfig dcc = (DatabaseConnectionConfig) 
				dbPool.get(	id );
		return DriverManager.getConnection(dcc.getUrl(), dcc.getUsername(), 
			dcc.getPassword());
	}
}