oralce 数据库jdbc配置类

来源：互联网发布：淘宝app抢购需要刷新吗编辑：程序博客网时间：2024/06/07 07:14
package myUtil; import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement; /** * 链接oracle数据库 * @author tanrt */public class OracleDbManager {    private static final String URL = "jdbc:oracle:thin:@//localhost:1521/lseas";    private static final String USER = "username";    private static final String PASSWORD = "password";     static {        try {            Class.forName("oracle.jdbc.OracleDriver");        } catch (ClassNotFoundException e) {            System.out.println("加载Oracle数据库驱动失败！");        }    }     /**     * 获取Connection     *      * @return     * @throws SQLException     * @throws ClassNotFoundException     */    public static Connection getConnection() throws SQLException {        Connection conn = null;        try {            conn = DriverManager.getConnection(URL, USER, PASSWORD);        } catch (SQLException e) {            System.out.println("获取数据库连接失败！");            throw e;        }        return conn;    }         /**     * 关闭ResultSet     * @param rs     */    public static void closeResultSet(ResultSet rs) {        if (rs != null) {            try {                rs.close();            } catch (SQLException e) {                System.out.println(e.getMessage());            }        }    }         /**     * 关闭Statement     * @param stmt     */    public static void closeStatement(Statement stmt) {        if (stmt != null) {            try {                stmt.close();            }                   catch (Exception e) {                System.out.println(e.getMessage());            }        }    }         /**     * 关闭ResultSet、Statement     * @param rs     * @param stmt     */    public static void closeStatement(ResultSet rs, Statement stmt) {        closeResultSet(rs);        closeStatement(stmt);    }         /**     * 关闭PreparedStatement     * @param pstmt     * @throws SQLException     */    public static void fastcloseStmt(PreparedStatement pstmt) throws SQLException    {        pstmt.close();    }         /**     * 关闭ResultSet、PreparedStatement     * @param rs     * @param pstmt     * @throws SQLException     */    public static void fastcloseStmt(ResultSet rs, PreparedStatement pstmt) throws SQLException    {        rs.close();        pstmt.close();    }         /**     * 关闭ResultSet、Statement、Connection     * @param rs     * @param stmt     * @param con     */    public static void closeConnection(ResultSet rs, Statement stmt, Connection con) {        closeResultSet(rs);        closeStatement(stmt);        closeConnection(con);    }         /**     * 关闭Statement、Connection     * @param stmt     * @param con     */    public static void closeConnection(Statement stmt, Connection con) {        closeStatement(stmt);        closeConnection(con);    }         /**     * 关闭Connection     * @param con     */    public static void closeConnection(Connection con) {        if (con != null) {            try {               con.close();            }            catch (Exception e) {                System.out.println(e.getMessage());            }        }    }}
阅读全文
0 0