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<SkyGClassification> list= new LinkedList<SkyGClassification>  ();
	
	private static List<SkyGClassification> 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<SkyGClassification> 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