Package org.hibernate

Examples of org.hibernate.SQLQuery$ReturnProperty

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


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

        query.addEntity("tipo_sit_ocupacional", TipoSitOcupacional.class);

        List to = query.list();

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


    public Familia pesquisarFamiliaPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {familia.*} FROM familia {familia} WHERE cod_familia = "+cod);

        query.addEntity("familia", Familia.class);

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


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

        query.addEntity("familia", Familia.class);

        List fm = query.list();

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


    public Logradouro pesquisarLogradouroPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {logradouro.*} FROM logradouro {logradouro} WHERE cod_logradouro = "+cod);

        query.addEntity("logradouro", Logradouro.class);

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

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

        query.addEntity("logradouro", Logradouro.class);

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


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

        query.addEntity("logradouro", Logradouro.class);

        List lg = query.list();

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


    public Org pesquisarOrgPorCodigo(int cod){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {org.*} FROM org {org} WHERE cod_org = "+cod);

        query.addEntity("org", Org.class);

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


    public Org pesquisarOrgPorCnpj(String cnpj){
        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {org.*} FROM org {org} WHERE cnpj = "+cnpj);

        query.addEntity("org", Org.class);

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

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

        query.addEntity("org", Org.class);

        Org org = null;
        if(query.list().size() > 0){
            org = (Org) query.list().get(0);
        }
        session.close();
        return org;
    }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
116
        return org;
    }

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

        query.addEntity("org", Org.class);

        List org = query.list();

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

Related Classes of org.hibernate.SQLQuery$ReturnProperty

  • 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.