hibernate中分页的实现

 hibernate中有两个接口可以有来实现分页:  
setFirstResult((currentPage-1)*pageSize+1);  
setMaxResults(pageSize);

 

做分页比较烦你还有定义一个分页工具类,对首页,第一页,下一页,尾页的定义
另外在DAO层就象2L所说的,用到HIBERNATE的那两个方法,然后在ACTION里调用,你可以参考以下代码:
工具类:

Java code

   
   

    
    
    
    public
    
     
    
    class
    
     Page {
    
    
    private
    
     
    
    boolean
    
     hasPrevious;
    
    
    private
    
     
    
    boolean
    
     hasNext;
    
    
    private
    
     
    
    int
    
     rowsPerPage
    
    =
    
    3
    
    ;
    
    
    private
    
     
    
    int
    
     maxPage
    
    =
    
    0
    
    ;
    
    
    private
    
     
    
    int
    
     curPage
    
    =
    
    1
    
    ;
    
    
    private
    
     
    
    int
    
     maxRows
    
    =
    
    0
    
    ;
    
    
    
    public
    
     
    
    void
    
     init(
    
    int
    
     maxRows, 
    
    int
    
     rowsPerPage) {
        
    
    this
    
    .maxRows
    
    =
    
    maxRows;
        
    
    this
    
    .rowsPerPage
    
    =
    
    rowsPerPage;
        
    
    if
    
     (maxRows
    
    ==
    
    0
    
    ) {
            maxPage
    
    =
    
    1
    
    ;
        }
    
    else
    
     {
            maxPage
    
    =
    
    (maxRows
    
    +
    
    rowsPerPage
    
    -
    
    1
    
    )
    
    /
    
    rowsPerPage;  
        }
    }
    
    
    public
    
     
    
    void
    
     first() {
        curPage
    
    =
    
    1
    
    ;
        
    
    this
    
    .setHasPrevious(
    
    false
    
    );
        refresh();
    }
    
    
    public
    
     
    
    void
    
     previous() {
        curPage
    
    --
    
    ;
        refresh();
    }
    
    
    public
    
     
    
    void
    
     next() {
        
    
    if
    
     (curPage
    
    <
    
    maxPage) {
            curPage
    
    ++
    
    ;
        }
        refresh();
    }
    
    
    public
    
     
    
    void
    
     last() {
        curPage
    
    =
    
    maxPage;
        
    
    this
    
    .setHasNext(
    
    false
    
    );
        refresh();
    }
    
    
    
    public
    
     
    
    int
    
     getCurPage() {
        
    
    return
    
     curPage;
    }
    
    
    public
    
     
    
    void
    
     setCurPage(
    
    int
    
     curPage) {
        
    
    this
    
    .curPage 
    
    =
    
     curPage;
        refresh();
    }
    
    
    public
    
     
    
    boolean
    
     isHasNext() {
        
    
    return
    
     hasNext;
    }
    
    
    public
    
     
    
    void
    
     setHasNext(
    
    boolean
    
     hasNext) {
        
    
    this
    
    .hasNext 
    
    =
    
     hasNext;
    }
    
    
    public
    
     
    
    boolean
    
     isHasPrevious() {
        
    
    return
    
     hasPrevious;
    }
    
    
    public
    
     
    
    void
    
     setHasPrevious(
    
    boolean
    
     hasPrevious) {
        
    
    this
    
    .hasPrevious 
    
    =
    
     hasPrevious;
    }
    
    
    public
    
     
    
    int
    
     getMaxPage() {
        
    
    return
    
     maxPage;
    }
    
    
    public
    
     
    
    void
    
     setMaxPage(
    
    int
    
     maxPage) {
        
    
    this
    
    .maxPage 
    
    =
    
     maxPage;
        refresh();
    }
    
    
    public
    
     
    
    int
    
     getMaxRows() {
        
    
    return
    
     maxRows;
    }
    
    
    public
    
     
    
    void
    
     setMaxRows(
    
    int
    
     maxRows) {
        
    
    this
    
    .maxRows 
    
    =
    
     maxRows;
        refresh();
    }
    
    
    public
    
     
    
    int
    
     getRowsPerPage() {
        
    
    return
    
     rowsPerPage;
    }
    
    
    public
    
     
    
    void
    
     setRowsPerPage(
    
    int
    
     rowsPerPage) {
        
    
    this
    
    .rowsPerPage 
    
    =
    
     rowsPerPage;
        refresh();
    }
    
    
    
    public
    
     
    
    void
    
     refresh() {
        
    
    if
    
     (maxPage
    
    <=
    
    1
    
    ) {
            hasPrevious
    
    =
    
    false
    
    ;
            hasNext
    
    =
    
    true
    
    ;
        } 
    
    else
    
     
    
    if
    
     (curPage
    
    ==
    
    1
    
    ) {
            hasPrevious
    
    =
    
    false
    
    ;
            hasNext
    
    =
    
    true
    
    ;
        } 
    
    else
    
     
    
    if
    
     (curPage
    
    ==
    
    maxPage) {
            hasPrevious
    
    =
    
    true
    
    ;
            hasNext
    
    =
    
    false
    
    ;
        } 
    
    else
    
     {
            hasPrevious
    
    =
    
    true
    
    ;
            hasNext
    
    =
    
    true
    
    ;
        }
    }
}

   
   

DAO层:

