dudakp
4/25/2020 - 9:25 PM

[Named Query] Pouzitie namedQuery #VSA

[Named Query] Pouzitie namedQuery #VSA

String namedQueryName;
String namedQueryParamName;
Object namedQueryParamValue; // Object pisem vseobecne, ide to podla typu fieldy entitnej classy
Entity entity; // nasa entitna trieda

em.createNamedQuery(namedQueryName)
    .setParameter(namedQueryParamName, namedQueryParamValue)
    .getResultList();
	//.getSingleResult(); - ak hladam napr. podla ID takze viem ze vzdy dostanem len jeden objekt.

// ### EXCEPTION HANDLING ###
// getSingleResult() hadze NoResultException ak query nic nevrati
try {
  entity = (Entity) em.createNamedQuery(namedQueryName)
    .setParameter(namedQueryParamName, namedQueryParamValue)
    .getSingleResult();
} catch (NoResultException e) {
  // logika ked nic nenajdem...
  System.out.println(e);
}