javaEE Hibernate, Criteria, QBC检索, 无语句查询

 

Test.java：

package cn.xxx.demo;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;

import cn.xxx.domain.Customer;
import cn.xxx.utils.HibernateUtils;

//学习Criteria语法
public class Test {
	
	@Test
	//基本语法
	public void fun1(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		Criteria c = session.createCriteria(Customer.class);
		
		List<Customer> list = c.list();
		
		System.out.println(list);
		//----------------------------------------------------
		tx.commit();
		session.close();		
	}
	
	@Test
	//条件查询
	// > 				gt
	// >=				ge
	// <				lt
	// <=				le
	// ==				eq
	// !=				ne
	// in				in
	// between and		between
	// like 			like
	// is not null 		isNotNull
	// is null			isNull
	// or				or
	// and				and
	public void fun2(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		Criteria c = session.createCriteria(Customer.class);
		
		//c.add(Restrictions.idEq(2l));  // 根据主键查询
		c.add(Restrictions.eq("cust_id",2l));
		
		List<Customer> list = c.list();
		
		System.out.println(list);
		//----------------------------------------------------
		tx.commit();
		session.close();		
	}
	
	@Test
	//分页查询 - 与HQL一样
	public void fun3(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		Criteria c = session.createCriteria(Customer.class);
		//limit ?,? 
		c.setFirstResult(0);
		c.setMaxResults(10);
		
		List<Customer> list = c.list();
		
		System.out.println(list);	
		//----------------------------------------------------
		tx.commit();
		session.close();		
	}
	
	@Test
	//排序语法 
	public void fun4(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		Criteria c = session.createCriteria(Customer.class);
		
		c.addOrder(Order.asc("cust_id"));  // 升序
		//c.addOrder(Order.desc("cust_id"));  // 降序
		
		List<Customer> list = c.list();
		
		System.out.println(list);
		//----------------------------------------------------
		tx.commit();
		session.close();		
	}
	
	@Test
	//统计语法  聚合函数
	public void fun5(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		Criteria c = session.createCriteria(Customer.class);
		
		//设置查询目标。 聚合函数
		c.setProjection(Projections.rowCount());
		
		List list = c.list();
		
		System.out.println(list);
		//----------------------------------------------------
		tx.commit();
		session.close();		
	}	
}