Hibernate select query exmaple
Hiber nate select example
use of class names in select query in hibernate
package skyg.db.retrieve; import java.util.LinkedList; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; import skyg.beans.SkyGClassification; public class RetrieveClassifications { static List
list= new LinkedList
(); private static List
retrieveClassifications( ) { System.out.println("Before Retrieving Record"); Session session = null; try{ SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); session =sessionFactory.openSession(); System.out.println("Retrieving Record"); Query query = session.createSQLQuery("select skygClassification.* from classifications skygClassification ").addEntity("skygClassification.", SkyGClassification.class); list = query.list(); } catch(HibernateException he) { System.out.println(he.getMessage()); } finally{ try{ session.flush(); session.close(); }catch (Exception e) { System.out.println(e); } } return list; } public static List
listOfClassification() { if (list.size()<=0) { System.out.println("size " +list.size()); return retrieveClassifications(); }else { System.out.println("size " +list.size()); return list; } } public static void rebuild() { retrieveClassifications(); } }
Please send comments to
vgdarur.javafive@blogger.com
Copyright © 2008 - iForeRunner.com
http://www.iforerunner.com/