public static Connection connectDB() {
        Connection con = null;
        final String LOCATION = "localhost";
        final String PORT = "3306";
        final String dbNAME = "EsmoreitChristens";
        String usr = "root";
        String pass = "";

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try {
            con = DriverManager.getConnection("jdbc:mysql://" + LOCATION + ":" + PORT
            + "/" + dbNAME, usr, pass);
            System.out.println("Connection established");
        } catch (SQLException sqlExc) {
            System.out.println("Connection error");
            System.err.println(sqlExc);
        }
        return con;
    }

    public static String[] getConfiguraties() {
        Connection con = connectDB();
        ArrayList configuratieNamenStack = new ArrayList();
        String[] configuratieNamen = {""};
        try {
            Statement stmt = con.createStatement();
            String count = "SELECT COUNT(*) FROM configuraties WHERE `iLocation` = 0 AND `jLocation` = 0";
            String namen = "SELECT naam FROM configuraties WHERE `iLocation` = 0 AND `jLocation` = 0";
            int amount = 0;
            ResultSet a;
            // GET AMOUNT
            a = stmt.executeQuery(count);
            while (a.next()){
                amount = a.getInt(1);
                configuratieNamen = new String[amount];
            }
            // GET STRING[]
            a = stmt.executeQuery(namen);
            while(a.next()) {
                configuratieNamenStack.add(a.getString("naam"));
            }

        } catch (Exception excMySQL) {
            System.out.print(excMySQL);
        }
        if (configuratieNamenStack.size() > 0) {
            configuratieNamen = new String[configuratieNamenStack.size()];
            configuratieNamenStack.toArray(configuratieNamen);
        }
        return configuratieNamen;
    }