final private static String driverName = "oracle.jdbc.driver.OracleDriver";
    private static String url;
    final private static String server = "127.0.0.1";
    final private static String port = "8080";
    final private static String sid = "apex";
    final private static String username = "FILMS";// имя workspace и username
    final private static String password = "admin";//workspace  пароль
    private static Connection connection;
    private static boolean isConnected = false;
    private static boolean connect() {
    try {
        url = "jdbc:oracle:thin:@" + server + ":" + port + ":" + sid;
        System.out.println(url);
        Class.forName(driverName);
        connection = DriverManager.getConnection(url, username, password);
        System.out.println("connecting: " + url);
        if(connection.equals(null))
            isConnected = false;
        else
            isConnected = true;
    } catch (ClassNotFoundException e) {
        System.out.println("ClassNotFoundException");
        isConnected = false;
    } catch (SQLException e) {
        System.out.println("SQLException\n" + e.getMessage());
        System.out.println("ErrorCode: "  +   e.getErrorCode());
        System.out.println("StackTrace: " + e.getStackTrace());
        isConnected = false;
    }

import java.sql.*;
import java.util.Locale;
public class JDBCExample {
    final private static String driverName = "oracle.jdbc.driver.OracleDriver";
    private static String url;
    final private static String server = "localhost";
    final private static String port = "1521";
    final private static String sid = "XE";
    final private static String username = "system";
    final private static String password = "admin";
    private static Connection connection;
    private static boolean isConnected = false;
    private static boolean connect() {
    try {
        url = "jdbc:oracle:thin:@" + server + ":" + port + ":" + sid;
        System.out.println(url);
        Class.forName(driverName);
        Locale.setDefault(Locale.ENGLISH);
        connection = DriverManager.getConnection(url, username, password);
        System.out.println("connecting: " + url);
        if(connection.equals(null))
            isConnected = false;
        else
            isConnected = true;
    } catch (ClassNotFoundException e) {
        System.out.println("ClassNotFoundException");
        isConnected = false;
    } catch (SQLException e) {
        System.out.println("SQLException\n" + e.getMessage());
        isConnected = false;
    }
    return isConnected;
    }
    public static void main(String[] args) {
        if (connect()) System.out.println("connected");
         else System.out.println("not connected");
    }
}