Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement