Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void removeTownsAndAddresses() {
- Scanner scanner = new Scanner(System.in);
- String townName = scanner.nextLine();
- this.entityManager.getTransaction().begin();
- try {
- Town town = this.entityManager.createQuery("FROM Town WHERE name = :townName", Town.class)
- .setParameter("townName", townName)
- .getSingleResult();
- List<Address> addresses = this.entityManager.createQuery("FROM Address WHERE town.id = :town_id")
- .setParameter("town_id", town.getId())
- .getResultList();
- addresses.forEach(this.entityManager::remove);
- this.entityManager.remove(town);
- System.out.printf("%d addresses in %s deleted",addresses.size(), townName);
- } catch (NoResultException e) {
- System.out.printf("No Town with name: %s", townName);
- }
- this.entityManager.flush();
- this.entityManager.getTransaction().commit();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement