hqlorderbygroupby.java

《基于Eclipse的开源框架技术与实战》[第8章]随书源码

package com.free.hibernate.select;

import org.hibernate.*;
import org.hibernate.cfg.*;

import com.free.hibernate.bo.Contact;
import com.free.hibernate.util.HibernateUtil;

import java.util.*;

/**
 * <p>Title: Eclipse Plugin Development</p>
 * <p>Description: Free download</p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: Free</p>
 * @author gan.shu.man
 * @version 1.0
 */

public class HQLOrderByGroupBy {
	public static void main(String[] args) {
		//创建SessionFactory
		HibernateUtil.buildSessionFactory();
		//取得Session
		Session session = HibernateUtil.currentSession();
		//分组查询
		String SQL_QUERY = " from Contact as contact order by contact.firstName";
		//排序查询
//		String SQL_QUERY = " from Contact as contact group by contact.firstName";
		//查询Contact对象，并遍历所有的Contact对象
		Query query = session.createQuery(SQL_QUERY);
		for (Iterator it = query.iterate(); it.hasNext();) {
			Contact contact = (Contact) it.next();
			System.out.println("ID: " + contact.getId());
			System.out.println("Name: " + contact.getFirstName() + " "
					+ contact.getLastName());

		}
		session.close();
	}
}