`
yeminping
  • 浏览: 177670 次
  • 性别: Icon_minigender_1
  • 来自: 福州
社区版块
存档分类
最新评论

利用Spring + Hibernate如何实现提取数据库top语句

    博客分类:
  • JAVA
阅读更多

如何用Spring+Hibernate实现如下SQL语句:


Hibernate: select top 10
word0_.Fguid as Fguid1_, word0_.FAdjunct as FAdjunct1_, word0_.FAuditDate as FAuditDate1_, word0_.FAuditDeptID as FAuditDe4_1_, word0_.FAuditPoint as FAuditPo5_1_, word0_.FContent as FContent1_, word0_.FCoteID as FCoteID1_, word0_.Fdeleted as Fdeleted1_, word0_.FKeyWord as FKeyWord1_, word0_.Fnote as Fnote1_, word0_.Foperator as Foperator1_, word0_.FReCount as FReCount1_, word0_.Fsubject as Fsubject1_, word0_.FTreeID as FTreeID1_, word0_.FType as FType1_, word0_.FViewCount as FViewCount1_, word0_.FWriteTime as FWriteTime1_ from F3Center.dbo.J_ZX_WORD word0_ order by word0_.FViewCount desc


在实现类上写入如下语句:


getHibernateTemplate().setMaxResults(10);

List findByNamedQuery = getHibernateTemplate().findByNamedQuery("Word.findByPopWord");


 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics