Skip to content

Instantly share code, notes, and snippets.

@nosrednawall

nosrednawall/namedQuery.java

Created May 29, 2018 16:04
Show Gist options
  • Save nosrednawall/4d08dcab5c9d8f865013fa01abe0680d to your computer and use it in GitHub Desktop.
Save nosrednawall/4d08dcab5c9d8f865013fa01abe0680d to your computer and use it in GitHub Desktop.
Download ZIP
Exemplo de namedquery
Raw
namedQuery.java
@NamedQueries({
@NamedQuery(name = "Lojista.listarTodos", query = "" + "SELECT DISTINCT l FROM Lojista l "
+ "LEFT JOIN FETCH l.endereco " + "LEFT JOIN FETCH l.loja " + "WHERE l.status = :pStatus"),
@NamedQuery(name = "Lojista.find", query = "" + "SELECT DISTINCT l FROM Lojista l "
+ "LEFT JOIN FETCH l.endereco " + "LEFT JOIN FETCH l.loja " + "WHERE l.id = :pId") })
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment