package cn.hxex.basic.exercise;

import java.util.Iterator;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;

import cn.hxex.basic.model.User;

public class TestQuery {

	public static final SessionFactory sessionFactory;
	
	static
	{
		sessionFactory = new Configuration().configure().buildSessionFactory();
	}
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		TestQuery.testHQL();
	}

	public static void testHQL()
	{
		String hql = "select new User( u.name, u.password ) from User u ";
		Session session = sessionFactory.openSession();
		Transaction tx = session.beginTransaction();
		Query query = session.createQuery( hql );
		Iterator it = query.iterate();
		while( it.hasNext() )
		{
			System.out.println( it.next() );
		}
		tx.commit();
		
		session.createCriteria(User.class).add( Restrictions.like( "abc", "def" ) );
		session.close();
	}
}