Hibernate中显示前一条，后一条记录

最新推荐文章于 2021-08-01 18:33:06 发布

夜梦星辰

最新推荐文章于 2021-08-01 18:33:06 发布

阅读量85

点赞数

分类专栏： J2EE 文章标签： Hibernate

本文链接：https://blog.csdn.net/babala_234/article/details/83526901

版权

J2EE 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

哪位有更好的方法，贡献下，谢了先！

/**
   * 查询当前记录的前一条记录,并返回主键id
   * 
   * @author Neeao(njl) 2007-7-17
   * @param id
   * @return
   * @throws DAOException
   */
  public int before(int id) throws DAOException {
    int strid = 0;
    Session session = SessionManager.getSession(); 

    String hql = "from MailList as maillist where maillist.id<" + id
        + " order by maillist.id desc";
    Query query = session.createQuery(hql);
    query.setFirstResult(0);
    query.setMaxResults(1);
    List list = query.list();

    if (list != null && list.size() > 0) {
      MailList mailList = (MailList) list.get(0);
      strid = mailList.getId();
    }
    return strid;

  }

  /**
   * 查询当前记录的下一条记录,并返回主键id
   * 
   * @author Neeao(njl) 2007-7-17
   * @param id
   * @return
   * @throws DAOException
   */
  public int next(int id) throws DAOException {
    int strid = 0;
    Session session = SessionManager.getSession();
    String hql = "from MailList as maillist where maillist.id> " + id
        + " order by maillist.id";
    Query query = session.createQuery(hql);
    query.setFirstResult(0);
    query.setMaxResults(1);
    List list = query.list();

    if (list != null && list.size() > 0) {
      MailList mailList = (MailList) list.get(0);
      strid = mailList.getId();
    }
    return strid;

  }