复件 dbutils.java

创建中间企业对象层

/*
 * $Header: com.ca.eportal.db.DBUtils.java $
 * $Author: IGLOBEX $
 * $Revision: 1.0 $
 * $Date: 2003/12/30 12:00:00 $
 * $UpdateBy: zhaobin $
 */
package com.kyle.eobject;

import java.sql.*;
import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;


public final class DBUtils{

	private static DataSource ds = null;
	
	static{
		try
		{	
			Context initCtx = new InitialContext();
     		Context envCtx = (Context) initCtx.lookup("java:comp/env");
     		ds = (DataSource)envCtx.lookup("jdbc/eportaldb");
		}
		catch (Exception e)
		{
			System.out.println("DBUtils内部错误:系统不能装载数据源: "+e.getMessage());
		}
	}
	
	public DBUtils(){}
	
	public static Connection getConnection() throws Exception{
		try{
			Connection connection = null;
			connection = ds.getConnection();
			return connection;
		}catch(Exception e){
			throw new Exception("DBUtils内部错误:系统不能取得连接: "+e.getMessage());
		}
	}

}