1、第一種方式

public class DetailDaoImpl extends HibernateTemplate implements?DetailDaoInterface {

　　private Log log=LogFactory.getLog(ConstantsApplication. P2PAPPLICATION_LOG );

/**
?* 查詢符合條件的指定區(qū)間的記錄
?*/
?public List<AppInfoPO> queryApproveDetailInfo(ApproveDetailQueryModel qm,?int startNumber, int maxNumber) throws APSException {

　　log.info("開(kāi)始查詢明細(xì)……");
??　　try{

　　　　DetachedCriteria c = this.getDetachedCriteria(qm);
???　　　return? findByCriteria (c,startNumber,maxNumber);

　　　　} catch (Exception e) {
???　　　　　　log.error("查詢明細(xì)異常", e);
??　　　　　　?throw new APSException("查詢明細(xì)異常，在方法queryApproveDetailInfo中", e);
??　　　}

}

/**
? * 查詢符合條件的記錄數(shù)
? */
?public int queryApproveDetailInfoCount(ApproveDetailQueryModel qm) throws APSException {

　　log.info("開(kāi)始查詢審批明細(xì)……");
??　　DetachedCriteria d = this.getDetachedCriteria(qm);
?　　?d.setProjection(Projections.rowCount());
?　　?List list = this.findByCriteria(d);
??　　if (list != null && list.size() > 0)
???　　return Integer.valueOf(list.get(0).toString());
?　　?return 0;

}

/**
?* 創(chuàng)建公共查詢條件
?* @param qm
?* @return
?*/
?public DetachedCriteria? getDetachedCriteria(ApproveDetailQueryModel qm){
??　　 ?DetachedCriteria c = DetachedCriteria.forClass(AppInfoPO.class);
????????? if(!CommonMethod.isNull(qm.getCreditDateisnotnull())){
???????? 　　c.add( Property .forName("creditDate").isNotNull());
????????? }

　　　　c.addOrder(Order.asc("creditName"));
????　　c.addOrder(Order.desc("creditDate"));?
????　　return c;

}

2、SQL分頁(yè)

Query query = session.createQuery(hql);
query.setFirstResult(offset);
query.setMaxResults(length);
List list = query.list();

?

hxzon

public List getCategorys(final int currentpage, final int pagesize) {
log.debug("finding all ShbbsCategory instances");

?? List list = getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String hql = "from ShbbsCategory";
Query query = session.createQuery(hql);
query. setFirstResult ((currentpage - 1) * pagesize);
query.setMaxResults(pagesize);
List list = query.list();
return list;
}
});
return list;

}

預(yù)編譯

String hql = "FROM ShbbsCategory AS p WHERE p.uid LIKE ? OR p.name LIKE ?";
Query query = session.createQuery(hql);
query. setString (0, "%" + cond + "%");
query.setString(1, "%" + cond + "%");
query.setFirstResult((currentpage - 1) * pagesize);
query.setMaxResults(pagesize);

集合總數(shù)1

public Integer getSaleChanceListCount() {????

　　final String hql = "select count(*) from SaleChanceInfo si";????

?　　Query query = arg0.createQuery(hql);????

　　return query. uniqueResult ();????

}

集合總數(shù)2

String hql = "SELECT COUNT(p.id) from Person AS p WHERE p.uid LIKE ? OR p.name LIKE ?";

Query query = session.createQuery(hql);

List list = query.list();

? if (list.size() > 0) {
count = (Integer) list.get(0);
}
return count;

3、通過(guò)Criteria實(shí)現(xiàn)分頁(yè)

Criteria criteria = session.createCriteria(?Class arg);

criteria.setFirstResult(offset);
criteria.setMaxResults(length);

return criteria.list();

?

QBC分頁(yè)查詢