query6.java

来自「HIb2 HIBERNATE api高级应用。包括增删查改等基本操作」· Java 代码 · 共 32 行

package test;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

import po.Customer;
import util.HibernateSessionFactory;

public class Query6
{public static void main(String args[]) {
	
	Session session=HibernateSessionFactory.getSession();
	Criteria cri=session.createCriteria(Customer.class);
	cri.add(Restrictions.gt("age",4));
	cri.addOrder(Order.asc("id"));
	cri.setFirstResult(1);
	cri.setMaxResults(3);
	List list=cri.list();
	for( int i=0;i<list.size();i++) {
		Customer cus=(Customer)list.get(i);
		System.out.println(cus.getAge()+"  "+cus.getName());
		
	}
	util.HibernateSessionFactory.closeSession();
}

}