Hibernate中Criteria查询条件

1. eq( ):等值查询
2. ge( ):大于等于
3. gt():大于
4. le:小于等于
5. lt:小于
6. between:大于小的,小于大的
7. like:模糊查询
8. like().ignoreCase():不区分大小写查询
9. ilike():规则模糊查询
10. or:或查询
11. isNotNull:非空
12. isNull:为空
13. isNotEmpty:存在
14. isEmpty:不存在

    public static void selectByCriteria(){
   	 Session session = HibernateUtil.getSession();
   	 Criteria c = session.createCriteria(Xuesheng.class);
   	 //等值查询
   	// c.add(Restrictions.eq("xingming", "田田"));
   	 //大于等于
   	// c.add(Restrictions.ge("nianling", 18));
   	 //小于
   	 //c.add(Restrictions.lt("nianling", 18));
   	 //大于小的,小于大的
   	 //c.add(Restrictions.between("nianling", 18, 22));
   	//模糊查询
   	 //c.add(Restrictions.like("xingming","%杨%"));
   	 //不区分大小写模糊查询
   	 //c.add(Restrictions.like("xingming","%杨%").ignoreCase());
   	 //规则模糊查询
   	// c.add(Restrictions.ilike("xingming","文", MatchMode.ANYWHERE));
   	 //或查询
   	 //c.add(Restrictions.or(Restrictions.like("xingming", "田"), Restrictions.le("nianling", 23)));
   	 //多个或查询
   	/* c.add(Restrictions.disjunction().add(Restrictions.like("xingming", "田"))
   			                           .add(Restrictions.eq("xingbie", 1))
   			                          .add(Restrictions.le("nianling", 20)));*/
   	 //非空
   	// c.add(Restrictions.isNotNull("nianling"));
   	 //为空
   	// c.add(Restrictions.isNull("xingming"));
   	 //存在,需要是集合类型的属性
   	// c.add(Restrictions.isNotEmpty("chengji"));
   	 //不存在,需要是集合类型的属性
    	//c.add(Restrictions.isEmpty("chengji"));  
   	 List<Xuesheng> list = c.list();
    }