Oracle的连接工具类

package com.it;


import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;


public class OracleUtilsConfig {


/*
*  编写数据库连接的工具类
*  获取连接对象采用读取配置文件方式
*  读取文件获取连接,执行一次,static{}
*/

private static Connection con ;
private static String driverClass;
private static String url;
private static String username;
private static String password;

static{
try{
readConfig();
Class.forName(driverClass);
con = DriverManager.getConnection(url, username, password);
}catch(Exception ex){
throw new RuntimeException("数据库连接失败");
}
}

private static void readConfig()throws Exception{
InputStream in = OracleUtilsConfig.class.getClassLoader().getResourceAsStream("database.properties");
Properties pro = new Properties();
pro.load(in);
driverClass=pro.getProperty("driverClass");
url = pro.getProperty("url");
username = pro.getProperty("username");
password = pro.getProperty("password");
}

public static Connection getConnection(){
return con;
}

}

driverClass=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@192.168.80.10:1521:orcl
username=wateruser
password=itcast