private void programmatiesVoorBepaaldeBioscoopTussenTweeDatums() throws SQLException
    {
        BioscoopDAO bioscoopDAO = new BioscoopDAO(connection);
        List<Bioscoop> bioscopen = bioscoopDAO.all();

        System.out.printf("%-2s | ", "ID");
        System.out.printf("%-20s | ", "Naam");
        System.out.printf("%-20s | ", "Straat");
        System.out.printf("%-8s | ", "Postcode");
        System.out.printf("%s \n", "Gemeente");

        System.out.printf("%-2s | ", "");
        System.out.printf("%-20s | ", "");
        System.out.printf("%-20s | ", "");
        System.out.printf("%-8s | ", "");
        System.out.printf("%s \n", "");

        for (Bioscoop bioscoop : bioscopen)
        {
            System.out.printf("%-2d | ", bioscoop.getId());
            System.out.printf("%-20s | ", bioscoop.getNaam());
            System.out.printf("%-20s | ", bioscoop.getStraat());
            System.out.printf("%-8s | ", bioscoop.getPostcode());
            System.out.printf("%-20s\n", bioscoop.getGemeente());
        }

        System.out.println();

        System.out.print("Bioscoop (ID uit lijst): ");
        int bioscoop = Integer.parseInt(scanner.nextLine());

        while (bioscoop == 0 || bioscoop > bioscoopDAO.lastId())
        {
            System.out.println("Kan ID niet vinden.");
            System.out.print("Bioscoop (ID uit lijst): ");
            bioscoop = Integer.parseInt(scanner.nextLine());
        }

        System.out.print("Begindatum (yyyy-mm-dd): ");
        Date beginDatum = Date.valueOf(scanner.nextLine());

        System.out.print("Einddatum (yyyy-mm-dd): ");
        Date eindDatum = Date.valueOf(scanner.nextLine());

        System.out.println();

        ProgrammatieDAO programmatieDAO = new ProgrammatieDAO(connection);
        List<Programmatie> programmaties = programmatieDAO.whereBioscoopAndDateBetween(bioscoop, beginDatum, eindDatum);

        System.out.printf("%-10s | ", "Datum");
        System.out.printf("%-8s | ", "Uur");
        System.out.printf("%-20s | ", "Bioscoop");
        System.out.printf("%-7s | ", "ZaalNr.");
        System.out.printf("%s \n", "Film");

        System.out.printf("%-10s | ", "");
        System.out.printf("%-8s | ", "");
        System.out.printf("%-20s | ", "");
        System.out.printf("%-7s | ", "");
        System.out.printf("%s \n", "");

        for (Programmatie programmatie : programmaties)
        {
            System.out.printf("%-10s | ", programmatie.getDatum());
            System.out.printf("%-8s | ", programmatie.getBeginUur());
            System.out.printf("%-20s | ", programmatie.getZaal().getBioscoop().getNaam());
            System.out.printf("%-7d | ", programmatie.getZaal().getZaalNr());
            System.out.printf("%s \n", programmatie.getFilm().getNaam());
        }

        System.out.println();
    }