使用本地化的SQL语句,可以达到一样的效果
Query query = session.createSQLQuery(" select top 10 * from newInfo where newID not in (select top 10 newID from newInfo newID desc ) and newID desc "); //用本地sql可以不
Java codeString hql="from Answer order by clickcount desc";
Query query=session.createQuery(hql);
query.setFirstResult(0);
query.setMaxResult(10);
List list=query.list();
无意中,发现一个重大问题
setMaxResult少了个s也
应该是setMaxResults
应该改成这样
Java codeString hql="from Answer a order by a.clickcount desc";
Query query=session.createQuery(hql);
query.setFirstResult(0);
query.setMaxResults(10);
List list=query.list();
[Quote=引用 12 楼 robyjeffding 的回复:]
使用本地化的SQL语句,可以达到一样的效果
Query query = session.createSQLQuery(" select top 10 * from newInfo where newID not in (select top 10 newID from newInfo newID desc ) and newID desc "); //用本地sql可以不