本文共 2251 字，大约阅读时间需要 7 分钟。

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;    }}

转载地址：http://uugai.baihongyu.com/