Package org.hibernate

Examples of org.hibernate.SQLQuery.list()


        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


        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

        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

        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

        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

        SQLQuery query = session.createSQLQuery("SELECT {tipo_logradouro.*} FROM tipo_logradouro {tipo_logradouro} WHERE descricao like '"+desc+"'");

        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

        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

        Session session = factory.openSession();
        SQLQuery query = session.createSQLQuery("SELECT {tipo_logradouro.*} FROM tipo_logradouro {tipo_logradouro}");

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

        List tl = query.list();

        session.close();
        return tl;
    }

View Full Code Here

        SQLQuery query = session.createSQLQuery("SELECT {tipo_curso_prof.*} FROM tipo_curso_prof {tipo_curso_prof} WHERE cod_tipo_curso_prof = "+cod);

        query.addEntity("tipo_curso_prof", TipoCursoProf.class);

        TipoCursoProf cp = null;
        if(query.list().size() > 0){
            cp = (TipoCursoProf) query.list().get(0);
        }
        session.close();
        return cp;
    }
View Full Code Here

        query.addEntity("tipo_curso_prof", TipoCursoProf.class);

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