Oracle链接工具类OJDBC

title: Oracle链接工具类OJDBC
date: 2018-1-29 21:56:20
categories: Utils
tags: Utils

---

xl_echo编辑整理，欢迎转载，转载请声明文章来源。更多案例、资料请联系QQ：1280023003

OJDBCUtils源码

• 使用JDBCUtils时需要导入一个包：ojdbc14.jar

package com.echo.ojdbc.waterboss.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 基本数据访问类（获取数据库链接，关闭资源）
 * @author Administrator
 *
 */
public class BaseDao {

    static {
        //加载驱动
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取数据库链接
     * @return
     * @throws SQLException
     */
    public static Connection getConnection() throws SQLException{

        Connection conn = DriverManager.getConnection("jdbc:oracle:thin@192.168.159.10:1521:orcl","wateruser","xlsorry");
        return conn;

    }

    /**
     * 关闭连接资源
     * @param rs
     * @param stat
     * @param conn
     */
    public static void closeAll(ResultSet rs, Statement stat, Connection conn){
        if(rs != null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if(stat != null){
            try {
                stat.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if(conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}