//重写了查询方法
public List queryNews(News news,int startPos,int pageSize) {
List list=new ArrayList();
Session session=this.getHibernateTemplate().getSessionFactory().openSession();
try{
Criteria criteria=session.createCriteria(News.class);
if(news!=null){
//Restrictions.eq 相等
if(!StringUtil.isNull(news.getTitle())){
criteria.add(Restrictions.like("title", "%"+news.getTitle()+"%"));
}
if(!StringUtil.isNull(news.getAuthor())){
criteria.add(Restrictions.like("author","%"+ news.getAuthor()+"%"));
}
}
criteria.setFirstResult(startPos);
criteria.setMaxResults(pageSize);
list=criteria.list();
//添加计算总数的代码
Integer count=(Integer)criteria.setProjection(Projections.count("newsId")).uniqueResult();
}catch (RuntimeException re) {
throw re;
}finally{
session.close();
}
return list;
}
补充一下Expression已经不被推荐使用了,Restrictions貌似包含了Expression的所有方法,just try。
criteria.add(Restrictions.in("id.fcurr", new String[] { "USD", "GBP", "JPY" } ));
具体方法,请参照http://www.dil.univ-mrs.fr/~massat/docs/hibernate-3.1/api/org/hibernate/criterion/Restrictions.html
其它参照http://hunterk.iteye.com/blog/129065
http://shizukyo.iteye.com/blog/262748
http://hi.baidu.com/yaoming159/blog/item/e0e489cb102ff814be09e6c7.html