Package org.hibernate

Examples of org.hibernate.SQLQuery

59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    }


    public TipoMoradia pesquisarTipoMoradiaPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_moradia.*} FROM tipo_moradia {tipo_moradia} WHERE cod_tipo_moradia = "+cod);

        query.addEntity("tipo_moradia", TipoMoradia.class);

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

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

        query.addEntity("tipo_moradia", TipoMoradia.class);

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


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

        query.addEntity("tipo_moradia", TipoMoradia.class);

        List md = query.list();

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


    public GrupoUs pesquisarGrupoUsPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {grupo_us.*} FROM grupo_us {grupo_us} WHERE cod_grupo_us = "+cod);

        query.addEntity("grupo_us", GrupoUs.class);

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

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

        query.addEntity("grupo_us", GrupoUs.class);

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


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

        query.addEntity("grupo_us", GrupoUs.class);

        List gu = query.list();

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


    public Pis pesquisarPisPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {pis.*} FROM pis {pis} WHERE cod_pis = "+cod);

        query.addEntity("pis", Pis.class);

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

    public Pis pesquisarPisPorDescricao(String desc){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {pis.*} FROM pis {pis} WHERE nome like '"+desc+"'");

        query.addEntity("pis", Pis.class);

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


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

        query.addEntity("pis", Pis.class);

        List pis = query.list();

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


    public TipoLogradouro pesquisarTipoLogradouroPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_logradouro.*} FROM tipo_logradouro {tipo_logradouro} WHERE cod_tipo_logradouro = "+cod);

        query.addEntity("tipo_logradouro", TipoLogradouro.class);

        TipoLogradouro tl = null;
        if(query.list().size() > 0){
            tl = (TipoLogradouro) query.list().get(0);
        }
        session.close();
        return tl;
    }
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.