INNER CODE UNIT · Java
associatedDogToVeterinary
righettod/poc-graphql · src/main/java/eu/righettod/graphqlpoc/repository/BusinessDataRepository.java:194
public Dog associatedDogToVeterinary(int veterinaryId, int dogId) throws Exception {
Dog d = null;
//Verify is the specified DogResolver is already associated
String sql = "SELECT COUNT(ID) FROM DOG WHERE VETERINARY_ID IS NOT NULL and ID = ?";
boolean isAssociated;
try (PreparedStatement stmt = this.storageConnection.prepareStatement(sql)) {
stmt.setInt(1, dogId);
try (ResultSet rst = stmt.executeQuery()) {
isAssociated = rst.getInt(1) > 0;
}
}
//Associated it if it's free
if (!isAssociated) {
sql = "UPDATE DOG SET VETERINARY_ID = ? WHERE ID = ?";
try (PreparedStatement stmt = this.storageConnection.prepareStatement(sql)) {
stmt.setInt(1, veterinaryId);
stmt.setInt(2, dogId);
int count = stmt.executeUpdate();