query5.java

来自「郭克华j2ee高级框架实战教学视频源代码 这个是比较值得一看的 由郭克华博士」· Java 代码 · 共 35 行

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;

//Hibernate实现查询余额>1000的人
public class Query5 {
	public static void main(String[] args) {
		Session session = util.HibernateSessionFactory.getSession();
		
		Criteria cri = session.createCriteria(Customer.class);
		cri.add(Restrictions.gt("cbalance",1000.0));
		cri.addOrder(Order.asc("cbalance"));
		cri.setFirstResult(1);//从第一条记录显示
		cri.setMaxResults(3);	//显示3条记录

		List list = cri.list();
		
		for(int i=0;i<list.size();i++){
			Customer cus = (Customer)list.get(i);
			System.out.println(cus.getCname() + " " + cus.getCbalance());
		}
		
		util.HibernateSessionFactory.closeSession();

	}

}