databaseutility.java

采用JAVA开发

/*
 * Created on 2004-7-29
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.gctech.misc.util;

import java.sql.Connection;
import java.sql.DriverManager;

import javax.naming.Context;
import javax.naming.InitialContext;

/**
 * <p>Title:</p>
 * <p>Description:</p>
 * <p>Copyright: Copyright (c) Gctech 2004-7-29</p>
 * <p>Company: 吉芙德资讯有限公司</p>
 *
 * @version 1.0
 * @author liyi
 *
 */
public class DataBaseUtility {
	/**
	 * 从连接池获取数据库连接
	 * 
	 * @return
	 */
	public static Connection getConnection() {
		Connection conn = null;
		try {
			Context initCtx = new InitialContext();
			Context ctx = (Context) initCtx.lookup("java:comp/env");
			//获取连接池对象
			Object obj = (Object) ctx.lookup("jdbc/OracleDB");
			//类型转换
			javax.sql.DataSource ds = (javax.sql.DataSource) obj;
			conn = ds.getConnection();
			return conn;
		} catch (Exception e) {
			System.out.println("::无法从数据源获得数据库连接::");
//			e.printStackTrace();
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.12.2:1521:NINECARD", "sms", "sms");
			} catch (Exception ex) {
				System.out.println("::无法获得数据库连接::");
				ex.printStackTrace();
			}
			return conn;
		}
	}

}