jdbc

public class Main {

    public static void main(String[] args) {

        ConnectionDB connectionDB = new ConnectionDB();
        connectionDB.connect();

    }
}

--------------------------------
import java.sql.*;

public class ConnectionDB {
    static final String driver = "oracle.jdbc.driver.OracleDriver";
    static final String url = "jdbc:oracle:thin:@localhost:1521:orcle";

    static final String user = "evofint";
    static final String password = "EVOFINT";



    public static void connect() {
        Queries queries = new Queries();
        try {
            Class.forName(driver);
            Connection connection = DriverManager.getConnection(url, user, password);
            queries.queries(connection);
        } catch(ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

---------------------------------
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Queries {

public static void queries(java.sql.Connection connection) throws SQLException {
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery("select * from ADDRESSES");
    while(resultSet.next()) {
        String street = resultSet.getString("street_name");
        String house = resultSet.getString("house_number");

        System.out.println("Улица: " + street);
        System.out.println("Дом: " + house);
    }
}

}