JDBC 单例实现类

package com.clpc.cc.util;

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

import org.apache.log4j.Logger;

public class DBUtils {

	private static Logger logger = Logger.getLogger(DBUtils.class);

	/**
	 * 初始化变量
	 */
	private String userName="";
	private String passWord="";
	private String url="";
	
	static Connection con = null;
	
	/*
	 * 初始化连接华为数据库数据库
	 */
	public DBUtils(){
//		System.out.println("Call Method : DBUtils!!");
		try{
			url = LoadPropertiesUtil.getJdbcValue("jdbc.url");
			userName = LoadPropertiesUtil.getJdbcValue("jdbc.username"); 
			passWord = LoadPropertiesUtil.getJdbcValue("jdbc.password");
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			con=DriverManager.getConnection(url, userName, passWord);
		}catch(Exception e){
			e.printStackTrace();
			logger.info("Link  DB url: "+url);
			logger.info("Link  username: "+ userName);
			logger.info("Link  password: "+passWord);
			logger.info("Link  DB Error!!");
		}
	}
	
	/**
	 * 创建调用连接AW1数据库的方法
	 */
	public static Connection getConnection(){
		try{
			new DBUtils();
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
	}

	/**
	 * 关闭数据库连接
	 */
	public static void closeConnection(){
		try {
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) {
		getConnection();
		System.out.println(getConnection());
	}
}

 

转载于:https://my.oschina.net/u/1024463/blog/801264