src/main/java/de/uapcore/lightpit/dao/postgres/PGProjectDao.java

changeset 51
dd0a45ae25d7
parent 47
57cfb94ab99f
child 59
c759c60507a2
equal deleted inserted replaced
50:2a90d105edec 51:dd0a45ae25d7
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

mercurial