Hibernate中Criteria的使用

/**
* 使用Criteria全查询
*/
public List getallbyCriteria(){
   List arr=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    arr=cri.list();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return arr;
}

/**
* 根据对象属性查询(使用Criteria)
*/
public List getbyPropertyCriteria(String name){
   List arr=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    Criterion c1=Expression.eq("SName", name);
    cri.add(c1);
    arr=cri.list();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return arr;
}

/**
* Criteria多条件查询
*/
public List getPropertyByCriteria(String name,int age){
   List list=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    Criterion c1=Expression.eq("SName", name);
    Criterion c2=Expression.eq("SAge", age);
    cri.add(c1);
    cri.add(c2);
    list=cri.list();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return list;
}

/**
* Criteria模糊查询
*/
public List getallCriteriaLike(String name){
   List arr=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    Criterion c1=Expression.like("SName", "%"+name+"%");
    cri.add(c1);
    arr=cri.list();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return arr;
}

/**
* Criteria范围查询
*/
public List getallCriteriabetween(int age1,int age2){
   List arr=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    Criterion c1=Expression.between("SAge", age1, age2);
    cri.add(c1);
    arr=cri.list();
   } catch (HibernateException e) {
    this.CloseSession();
   }finally{
    this.CloseSession();
   }
   return arr;
}

/**
* Criteria条件统计
*/
public int CountStuByWhereInCriteria(int num1,int num2){
   int count=0;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    Criterion c1=Expression.between("SAge", num1, num2);
    cri.add(c1);
    count=cri.list().size();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return count;
}

/**
* Criteria排序
*/
public List getallCriteriaOrder(){
   List arr=null;
   try {
    Criteria cri=this.GetSession().createCriteria(Stu.class);
    cri.addOrder(Order.desc("SAge"));
    arr=cri.list();
   } catch (HibernateException e) {
    throw e;
   }finally{
    this.CloseSession();
   }
   return arr;
}