dbutils.java

创建中间企业对象层

package com.kyle.eobject;
import java.sql.*;


public final class DBUtils
{
	private static String connPoolName = "";
	
	private static KyleDBConnectionPoolManager connPoolManager= null;
	
	static
	{
		try
		{	
			connPoolManager = KyleDBConnectionPoolManager.getInstance();
			connPoolName = "sqltest";
		}
		catch (Exception e)
		{
			System.out.println("DBUtils内部错误:系统不能取得数据库连接池管理器: "+e.getMessage());
		}
	}
	
	public DBUtils(){}

	public static Connection getConnection() throws Exception
	{
		try
		{
			return connPoolManager.getConnection(connPoolName);
		}
		catch(Exception e)
		{
			throw new Exception("DBUtils内部错误:系统不能取得连接: "+e.getMessage());
		}
	}
	
	
	
	public static void freeConnection(Connection conn) throws Exception
	{
		try
		{
			connPoolManager.freeConnection(connPoolName,conn);
		}
		catch(Exception e)
		{
			throw new Exception("DBUtils内部错误:系统不能释放连接: "+e.getMessage());
		}
	}
	
	public static void closeConnection(Connection conn) throws Exception
	{
		try
		{
			freeConnection(conn);
		}
		catch(Exception e)
		{
			throw new Exception("DBUtils内部错误:系统不能关闭连接: "+e.getMessage());
		}
	}	
	
}