Advertisement
Guest User

Untitled

a guest
Jun 11th, 2020
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. enum SQLGroup{
  2. INSERT("INSERT INTO groups (group_id, group_name) VALUES(DEFAULT, (?)) RETURNING group_id"),
  3. UPDATE("UPDATE groups SET group_name = (?) WHERE group_id = (?) RETURNING group_id");
  4. String QUERY;
  5.  
  6. SQLGroup(String QUERY) {
  7. this.QUERY = QUERY;
  8. }
  9. }
  10.  
  11. @Override
  12. public Optional<Group> update(Group group) {
  13. try(PreparedStatement statement = connection.prepareStatement(SQLGroup.UPDATE.QUERY)){
  14. statement.setString(1,group.getName());
  15. statement.setInt(2, group.getId());
  16. try (ResultSet resultSet = statement.executeQuery()) {
  17. if (resultSet.next()) {
  18. group.setId(resultSet.getInt(1));
  19. }
  20. }
  21. } catch (SQLException e) {
  22. e.printStackTrace();
  23. }
  24. return Optional.of(group);
  25. }
  26. code below is in the main method
  27. groupDAO.update(new Group(1,"FK-22")).ifPresent(group -> System.out.println(group.getName()));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement