hibernate常用資料庫查詢方式（QBC）

@Test
/**
 * 簡單的查詢
 */
public void demo1(){
	Session session = HibernateUtils.getCurrentSession();
	Transaction tx = session.beginTransaction();
	
	// 獲得Criteria的對象
	Criteria criteria = session.createCriteria(Customer.class);
	List<Customer> list = criteria.list();
	
	for (Customer customer : list) {
		System.out.println(customer);
	}
	tx.commit();
}

@Test
/**
 * 排序查詢
 */
public void demo2(){
	Session session = HibernateUtils.getCurrentSession();
	Transaction tx = session.beginTransaction();
	
	// 排序查詢
	Criteria criteria = session.createCriteria(Customer.class);
	criteria.addOrder(Order.asc("cust_id")); // 升序
	criteria.addOrder(Order.desc("cust_id")); // 降序
	List<Customer> list = criteria.list();
	
	for (Customer customer : list) {
		System.out.println(customer);
	}
	
	tx.commit();
}

@Test
/**
 * 分頁查詢
 */
public void demo3(){
	Session session = HibernateUtils.getCurrentSession();
	Transaction tx = session.beginTransaction();
	
	// 分頁查詢
	Criteria criteria = session.createCriteria(LinkMan.class);
	criteria.setFirstResult(10);
	criteria.setMaxResults(10);
	List<LinkMan> list = criteria.list();
	
	for (LinkMan linkMan : list) {
		System.out.println(linkMan);
	}
	tx.commit();
}

@Test
/**
 * 條件查詢
 */
public void demo4(){
	Session session = HibernateUtils.getCurrentSession();
	Transaction tx = session.beginTransaction();
	
	// 條件查詢
	Criteria criteria = session.createCriteria(Customer.class);
	// 設定條件:
	/**
	 * =   eq
	 * >   gt
	 * >=  ge
	 * <   lt
	 * <=  le
	 * <>  ne
	 * like
	 * in
	 * and
	 * or
	 */
	criteria.add(Restrictions.eq("cust_source", "小廣告"));
	criteria.add(Restrictions.or(Restrictions.like("cust_name", "李%")));
	criteria.add(Restrictions.like("cust_name", "李%"));
	List<Customer> list = criteria.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}
	tx.commit();
}

@Test
/**
 * 統計查詢
 */
public void demo5(){
	Session session = HibernateUtils.getCurrentSession();
	Transaction tx = session.beginTransaction();
	
	Criteria criteria = session.createCriteria(Customer.class);
	/**
	 * add				:普通的條件。where後面條件
	 * addOrder			:排序
	 * setProjection	:聚合函數 和 group by having
	 */
	criteria.setProjection(Projections.rowCount());
	Long num = (Long) criteria.uniqueResult();
	System.out.println(num);
	tx.commit();
}

@Test
/**
 * 離線條件查詢
 */
public void demo6(){
	DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Customer.class);
	detachedCriteria.add(Restrictions.like("cust_name", "李%"));
	
	Session session = HibernateUtils.getCurrentSession();
	Transaction transaction = session.beginTransaction();
	
	Criteria criteria = detachedCriteria.getExecutableCriteria(session);
	List<Customer> list = criteria.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}
	transaction.commit();
}