dbutils.java

创建中间企业对象层

package com.eshaper.appbuilder.database.utils;

import java.sql.*;
import com.eshaper.appbuilder.database.pool.DBConnectionPoolManager;

public final class DBUtils
{
	private static String connPoolName = "";
	
	private static DBConnectionPoolManager connPoolManager= null;
	
	static
	{
		try
		{	
			connPoolManager = DBConnectionPoolManager.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());
		}
	}
}