94 public void save(Project instance) throws SQLException { |
94 public void save(Project instance) throws SQLException { |
95 Objects.requireNonNull(instance.getName()); |
95 Objects.requireNonNull(instance.getName()); |
96 insert.setString(1, instance.getName()); |
96 insert.setString(1, instance.getName()); |
97 setStringOrNull(insert, 2, instance.getDescription()); |
97 setStringOrNull(insert, 2, instance.getDescription()); |
98 setStringOrNull(insert, 3, instance.getRepoUrl()); |
98 setStringOrNull(insert, 3, instance.getRepoUrl()); |
99 setForeignKeyOrNull(insert, 4, instance.getOwner(), User::getUserID); |
99 setForeignKeyOrNull(insert, 4, instance.getOwner(), User::getId); |
100 insert.executeUpdate(); |
100 insert.executeUpdate(); |
101 } |
101 } |
102 |
102 |
103 @Override |
103 @Override |
104 public boolean update(Project instance) throws SQLException { |
104 public boolean update(Project instance) throws SQLException { |
105 Objects.requireNonNull(instance.getName()); |
105 Objects.requireNonNull(instance.getName()); |
106 update.setString(1, instance.getName()); |
106 update.setString(1, instance.getName()); |
107 setStringOrNull(update, 2, instance.getDescription()); |
107 setStringOrNull(update, 2, instance.getDescription()); |
108 setStringOrNull(update, 3, instance.getRepoUrl()); |
108 setStringOrNull(update, 3, instance.getRepoUrl()); |
109 setForeignKeyOrNull(update, 4, instance.getOwner(), User::getUserID); |
109 setForeignKeyOrNull(update, 4, instance.getOwner(), User::getId); |
110 update.setInt(5, instance.getId()); |
110 update.setInt(5, instance.getId()); |
111 return update.executeUpdate() > 0; |
111 return update.executeUpdate() > 0; |
112 } |
112 } |
113 |
113 |
114 @Override |
114 @Override |