DRIVER = oracle.jdbc.driver.OracleDriverURL = jdbc:oracle:thin:@localhost:1521:orcl4372USER = scottPASSWORD =m123

package com.yiwei.util;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;public class OracleConnect {    public static String DRIVER = null ;    public static String URL    = null;    public static String USER   = null ;    public static String  PASSWORD  = null;        static    {        Properties properties = null;        InputStream inputStream = null;                 try {            inputStream = ClassLoader.getSystemResourceAsStream("com/yiwei/util/Oracledbinfo.properties");            properties = new Properties();            properties.load(inputStream);                        DRIVER   = properties.getProperty("DRIVER");            URL      = properties.getProperty("URL");            USER     = properties.getProperty("USER");            PASSWORD = properties.getProperty("PASSWORD");                    } catch (Exception e) {            throw new RuntimeException("数据库属性加载异常!");        }finally{            try {                if(inputStream != null ){                    inputStream.close();                    inputStream = null;                }            } catch (IOException e) {                e.printStackTrace();            }        }                try {            Class.forName(DRIVER);        } catch (Exception e) {            throw new RuntimeException("数据库驱动加载异常!");        }    };          /**       * 获取连接       * @return Oracle的Connection的实例       */      public static Connection getOracleConnection(){          Connection ct = null;                try {            ct = DriverManager.getConnection(URL,USER,PASSWORD);        } catch (SQLException e) {            throw new  RuntimeException("获取数据库连接异常!");        }        return ct;      };            /**       * 关闭数据库资源       * @param rs resultSet对象       * @param sm statement对象 preparedStatement对象 callableSatement对象       * @param ct connection对象       */      public static void close(ResultSet rs, Statement sm,Connection ct){          try {              if(rs != null){rs.close();rs = null;}              if(sm != null){sm.close();sm = null;}              if(ct != null){ct.close();ct = null;}            } catch (SQLException e) {                throw new  RuntimeException("关闭数据库资源异常");            }      };       public static void main(String [] args)      {          new OracleConnect();          System.out.println(DRIVER+","+URL+","+USER+","+PASSWORD);      }
}