Query query = em.createQuery("select id,title from Article where id>:id order by publishtime asc");
query.setParameter("id", id);
query.setMaxResults(1);
query.setParameter("id", id);
query.setMaxResults(1);
List<Object[]> list = query.getResultList();
查询下一条记录,结果集保存类型Object[]数组。
或者查询整个对象:
Query query = em.createQuery("from Article where id>:id order by publishtime desc");
query.setParameter("id", id);
query.setFirstResult(0);
query.setMaxResults(1);
List<Article> list = query.getResultList();