public static List<Posudba<Casopis>> dohvatiPosudbe() throws Exception,
            NeisplativoObjavljivanjeException {
        Connection connection = connectToDatabase();
        List<Casopis> casopisi = dohvatiCasopise();
        List<Clan> clanovi = dohvatiClanove();
        List<Posudba<Casopis>> listaPosudba = new ArrayList<>();
        String queryString = "SELECT * FROM RAZVOJ.POSUDBA_CASOPISA";
        PreparedStatement preparedStatement = connection
                .prepareStatement(queryString);
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            int id = resultSet.getInt("id");
            int clanId = resultSet.getInt("clan");
            int casopisId = resultSet.getInt("casopis");
            Date vrijeme = resultSet.getDate("DATUMPOSUDBE");
            Casopis casopis = null;
            Clan clan = null;
            for (Casopis tmp : casopisi) {
                if (tmp.getId() == casopisId)
                    casopis = tmp;
            }
            for (Clan tmp : clanovi) {
                if (tmp.getId() == clanId)
                    clan = tmp;
            }
            Instant instant = Instant.ofEpochMilli(vrijeme.getTime());
            LocalDateTime date = LocalDateTime.ofInstant(instant,
                    ZoneOffset.UTC);
            Posudba<Casopis> c = new Posudba<Casopis>(id, casopis, clan, date);
            listaPosudba.add(c);
        }
        closeConnectionToDatabase(connection);
        return listaPosudba;
    }
    public static List<Posudba<Knjiga>> dohvatiPosudeneKnjiga()
            throws Exception {
        Connection connection = connectToDatabase();
        List<Knjiga> knjige = dohvatiKnjige();
        List<Clan> clanovi = dohvatiClanove();
        List<Posudba<Knjiga>> listaPosudba = new ArrayList<>();
        String queryString = "SELECT * FROM RAZVOJ.POSUDBA_KNJIGA";
        PreparedStatement preparedStatement = connection
                .prepareStatement(queryString);
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            int id = resultSet.getInt("id");
            int clanId = resultSet.getInt("clan");
            int knjigaId = resultSet.getInt("knjiga");
            Date vrijeme = resultSet.getDate("DATUMPOSUDBE");
            Knjiga knjiga = null;
            Clan clan = null;
            for (Knjiga tmp : knjige) {
                if (tmp.getId() == knjigaId)
                    knjiga = tmp;
            }
            for (Clan tmp : clanovi) {
                if (tmp.getId() == clanId)
                    clan = tmp;
            }
            Instant instant = Instant.ofEpochMilli(vrijeme.getTime());
            LocalDateTime date = LocalDateTime.ofInstant(instant,
                    ZoneOffset.UTC);
            Posudba<Knjiga> c = new Posudba<Knjiga>(id, knjiga, clan, date);
            listaPosudba.add(c);
        }
        closeConnectionToDatabase(connection);
        return listaPosudba;
    }