package com.minisay.base.util;
import java.sql.*;
/**
* @author xiaobu
* @version JDK1.8.0_171
* @date on 2018/10/17 17:22
* @descrption oracle数据库JDBC
*/
public class OJDBCUtils {
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String URL = "jdbc:oracle:thin:@localhost:1521:banjin";
private static final String USER = "banjin";
private static final String PASSWORD = "banjin2015";
/**
* 加载驱动程序
*/
static {
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
/**
* @return 连接对象
*/
public static Connection getConn() {
try {
return DriverManager.getConnection(URL, USER, PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 释放资源
*
* @param conn 连接对象
* @param preparedStatement 预编译对象
* @param rs 结果集
*/
public static void colseResource(Connection conn, PreparedStatement preparedStatement, ResultSet rs) {
closeResultSet(rs);
closeStatement(preparedStatement);
closeConnection(conn);
}
/**
* 释放连接 Connection
*
* @param conn 连接对象
*/
public static void closeConnection(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
//等待垃圾回收
conn = null;
}
/**
* 释放语句执行者 preparedStatement
*
* @param preparedStatement 预编译
*/
public static void closeStatement(PreparedStatement preparedStatement) {
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
//等待垃圾回收
preparedStatement = null;
}
/**
* 释放结果集 ResultSet
*
* @param rs
*/
public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
//等待垃圾回收
rs = null;
}
}
