一:得到criteria
Session session = factory.getCurrentSession(); Criteria criteria = session.createCriteria(FirstTitle.class)
二:添加一些条件
//得到criteria
Session session = factory.getCurrentSession();
Criteria criteria = session.createCriteria(FirstTitle.class);
//添加条件
//匹配属性id大于2的数据
criteria.add(Restrictions.gt("id", new Integer(2)));
//匹配属性id小于5的数据
criteria.add(Restrictions.lt("id", new Integer(5)));
//匹配属性id在1到5之间
criteria.add(Restrictions.between("id", new Integer(1), newInteger(5)));
//匹配属性id大于等于5
criteria.add(Restrictions.ge("id", new Integer(5)));
//匹配属性id小于等于5
criteria.add(Restrictions.le("id", new Integer(5)));
//匹配属性name与鞋靴包一致的name属性
criteria.add(Restrictions.eq("name", "鞋靴包"));
//匹配name与鞋靴包一致的属性,并精确匹配,在实际开发中,鞋靴包是根据前台用户传的值
//例如
/*public List find(Product condition){
//根据用户输入产品名称进行查询
Session session = factory.getCurrentSession();
Criteria criteria = session.createCriteria(Product.class);
if(condition !=null){
if(condition.getName() !=null&& !condition.getName().equals("")){
criteria.add(Restrictions.like("name", condition.getName(),MatchMode.ANYWHERE));
}
}
return criteria.list();
}*/
criteria.add(Restrictions.ilike("name", "鞋靴包",MatchMode.ANYWHERE));
//添加顺序条件
criteria.addOrder(Order.desc("id"));
criteria.addOrder(Order.asc("id"))
;
return criteria.list();
}