INNER CODE UNIT · Java

findByNamePrefix

righettod/poc-graphql · src/main/java/eu/righettod/graphqlpoc/repository/BusinessDataRepository.java:69

    public List<Dog> findByNamePrefix(String namePrefix, int limit) throws Exception {
        List<Dog> dogs = null;
        String sqlDog = "SELECT ID, NAME, VETERINARY_ID FROM DOG WHERE NAME LIKE '" + namePrefix + "%' LIMIT ?";
        try (PreparedStatement stmt = this.storageConnection.prepareStatement(sqlDog)) {
            stmt.setInt(1, limit);
            try (ResultSet rst = stmt.executeQuery()) {
                while (rst.next()) {
                    if (dogs == null) {
                        dogs = new ArrayList<>();
                    }
                    dogs.add(new Dog(rst.getInt("ID"), rst.getString("NAME"), this.findVeterinaryById(rst.getInt("VETERINARY_ID"))));
                }
            }
        }
        return dogs;
    }

    /**

View source record →