Java 数据库连接 读取properties文件

Oracledbinfo.properties

DRIVER = oracle.jdbc.driver.OracleDriver
URL = jdbc:oracle:thin:@localhost:1521:orcl4372
USER = scott
PASSWORD =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);
      }
}

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。