Package org.hibernate

Examples of org.hibernate.SQLQuery.addEntity()

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

        query.addEntity("setor", Setor.class);

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

        query.addEntity("setor", Setor.class);

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

        query.addEntity("setor", Setor.class);

        List st = query.list();

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

        query.addEntity("cidade", Cidade.class);

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

        query.addEntity("cidade", Cidade.class);

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

        query.addEntity("cidade", Cidade.class);

        List cd = query.list();

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

        query.addEntity("uf", Uf.class);

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

        query.addEntity("uf", Uf.class);

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

        query.addEntity("uf", Uf.class);

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

        query.addEntity("uf", Uf.class);

        List uf = query.list();

        session.close();
        return uf;
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.