- eq( ):等值查询
- ge( ):大于等于
- gt():大于
- le:小于等于
- lt:小于
- between:大于小的,小于大的
- like:模糊查询
- like().ignoreCase():不区分大小写查询
- ilike():规则模糊查询
- or:或查询
- isNotNull:非空
- isNull:为空
- isNotEmpty:存在
- 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();
}
