y要什么链表?
用sql查询上一篇
SELECT id,title FROM t_article WHERE id<10 ORDER BY id DESC LIMIT 1;
用sql查下一篇
SELECT id,title FROM t_article WHERE id>10 ORDER BY id ASC LIMIT 1;
结果hql不支持limit,如何解决呢
https://blog.csdn.net/w410589502/article/details/56015574/
String hql = "FROM ArticleModel WHERE id< " + id + " ORDER BY id DESC "; //上一篇
Query query = session.createQuery(hql);
query.setMaxResults(1); //只查询一篇
String hql = "FROM ArticleModel WHERE id> " + id + " ORDER BY id ASC "; //下一篇
Query query = session.createQuery(hql);
query.setMaxResults(1); //只查询一篇