应用Hibernate3的DetachedCriteria实现分页查询

来源：作者：robbin 出处：巧巧读书 2008-02-11 进入讨论组

关键词：
hibernate
update
spring
java

Hibernate3提供了DetachedCriteria，使得我们可以在Web层构造detachedCriteria，然后调用业务层Bean，进行动态条件查询，根据这一功能，我设计了通用的抽象Bean基类和分页类支持，代码来自于Quake Wang的javaeye-core包的相应类，然后又做了很多修改。

分页支持类：

package com.javaeye.common.util;

import java.util.List;

public class PaginationSupport ...{

    public final static int PAGESIZE = 30;

    private int pageSize = PAGESIZE;

    private List items;

    private int totalCount;

    private int[] indexes = new int[0];

    private int startIndex = 0;

    public PaginationSupport(List items, int totalCount) ...{
        setPageSize(PAGESIZE);
                setTotalCount(totalCount);
        setItems(items);
        setStartIndex(0);
    }

    public PaginationSupport(List items, int totalCount, int startIndex) ...{
                setPageSize(PAGESIZE);
        setTotalCount(totalCount);
        setItems(items);
        setStartIndex(startIndex);
    }

    public PaginationSupport(List items, int totalCount, int pageSize, 
                  int startIndex) ...{
                setPageSize(pageSize);
        setTotalCount(totalCount);
        setItems(items);
        setStartIndex(startIndex);
    }

    public List getItems() ...{
        return items;
    }

    public void setItems(List items) ...{
        this.items = items;
    }

    public int getPageSize() ...{
        return pageSize;
    }

    public void setPageSize(int pageSize) ...{
        this.pageSize = pageSize;
    }

    public int getTotalCount() ...{
        return totalCount;
    }

    public void setTotalCount(int totalCount) ...{
        if (totalCount > 0) ...{
            this.totalCount = totalCount;
            int count = totalCount / pageSize;
            if (totalCount % pageSize > 0)
                count++;
            indexes = new int[count];
            for (int i = 0; i < count; i++) ...{
                indexes[i] = pageSize * i;
            }
        } else ...{
            this.totalCount = 0;
        }
    }

    public int[] getIndexes() ...{
        return indexes;
    }

    public void setIndexes(int[] indexes) ...{
        this.indexes = indexes;
    }

    public int getStartIndex() ...{
        return startIndex;
    }

    public void setStartIndex(int startIndex) ...{
        if (totalCount <= 0)
            this.startIndex = 0;
        else if (startIndex >= totalCount)
            this.startIndex = indexes[indexes.length - 1];
        else if (startIndex < 0)
            this.startIndex = 0;
        else ...{
            this.startIndex = indexes[startIndex / pageSize];
        }
    }

    public int getNextIndex() ...{
        int nextIndex = getStartIndex() + pageSize;
        if (nextIndex >= totalCount)
            return getStartIndex();
        else
            return nextIndex;
    }

    public int getPreviousIndex() ...{
        int previousIndex = getStartIndex() - pageSize;
        if (previousIndex < 0)
            return 0;
        else
            return previousIndex;
    }

}

图文结合：http://www.qqread.com/dotnet/d396758.html