hqlquery.java

Spring2.0宝典

package lee;

import org.hibernate.Transaction;
import org.hibernate.Session;
import org.hibernate.Query;

import java.util.Date;
import java.util.Set;
import java.util.HashSet;
import java.util.List;
import java.util.Iterator;

/*
 * @author  yeeku.H.lee [e-mail]
 * @version  1.0
 * <br>Copyright (C), 2005-2008, yeeku.H.Lee
 * <br>This program is protected by copyright laws.
 * <br>Program Name:
 * <br>Date: 
 */
public class HqlQuery
{

    public static void main(String[] args)throws Exception
	{
        HqlQuery mgr = new HqlQuery();
        mgr.findPersons();
        HibernateUtil.sessionFactory.close();
    }

	private void findPersons()
	{
		Session sess = HibernateUtil.currentSession();
		Transaction tx = sess.beginTransaction();
           
        Query q = sess.createQuery("select new list(p,p.name) from Person as p right join p.sons as s");
		List pl =q.list();
        /*
		for (Iterator pit = pl.iterator() ; pit.hasNext(); )
        {
            Person p = ( Person )pit.next();
			System.out.println(p.getName());
        }
		*/
		System.out.println(pl);
        
		tx.commit();
		HibernateUtil.closeSession();
	}

}