用户登录
用户注册

分享至

hibernate select top

  • 作者: Delimma隐
  • 来源: 51数据库
  • 2021-01-12
在ssh的hibernate中写上这个方法

public List findTop(){
log.debug("finding all Bulletin instances");
try {
String queryString = "select top 10 from Bulletin order by Bulletin_Time desc";

return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}

from Bulletin order by Bulletin_Time desc直接这么写的话可以执行
但是换成上面的语句就

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
Caused by:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
软件
前端设计
程序设计
Java相关