comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGUserDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGUserDao.java
- changeset 51
- dd0a45ae25d7
- parent 47
- 57cfb94ab99f
- child 59
- c759c60507a2
equal
deleted
inserted
replaced
| 50:2a90d105edec | 51:dd0a45ae25d7 |
|---|---|
| 42 | 42 |
| 43 import static de.uapcore.lightpit.dao.Functions.setStringOrNull; | 43 import static de.uapcore.lightpit.dao.Functions.setStringOrNull; |
| 44 | 44 |
| 45 public final class PGUserDao implements UserDao, GenericDao<User> { | 45 public final class PGUserDao implements UserDao, GenericDao<User> { |
| 46 | 46 |
| 47 public static final String[] COLUMNS = { | |
| 48 "id", "username", "lastname", "givenname", "mail" | |
| 49 }; | |
| 50 | |
| 51 private final PreparedStatement insert, update, list, find; | 47 private final PreparedStatement insert, update, list, find; |
| 52 | 48 |
| 53 public PGUserDao(Connection connection) throws SQLException { | 49 public PGUserDao(Connection connection) throws SQLException { |
| 54 list = connection.prepareStatement( | 50 list = connection.prepareStatement( |
| 55 "select userid, username, lastname, givenname, mail " + | 51 "select userid, username, lastname, givenname, mail " + |
| 87 @Override | 83 @Override |
| 88 public boolean update(User instance) throws SQLException { | 84 public boolean update(User instance) throws SQLException { |
| 89 setStringOrNull(update, 1, instance.getLastname()); | 85 setStringOrNull(update, 1, instance.getLastname()); |
| 90 setStringOrNull(update, 2, instance.getGivenname()); | 86 setStringOrNull(update, 2, instance.getGivenname()); |
| 91 setStringOrNull(update, 3, instance.getMail()); | 87 setStringOrNull(update, 3, instance.getMail()); |
| 92 update.setInt(4, instance.getUserID()); | 88 update.setInt(4, instance.getId()); |
| 93 return update.executeUpdate() > 0; | 89 return update.executeUpdate() > 0; |
| 94 } | 90 } |
| 95 | 91 |
| 96 @Override | 92 @Override |
| 97 public List<User> list() throws SQLException { | 93 public List<User> list() throws SQLException { |
