// COMPILE:
// javac -cp mysql.jar MySQL.java

// RUN:
// java -cp mysql.jar:. MySQL

import java.sql.*; // STEP 1: Import required packages

public class MySQL {
    //  Database credentials
    static final String MYDB = "INDAD003Movies";
    static final String USER = "pulpm";
    static final String PASS = "fiction";

    // JDBC driver name and database URL
    static final String DB_URL = "jdbc:mysql://mydb.itu.dk/" + MYDB;

    public static void main(String[] args) {
    Connection connection = null;
    Statement statement = null;
    try {
        DriverManager.registerDriver(new com.mysql.jdbc.Driver()); // STEP 2: Register JDBC driver
        connection = DriverManager.getConnection(DB_URL, USER, PASS); // STEP 3: Open a connection
        statement = connection.createStatement(); // STEP 4: Execute a query

      System.out.println("Connection opened!");
      connection.close();

      System.out.println("Connection closed!");
    } catch(Exception e) { // handle errors:
        e.printStackTrace();
    }
    }
}