Package org.hibernate

Examples of org.hibernate.SQLQuery.addEntity()

61
62
63
64
65
66
67
68
69
70
71
    public TurmaPis pesquisarTurmaPisPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {turma_pis.*} FROM turma_pis {turma_pis} WHERE cod_turma_pis = "+cod);

        query.addEntity("turma_pis", TurmaPis.class);

        TurmaPis trp = null;
        if(query.list().size() > 0){
            trp = (TurmaPis) query.list().get(0);
        }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
   public List pesquisarTurmaPisTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {turma_pis.*} FROM turma_pis {turma_pis}");

        query.addEntity("turma_pis", TurmaPis.class);

        List trp = query.list();

        session.close();
        return trp;
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    public Uo pesquisarUoPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {uo.*} FROM uo {uo} WHERE cod_uo = "+cod);

        query.addEntity("uo", Uo.class);

        Uo uo = null;
        if(query.list().size() > 0){
            uo= (Uo) query.list().get(0);
        }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
    public Uo pesquisarUoPorNome(String nome){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {uo.*} FROM uo {uo} WHERE nome like '"+nome+"'");

        query.addEntity("uo", Uo.class);

        Uo uo = null;
        if(query.list().size() > 0){
            uo = (Uo) query.list().get(0);
        }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    public List pesquisarUoTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {uo.*} FROM uo {uo}");

        query.addEntity("uo", Uo.class);

        List uo = query.list();

        session.close();
        return uo;
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
    public ProfPis pesquisarProfPisPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {prof_pis.*} FROM prof_pis {prof_pis} WHERE cod_prof_pis = "+cod);

        query.addEntity("prof_pis", ProfPis.class);

        ProfPis pp = null;
        if(query.list().size() > 0){
            pp = (ProfPis) query.list().get(0);
        }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
     public ProfPis pesquisarProfPisPorCpf(String cpf){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {prof_pis.*} FROM prof_pis {prof_pis} WHERE cpf = "+cpf);

        query.addEntity("prof_pis", ProfPis.class);

        ProfPis pp = null;
        if(query.list().size() > 0){
            pp = (ProfPis) query.list().get(0);
        }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    public ProfPis pesquisarProfPisPorNome(String nome){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {prof_pis.*} FROM prof_pis {prof_pis} WHERE nome like '"+nome+"'");

        query.addEntity("prof_pis", ProfPis.class);

        ProfPis pp = null;
        if(query.list().size() > 0){
            pp = (ProfPis) query.list().get(0);
        }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    public List pesquisarProfPisTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {prof_pis.*} FROM prof_pis {prof_pis}");

        query.addEntity("prof_pis", ProfPis.class);

        List pp = query.list();

        session.close();
        return pp;
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    public TipoAtendSaude pesquisarTipoAtendSaudePorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_atend_saude.*} FROM tipo_atend_saude {tipo_atend_saude} WHERE cod_tipo_atend_saude = "+cod);

        query.addEntity("tipo_atend_saude", TipoAtendSaude.class);

        TipoAtendSaude tas = null;
        if(query.list().size() > 0){
            tas = (TipoAtendSaude) query.list().get(0);
        }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.