package com.free.hibernate.select;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;

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

/**
 * <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 CriteriaQuery {
	public static void main(String[] args) {
			HibernateUtil.buildSessionFactory();
			Session session = HibernateUtil.currentSession();
			//創建Criteria查詢
			Criteria crit = session.createCriteria(Contact.class);
			//使用模糊查找
			crit.add(Expression.like("firstName", "g%"));
			//設置最多返回5行
			crit.setMaxResults(5);

			//遍歷查詢的結果集
			List insurances = crit.list();
			for(Iterator it = insurances.iterator();it.hasNext();){
				Contact contact = (Contact) it.next();
				System.out.println("ID: " + contact.getId());
				System.out.println("Name: " + contact.getFirstName()+" "+contact.getLastName());
				
			}
			
			session.close();
	}
}