Package org.hibernate

Examples of org.hibernate.Session.createSQLQuery()

73
74
75
76
77
78
79
80
81
82
83
        return st;
    }

    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){
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }


    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();

View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }


    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){
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        return cd;
    }

    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){
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }


    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();

View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }


    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){
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
        return uf;
    }

    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){
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }


     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){
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        return uf;
    }

    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();

View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }


    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){
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.