Package org.hibernate

Examples of org.hibernate.SQLQuery.list()


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

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

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


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

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

        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

        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

        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

        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

        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

        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

        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

        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

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.