package oracle;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class ConnectOracle {

	protected static String driver;
	protected static String url;
	protected static String username;
	protected static String password;
	public static Connection connection;

	public static void connect() {
		Properties properties = new Properties();
		try {
			properties.load(new FileInputStream("c://oracle.properties"));
	        url = "jdbc:oracle:thin:@" + properties.getProperty("jdbc.server") 
	        		+ ":" + properties.getProperty("jdbc.port") + ":" 
	        		+ properties.getProperty("jdbc.sid");
			driver = properties.getProperty("jdbc.driver");
			username = properties.getProperty("jdbc.username");
			password = properties.getProperty("jdbc.password");
			Class.forName("oracle.jdbc.driver.OracleDriver");
	      	connection = DriverManager.getConnection(url, username, password);
	      	
		} catch (IOException | ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}
	}
	
}