Oracle JDBC DbUtil jdbc数据库连接

Oracle JDBC DbUtil jdbc数据库连接
1.OracleConnect.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package org.zxjy.cfgmanager.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import javax.swing.JOptionPane;
import org.openide.util.Exceptions;

/**
 * 建立数据库连接
 * 
 */
public class OracleConnect {
    final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
    
    private static OracleConnect instance = null;
    
    // 连接
    private Connection con;

    public Connection getCon() {
        return con;
    }

    public void setCon(Connection con) {
        this.con = con;
    }    
    
    public static synchronized OracleConnect getInstance() {
        if (instance == null) {
            instance = new OracleConnect();
        }
        return instance;
    }
    
    private OracleConnect() {
        ConfigLoader configLoader = ConfigLoader.getInstance();
        Properties p = configLoader.getP();
        String ip = p.getProperty("db_ip");
        String dsn = p.getProperty("db_dns");
        String userName = p.getProperty("db_user");
        String password = p.getProperty("db_username");
        String url = "jdbc:oracle:thin:@" + ip + ":1521:" + dsn;
        try {
            Class.forName(sDBDriver);
            con = DriverManager.getConnection(url, userName, password);
            con.setAutoCommit(false);
        } catch (SQLException e) {
            JOptionPane.showMessageDialog(null, "建立数据库连接失败！", "异常", JOptionPane.ERROR_MESSAGE);
            Exceptions.printStackTrace(e);
        } catch (ClassNotFoundException e) {
            JOptionPane.showMessageDialog(null, "未找到数据库驱动", "异常", JOptionPane.ERROR_MESSAGE);
            Exceptions.printStackTrace(e);
        }
    }
    
    public void closeConnection() {
        try {
            if(getCon() != null) {
                getCon().close();
            }
        } catch (SQLException e) {
            JOptionPane.showMessageDialog(null, "关闭数据库连接失败！", "异常", JOptionPane.ERROR_MESSAGE);
            Exceptions.printStackTrace(e);
        }
    }
}