Created
March 12, 2019 16:30
-
-
Save nosrednawall/43ac4ddf3e85daccb7d02411783397f1 to your computer and use it in GitHub Desktop.
como utilizar named querys java
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @NamedQueries({ | |
| @NamedQuery(name = "Usuario.listarTodos", query = "SELECT DISTINCT u FROM Usuario u LEFT JOIN FETCH u.candidaturas WHERE u.status = :pStatus"), | |
| @NamedQuery(name = "Usuario.listarTodosSemStatus", query = "SELECT DISTINCT u FROM Usuario u LEFT JOIN FETCH u.candidaturas"), | |
| @NamedQuery(name = "Usuario.find", query = "SELECT DISTINCT u FROM Usuario u LEFT JOIN FETCH u.candidaturas WHERE u.id = :pId"), | |
| @NamedQuery(name = "Usuario.loga", query = "SELECT DISTINCT u FROM Usuario u LEFT JOIN FETCH u.candidaturas WHERE u.email = :pEmail AND u.senha = :pSenha") }) | |
| @XmlRootElement | |
| @Entity | |
| @Table(name = "usuario") | |
| public class Usuario implements Serializable { | |
| /** | |
| continua o resto da classe | |
| **/ | |
| } | |
| /** | |
| na classe dao | |
| **/ | |
| public List<Usuario> listaTodos(StatusBinarioEnum status) { | |
| if(status.equals(StatusBinarioEnum.AMBOS)) { | |
| TypedQuery<Usuario> query = getEntityManager().createNamedQuery("Usuario.listarTodosSemStatus", Usuario.class); | |
| return query.getResultList(); | |
| } | |
| TypedQuery<Usuario> query = getEntityManager().createNamedQuery("Usuario.listarTodos", Usuario.class); | |
| query.setParameter("pStatus", status); | |
| return query.getResultList(); | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment