hibernate 中的hql 语句累积

1./只查询十条数据

@SuppressWarnings("unchecked")

@Override
public List<NewsInfoEntity> listHotNews() {
List<NewsInfoEntity> lst = new ArrayList<NewsInfoEntity>();
try {
String hql = "from NewsInfoEntity order by pubTime desc";
Query query = getHibernateTemplate().getSessionFactory().openSession().createQuery(hql);
query.setFirstResult(0);
query.setMaxResults(10);
lst = (List<NewsInfoEntity>)query.list();
} catch (DataAccessException e) {
e.printStackTrace();
}
return lst;

}

2.我先先看例子。

@SuppressWarnings("unchecked")
@Override
public List<ProxyBidEntity> queryMaxPriceTwoDiffentAuctionItem(AuctionItemEntity ai, Double price) {
Date date=Calendar.getInstance().getTime();
String hql ="from ProxyBidEntity pb where pb.auctionItem.closed=false and pb.auctionItem=:auctionItem and pb.auctionItem.auctionEvent.startTime<=:date and pb.maxBid>=:price group by pb.maxBid order by pb.maxBid";
Query query = getHibernateTemplate().getSessionFactory()
.openSession().createQuery(hql);
query.setParameter("auctionItem", ai); //参数对象是 对象
query.setTimestamp("date", date); //参数对象是 时间类型
query.setParameter("price", price); //参数对象是 对象 我们可以看到setParameter这个方法第二个参数是对象 因而我们的基本类型都是对象
query.setFirstResult(0);
query.setMaxResults(2); //筛选返回结果的个数
List<ProxyBidEntity> lst = (List<ProxyBidEntity>)query.list();
return lst;
}

//这个语句的难点是group by 和 order by 同时使用 group by 在前， order by 在后