INNER CODE UNIT · Java
findVeterinaryById
righettod/poc-graphql · src/main/java/eu/righettod/graphqlpoc/repository/BusinessDataRepository.java:125
public Veterinary findVeterinaryById(int veterinaryId) throws Exception {
Veterinary v = null;
String sqlVet = "SELECT ID, NAME, POPULARITY FROM VETERINARY WHERE ID=?";
String sqlDog = "SELECT ID, NAME FROM DOG WHERE VETERINARY_ID=?";
//Find Vet info
try (PreparedStatement stmt = this.storageConnection.prepareStatement(sqlVet)) {
stmt.setInt(1, veterinaryId);
try (ResultSet rst = stmt.executeQuery()) {
while (rst.next()) {
List<Dog> dogs = null;
String vetName = rst.getString("NAME");
int vetPopularity = rst.getInt("POPULARITY");
//Find Vet's dog list
try (PreparedStatement stmt2 = this.storageConnection.prepareStatement(sqlDog)) {
stmt2.setInt(1, veterinaryId);
try (ResultSet rst2 = stmt2.executeQuery()) {
while (rst2.next()) {
if (dogs == null) {