Advertisement
Guest User

Untitled

a guest
Mar 12th, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. public void popuniListuUcesnika(Dogadjaj d) {
  2.  
  3. String upit = "select * from korisnik k join ucestvuje u on (k.korisnikID=u.korisnikID) join dogadjaj d on (u.dogadjajID=d.dogadjajID)"
  4. + " where d.naziv = ?";
  5.  
  6.  
  7. PreparedStatement preparedStatement = null;
  8.  
  9.  
  10. try {
  11. preparedStatement = konekcija.prepareStatement(upit);
  12. prepareStatement.setString(1, d.getNaziv());
  13.  
  14. ResultSet rs = preparedStatement.executeQuery();
  15.  
  16. while (rs.next()){
  17. String user = rs.getString("user");
  18. String password = rs.getString("password");
  19. String ime = rs.getString("ime");
  20. String prezime = rs.getString("prezime");
  21.  
  22. Korisnik k = new Korisnik(user, password, ime, prezime);
  23. d.getUcesnici().add(k);
  24. System.out.println(k);
  25. }
  26. } catch (SQLException ex) {
  27. Logger.getLogger(DBBroker.class.getName()).log(Level.SEVERE, null, ex);
  28. }
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement