贴一个Oracle数据源的数据库连接公共类实例

公共类

package DAOHelp;

import java.sql.Connection;
import oracle.jdbc.pool.OracleDataSource;

public class DataBase {
	private static Connection conn = null;
	private static String SERVANDDB = "jdbc:oracle:thin:@192.168.2.7:1521:dogorcl";
	private static String USER = "crazy";
	private static String PWD = "apple";
	private static OracleDataSource ods=null;
	static {
		try {
			ods=new OracleDataSource();
			ods.setURL(SERVANDDB);
			ods.setUser(USER);
			ods.setPassword(PWD);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static Connection getConnection() {
		if (conn == null) {
			try {
				conn=ods.getConnection();
				if (conn.isClosed()) {
					conn=ods.getConnection();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return conn;
	}
}
 

使用方式：

import DAOHelp.DataBase;

public class test {

	public static void main(String[] args) {
		Connection conn = DataBase.getConnection();
		/*测试*/
		
		System.out.println("test");
	}
}