jdbc连接oracle数据库util,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);

}

}

}