Java 資料庫連接 讀取properties檔案

標籤：style   blog   color   io   os   ar   java   for   sp   

Oracledbinfo.properties

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

OracleConnect.java

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

 

Java 資料庫連接 讀取properties檔案