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

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

  

/**
   * 查询当前记录的前一条记录,并返回主键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;

  }