Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void popuniListuUcesnika(Dogadjaj d) {
- String upit = "select * from korisnik k join ucestvuje u on (k.korisnikID=u.korisnikID) join dogadjaj d on (u.dogadjajID=d.dogadjajID)"
- + " where d.naziv = ?";
- PreparedStatement preparedStatement = null;
- try {
- preparedStatement = konekcija.prepareStatement(upit);
- prepareStatement.setString(1, d.getNaziv());
- ResultSet rs = preparedStatement.executeQuery();
- while (rs.next()){
- String user = rs.getString("user");
- String password = rs.getString("password");
- String ime = rs.getString("ime");
- String prezime = rs.getString("prezime");
- Korisnik k = new Korisnik(user, password, ime, prezime);
- d.getUcesnici().add(k);
- System.out.println(k);
- }
- } catch (SQLException ex) {
- Logger.getLogger(DBBroker.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement