HQL实现新闻上一篇下一篇

来源:互联网 发布:淘宝助理手机 编辑:程序博客网 时间:2024/04/28 20:56




要实现新闻的上一篇下一篇功能,关键是HQL语句

上一篇:HQL="from News d where d.id<? order by id desc";

下一篇:HQL="from News d where d.id>? order by id asc ";


daoImpl实现的方法:

public News nextPage(News news){try{String queryString="from News d where d.id<? order by id desc";Query queryObject=getSession().createQuery(queryString);queryObject.setLong(0,news.getId());queryObject.setFirstResult(0);queryObject.setMaxResults(1);<pre name="code" class="java">public News nextPage(News news) {try {String queryString = "from News d where d.id>? order by id asc";Query queryObject = getSession().createQuery(queryString);queryObject.setLong(0,news.getId());queryObject.setFirstResult(0);queryObject.setMaxResults(1);return (News)queryObject.list().get(0);} catch (RuntimeException re) {throw re;}}

return (News)queryObject.list().get(0);}catch(RuntimeException re){throw re;}}


0 0
原创粉丝点击