Java code

   
   

    
    
    
    public
    
     List selectProduct(
    
    int
    
     sortid ,Page pa) {
        Session sess
    
    =
    
    HibernateSessionFactory.getSession();
        Query q
    
    =
    
    sess.createQuery(
    
    "
    
    from Product p where p.sort.sid=?
    
    "
    
    );
        q.setInteger(
    
    0
    
    , sortid);
        q.setFirstResult((pa.getCurPage()
    
    -
    
    1
    
    )
    
    *
    
    pa.getRowsPerPage());
        q.setMaxResults(pa.getRowsPerPage());
        List list
    
    =
    
    q.list();
        sess.close();
        
    
    return
    
     list;
    }
   
   

ACTION:

Java code

   
   

    
    
    
    public
    
     
    
    class
    
     ProductAction 
    
    extends
    
     DispatchAction {

    
    private
    
     Page page
    
    =
    
    new
    
     Page();

    
    public
    
     ActionForward productPage(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response) {
        ShopMainImpl impl
    
    =
    
    new
    
     ShopMainImpl();
        String sortid
    
    =
    
    request.getParameter(
    
    "
    
    sid
    
    "
    
    );
        
    
    int
    
     sid
    
    =
    
    Integer.parseInt(sortid);
        
    
    int
    
     totalRows
    
    =
    
    impl.getMaxCount(sid);
        page.setMaxRows(totalRows);
        page.init(page.getMaxRows(), page.getRowsPerPage());
        String viewpage
    
    =
    
    request.getParameter(
    
    "
    
    viewpage
    
    "
    
    );
        String action
    
    =
    
    request.getParameter(
    
    "
    
    action
    
    "
    
    );
        
    
    if
    
     (viewpage
    
    !=
    
    null
    
     
    
    &&
    
     viewpage
    
    !=
    
    ""
    
    ) {
            page.setCurPage(Integer.parseInt(viewpage));
        }
        
    
    if
    
     (action
    
    !=
    
    null
    
    ) {
            
    
    if
    
     (action.equalsIgnoreCase(
    
    "
    
    first
    
    "
    
    )) {
                page.first();
            } 
    
    else
    
     
    
    if
    
     (action.equalsIgnoreCase(
    
    "
    
    previous
    
    "
    
    )) {
                page.previous();
            } 
    
    else
    
     
    
    if
    
     (action.equalsIgnoreCase(
    
    "
    
    next
    
    "
    
    )) {
                page.next();
            } 
    
    else
    
     
    
    if
    
     (action.equalsIgnoreCase(
    
    "
    
    last
    
    "
    
    )) {
                page.last();
            }
        }
        List product
    
    =
    
    impl.selectProduct(sid,page);
        request.setAttribute(
    
    "
    
    product
    
    "
    
    , product);
        request.setAttribute(
    
    "
    
    page
    
    "
    
    , page);
        request.setAttribute(
    
    "
    
    sid
    
    "
    
    , sid);
        
    
    return
    
     mapping.findForward(
    
    "
    
    main
    
    "
    
    );
    }
}
   
   

JSP:

Java code

   
   

    
    
    
    <
    
    td colspan
    
    =
    
    "
    
    4
    
    "
    
     align
    
    =
    
    "
    
    center
    
    "
    
    >
    
    
                
    
    <
    
    c:choose
    
    >
    
    
                    
    
    <
    
    c:when test
    
    =
    
    "
    
    <%=pa.getCurPage()==1 %>
    
    "
    
    >
    
    
                        首页
    
    &
    
    nbsp;上一页
                    
    
    </
    
    c:when
    
    >
    
    
                    
    
    <
    
    c:otherwise
    
    >
    
    
                        
    
    <
    
    a href
    
    =
    
    "
    
    product.do?method=productPage&sid=<%=request.getAttribute(
    
    "
    
    sid
    
    "
    
    ) %>&viewpage=&action=first
    
    "
    
    >
    
    首页
    
    </
    
    a
    
    >&
    
    nbsp;
                        
    
    <
    
    a href
    
    =
    
    "
    
    product.do?method=productPage&sid=<%=request.getAttribute(
    
    "
    
    sid
    
    "
    
    ) %>&viewpage=&action=previous
    
    "
    
    >
    
    上一页
    
    </
    
    a
    
    >&
    
    nbsp;
                    
    
    </
    
    c:otherwise
    
    >
    
    
                
    
    </
    
    c:choose
    
    >
    
    
                
    
    <
    
    c:choose
    
    >
    
    
                    
    
    <
    
    c:when test
    
    =
    
    "
    
    <%=pa.getCurPage()==pa.getMaxPage() %>
    
    "
    
    >
    
    
                        下一页
    
    &
    
    nbsp;尾页
                    
    
    </
    
    c:when
    
    >
    
    
                    
    
    <
    
    c:otherwise
    
    >
    
    
                        
    
    <
    
    a href
    
    =
    
    "
    
    product.do?method=productPage&sid=<%=request.getAttribute(
    
    "
    
    sid
    
    "
    
    ) %>&viewpage=&action=next
    
    "
    
    >
    
    下一页
    
    </
    
    a
    
    >&
    
    nbsp;
                        
    
    <
    
    a href
    
    =
    
    "
    
    product.do?method=productPage&sid=<%=request.getAttribute(
    
    "
    
    sid
    
    "
    
    ) %>&viewpage=&action=last
    
    "
    
    >
    
    尾页
    
    </
    
    a
    
    >&
    
    nbsp;
                    
    
    </
    
    c:otherwise
    
    >
    
    
                
    
    </
    
    c:choose
    
    >
    
    
            
    
    </
    
    td
    
    >