import java.util.Map;
import java.util.HashMap;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.util.ArrayList;
import java.sql.SQLException;
import java.sql.DriverManager;

public class Database {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        System.out.println("Driver loaded.");

        ArrayList<String> options = new ArrayList<>();
        options.add("serverTimezone=UTC");

        Connection connection = DriverManager.getConnection("jdbc:mysql://" + config("host") + ":" + config("port") + "/" + config("name") + "?" + String.join("&", options), config("user"), config("pass"));
        System.out.println("Connection succeeded.");

        //

        Statement statement = connection.createStatement();

        ArrayList<String> queries = new ArrayList<>();
        queries.add("SELECT id, name FROM users");

        ResultSet r = statement.executeQuery(queries.get(0));

        /**
         * Displaying the records.
         */
        while (true) {
            if (!r.next()) {
                break;
            }

            System.out.println(r.getString(1) + "\t" + r.getString(2));
        }
    }

    public static String config(String key) {
        Map<String, String> config = new HashMap<>();
        config.put("host", "localhost");
        config.put("port", "8889");
        config.put("name", "database");
        config.put("user", "root");
        config.put("pass", "root");

        return config.containsKey(key) ? config.get(key) : null;
    }
}