1. eq( ):等值查詢
2. ge( ):大于等于
3. gt():大于
4. le:小于等于
5. lt:小于
6. between:大于小的,小于大的
7. like:模糊查詢
8. like().ignoreCase():不區(qū)分大小寫查詢
9. ilike():規(guī)則模糊查詢
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","%楊%"));
        //不區(qū)分大小寫模糊查詢
        //c.add(Restrictions.like("xingming","%楊%").ignoreCase());
        //規(guī)則模糊查詢
       // 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();
    }