Package org.hibernate

Examples of org.hibernate.SQLQuery

88
89
90
91
92
93
94
95
96
97
98
99
100
101
    }


    public List pesquisarTipoSanitTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_sanit.*} FROM tipo_sanit {tipo_sanit}");

        query.addEntity("tipo_sanit", TipoSanit.class);

        List tt = query.list();

        session.close();
        return tt;
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    }


    public Us pesquisarUsPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {us.*} FROM us {us} WHERE cod_us = "+cod);

        query.addEntity("us", Us.class);

        Us us = null;
        if(query.list().size() > 0){
            us = (Us) query.list().get(0);
        }
        session.close();
        return us;
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        return us;
    }

    public Us pesquisarUsPorNome(String nome){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {us.*} FROM us {us} WHERE nome like '"+nome+"'");

        query.addEntity("us", Us.class);

        Us us = null;
        if(query.list().size() > 0){
            us = (Us) query.list().get(0);
        }
        session.close();
        return us;
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
    }


    public List pesquisarUsTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {us.*} FROM us {us}");

        query.addEntity("us", Us.class);

        List us = query.list();

        session.close();
        return us;
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    }


    public TipoEstrutViaria pesquisarTipoEstrutViariaPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_estrut_viaria.*} FROM tipo_estrut_viaria {tipo_estrut_viaria} WHERE cod_tipo_estrut_viaria = "+cod);

        query.addEntity("tipo_estrut_viaria", TipoEstrutViaria.class);

        TipoEstrutViaria ev = null;
        if(query.list().size() > 0){
            ev = (TipoEstrutViaria) query.list().get(0);
        }
        session.close();
        return ev;
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        return ev;
    }

    public TipoEstrutViaria pesquisarTipoEstrutViariaPorDescricao(String desc){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_estrut_viaria.*} FROM tipo_estrut_viaria {tipo_estrut_viaria} WHERE descricao like '"+desc+"'");

        query.addEntity("tipo_estrut_viaria", TipoEstrutViaria.class);

        TipoEstrutViaria ev = null;
        if(query.list().size() > 0){
            ev = (TipoEstrutViaria) query.list().get(0);
        }
        session.close();
        return ev;
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
    }


    public List pesquisarTipoEstrutViariaTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_estrut_viaria.*} FROM tipo_estrut_viaria {tipo_estrut_viaria}");

        query.addEntity("tipo_estrut_viaria", TipoEstrutViaria.class);

        List ev = query.list();

        session.close();
        return ev;
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    }


    public Profissao pesquisarProfissaoPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {profissao.*} FROM profissao {profissao} WHERE cod_profissao = "+cod);

        query.addEntity("profissao", Profissao.class);

        Profissao pf = null;
        if(query.list().size() > 0){
            pf = (Profissao) query.list().get(0);
        }
        session.close();
        return pf;
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
        return pf;
    }

    public Profissao pesquisarProfissaoPorDescricao(String desc){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {profissao.*} FROM profissao {profissao} WHERE descricao like '"+desc+"'");

        query.addEntity("profissao", Profissao.class);

        Profissao pf = null;
        if(query.list().size() > 0){
            pf = (Profissao) query.list().get(0);
        }
        session.close();
        return pf;
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
    }


    public List pesquisarProfissaoTodos(){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {profissao.*} FROM profissao {profissao}");

        query.addEntity("profissao", Profissao.class);

        List pf = query.list();

        session.close();
        return pf;
    }
View Full Code Here
TOP

Related Classes of org.hibernate.SQLQuery

  • br.com.flexait.core.AbstractDao
  • br.net.woodstock.rockframework.domain.persistence.orm.impl.CommonHibernateNativeSQLRepository
  • br.net.woodstock.rockframework.domain.persistence.orm.impl.HibernateQueryableRepository
  • br.net.woodstock.rockframework.domain.persistence.orm.impl.HibernateRepositoryHelper
  • br.net.woodstock.rockframework.persistence.orm.impl.HibernateQueryableRepository
  • ch.tatool.app.service.impl.UserAccountDAO
  • com.abiquo.server.core.common.persistence.DefaultDAOBase
  • com.abiquo.server.core.enterprise.EnterpriseDAO
  • com.abiquo.server.core.enterprise.UserDAO
  • com.abiquo.server.core.infrastructure.storage.VolumeManagementDAO
    • Copyright © 2018 www.massapicom. 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.