Hibernate中createCriteria（QBC）查询的用法

HQL和QBC常用的查询条件做的比较 
表达式含义                                     HQL                                     QBC 
大于等于                                         >=                                        Expression.ge() 
大于                                                 >                                         Expression.gt() 
小于等于                                         <=                                        Expression.le() 
小于                                                 <                                         Expression.lt() 
等于                                                 =                                         Expression.eq() 
不等于                                             <>或者!=                            Expression.ne()    

为空                                                 is null                             Expression.isNull() 
不为空                                             is notnull                        Expression.isNotNull() 
在指定范围内                                 betweenand                        Expression.between() 
不在指定范围                                 not betweenand                Expression.not(Expression.between()) 
属于某个集合                                 in                                        Expression.in() 
不属于某个集合                             notin                                 Expression.not(Expression.in()) 
与                                                    and                                     Expression.and() 
或                                                    or                                        Expression.or() 
非                                                    not                                     Expression.not() 
模糊查询                                        like                                    Expression.like