Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- enum SQLGroup{
- INSERT("INSERT INTO groups (group_id, group_name) VALUES(DEFAULT, (?)) RETURNING group_id"),
- UPDATE("UPDATE groups SET group_name = (?) WHERE group_id = (?) RETURNING group_id");
- String QUERY;
- SQLGroup(String QUERY) {
- this.QUERY = QUERY;
- }
- }
- @Override
- public Optional<Group> update(Group group) {
- try(PreparedStatement statement = connection.prepareStatement(SQLGroup.UPDATE.QUERY)){
- statement.setString(1,group.getName());
- statement.setInt(2, group.getId());
- try (ResultSet resultSet = statement.executeQuery()) {
- if (resultSet.next()) {
- group.setId(resultSet.getInt(1));
- }
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return Optional.of(group);
- }
- code below is in the main method
- groupDAO.update(new Group(1,"FK-22")).ifPresent(group -> System.out.println(group.getName()));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement