Connecting to Oracle using Java JDBC

import java.util.*;
import java.sql.*;

public class OracleJdbcTest

{

    String driverClass = "oracle.jdbc.driver.OracleDriver";

    Connection con;

     

    public void init(FileInputStream fs) throws ClassNotFoundException, SQLException, FileNotFoundException, IOException

    {

        Properties props = new Properties();

        props.load(fs);

        String url = props.getProperty("db.url");

        String userName = props.getProperty("db.user");

        String password = props.getProperty("db.password");

        Class.forName(driverClass);

        con=DriverManager.getConnection(url, userName, password);

    }

     

    public void fetch() throws SQLException, IOException

    {

        PreparedStatement ps = con.prepareStatement("select SYSDATE from dual");

        ResultSet rs = ps.executeQuery();

         

        while (rs.next())

        {

            // YOUR LOGIC

        }

        rs.close();

        ps.close();

    }

    public static void main(String[] args)

    {

        OracleJdbcTest test = new OracleJdbcTest();

        test.init();

        test.fetch();

    }

}