querytest.java

来自「本程序是用java基于jsf架构编写的测试jsf程序样例」· Java 代码 · 共 41 行

package com.hibernate;

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

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

import junit.framework.TestCase;

public class QueryTest extends TestCase {
	public void testQuery(){
		
		Session session = null ;
		User user = null ;
	
		try{
			session = HibernateUtils.openSession() ;
			session.beginTransaction() ;
			Query query = session.createQuery("from User") ;
			
			//实现对数据的分页处理
			query.setFirstResult(1) ;
			query.setMaxResults(3) ;
			
			List userList = query.list() ;
			for(Iterator i=userList.iterator();i.hasNext();){
				user =(User) i.next() ;
				System.out.println("id = "+user.getId()) ;
				System.out.println("name = "+user.getName()) ;
			}
			session.getTransaction().commit() ;
		}catch(Exception e){
			e.printStackTrace() ;
			session.getTransaction().rollback() ;
		}finally {
			HibernateUtils.closeSession( session) ;
		}
	}
}