querytest.java

来自「实现一些hibernate底层的东西」· Java 代码 · 共 41 行

package com.bjsxt.hibernate;

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

import junit.framework.TestCase;

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

public class QueryTest extends TestCase {
	
	public static void main( String[] args)
	{
		Session session = null;
		try{
			session = HibernateUtils.getSession();
			session.beginTransaction();
			Query query = session.createQuery( "from User" );
			query.setFirstResult( 3 );
			query.setMaxResults( 3 );
			List list = query.list();
			for( Iterator iterator = list.iterator() ; iterator.hasNext();)
			{
				User user = ( User )iterator.next();
				System.out.println( user.getName() );
				System.out.println( user.getId() );
				System.out.println();
			}
			
			session.getTransaction().commit();
			
		}catch( Exception e ){
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally{
			HibernateUtils.closeSession(session);
		}
	}
}