Advertisement
N_Damyanov

removeTownsAndAddresses

Jun 23rd, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.02 KB | None | 0 0
  1. private void removeTownsAndAddresses() {
  2.         Scanner scanner = new Scanner(System.in);
  3.         String townName = scanner.nextLine();
  4.  
  5.         this.entityManager.getTransaction().begin();
  6.  
  7.         try {
  8.             Town town = this.entityManager.createQuery("FROM Town WHERE name = :townName", Town.class)
  9.                     .setParameter("townName", townName)
  10.                     .getSingleResult();
  11.             List<Address> addresses = this.entityManager.createQuery("FROM Address WHERE town.id = :town_id")
  12.                     .setParameter("town_id", town.getId())
  13.                     .getResultList();
  14.             addresses.forEach(this.entityManager::remove);
  15.             this.entityManager.remove(town);
  16.  
  17.             System.out.printf("%d addresses in %s deleted",addresses.size(), townName);
  18.  
  19.         } catch (NoResultException e) {
  20.             System.out.printf("No Town with name: %s", townName);
  21.         }
  22.  
  23.  
  24.         this.entityManager.flush();
  25.         this.entityManager.getTransaction().commit();
  26.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement