2.Dao的查询
public List queryEmploy(TblHrinfo hrinfo,int startRow,int pageSize){
List list = new ArrayList();
List<TblHrinfo> result = new ArrayList();
Session session = this.getHibernateTemplate().
getSessionFactory().getCurrentSession();
Criteria criteria = session.createCriteria(TblHrinfo.class);
if(hrinfo != null){
System.out.println("---->hrinfo: "+hrinfo.getName()+" "+hrinfo.getStarttime());
if(null != hrinfo.getName()|| !"".equals(hrinfo.getName())){
criteria.add(Restrictions.like("name", hrinfo.getName().trim()));
}
if(null != hrinfo.getStarttime()|| !"".equals(hrinfo.getStarttime())){
criteria.add(Restrictions.eq("starttime", hrinfo.getStarttime().trim()));
}
if(null != hrinfo.getLeveltime()|| !"".equals(hrinfo.getLeveltime())){
criteria.add(Restrictions.eq("leveltime", hrinfo.getLeveltime().trim()));
}
}
System.out.println("---->startRow: "+startRow);
criteria.setFirstResult(startRow);
criteria.setMaxResults(pageSize);
result = criteria.list();
System.out.println("---->result: "+result.size());
list.add(0, result);
criteria.setFirstResult(0);
criteria.setProjection(Projections.projectionList().add(
Projections.rowCount()));
//获得满足条件的总记录数
int count = ((Integer) criteria.uniqueResult()).intValue();
list.add(1, new Integer(count));
return list;
}
3.jsp
<p:pages pageNo="pageNo" total="total"
includes="#tblHrinfo.name,#tblHrinfo.starttime,#tblHrinfo.leveltime"/>