comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGUserDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGUserDao.java
- changeset 75
- 33b6843fdf8a
- parent 59
- c759c60507a2
- child 124
- ed2e7aef2a3e
equal
deleted
inserted
replaced
| 74:91d1fc2a3a14 | 75:33b6843fdf8a |
|---|---|
| 56 | 56 |
| 57 insert = connection.prepareStatement("insert into lpit_user (username, lastname, givenname, mail) values (?, ?, ?, ?)"); | 57 insert = connection.prepareStatement("insert into lpit_user (username, lastname, givenname, mail) values (?, ?, ?, ?)"); |
| 58 update = connection.prepareStatement("update lpit_user set lastname = ?, givenname = ?, mail = ? where userid = ?"); | 58 update = connection.prepareStatement("update lpit_user set lastname = ?, givenname = ?, mail = ? where userid = ?"); |
| 59 } | 59 } |
| 60 | 60 |
| 61 public User mapColumns(ResultSet result) throws SQLException { | 61 private User mapColumns(ResultSet result) throws SQLException { |
| 62 final int id = result.getInt("userid"); | 62 final int id = result.getInt("userid"); |
| 63 if (id == 0) return null; | 63 if (id == 0) return null; |
| 64 final var user = new User(id); | 64 final var user = new User(id); |
| 65 user.setUsername(result.getString("username")); | 65 user.setUsername(result.getString("username")); |
| 66 user.setGivenname(result.getString("givenname")); | 66 user.setGivenname(result.getString("givenname")); |
| 79 insert.executeUpdate(); | 79 insert.executeUpdate(); |
| 80 } | 80 } |
| 81 | 81 |
| 82 @Override | 82 @Override |
| 83 public boolean update(User instance) throws SQLException { | 83 public boolean update(User instance) throws SQLException { |
| 84 if (instance.getId() < 0) return false; | |
| 84 setStringOrNull(update, 1, instance.getLastname()); | 85 setStringOrNull(update, 1, instance.getLastname()); |
| 85 setStringOrNull(update, 2, instance.getGivenname()); | 86 setStringOrNull(update, 2, instance.getGivenname()); |
| 86 setStringOrNull(update, 3, instance.getMail()); | 87 setStringOrNull(update, 3, instance.getMail()); |
| 87 update.setInt(4, instance.getId()); | 88 update.setInt(4, instance.getId()); |
| 88 return update.executeUpdate() > 0; | 89 return update.executeUpdate() > 0; |
