最近写的一个 SSH 分页

公司抛弃很久以前的代码框架（简单使用Hibernate+Struts1，Hibernate 只是用来做 saveOrUpdate、remove、get，分页查询还是用SQL的)，新项目代码SSH2框架让我搞，将SSH2 分页设计记录一下。因为分页要考虑 Struts2 及 Flex 里使用，所以页码也直接在分页类里算了。然后对应 jsp、flex 表现做一个分页导航（Flex 不是我做，不怎么会呢）。

DAO 中分页方法：

    /** 
     * get appCodes by Pagination 
     *  
     * @param appCode 
     * @param pagination 
     */  
    @SuppressWarnings("unchecked")  
    public Pagination getAppCodes(final AppCode appCode, final Pagination pagination) {  
        HibernateCallback callback = new HibernateCallback() {  

            @Override  
            public Object doInHibernate(Session session) throws HibernateException, SQLException {  
                int totalRow = 0;  
                List<AppCode> objList = new ArrayList<AppCode>();  
                try {  
                    Criteria criteria = session.createCriteria(AppCode.class);  
                    // 只查状态有效的  
                    criteria.add(Restrictions.eq("status", CConstants.VALID));  
                    totalRow = (Integer) criteria.setProjection(Projections.rowCount()).uniqueResult();  
                    criteria.setProjection(null);  
                    pagination.setTotalRow(totalRow);  
                    objList = criteria.addOrder(Order.asc("category")).addOrder(Order.asc("codeId")).setFirstResult(pagination.getStartRow()).setMaxResults(pagination.getPageSize()).list();  
                    pagination.setObjList(objList);  
                } catch (Exception e) {  
                    log.error("uh oh, getappCodes by Pagination failed...");  
                    e.printStackTrace();  
                }  
                return pagination;  
            }  
        };  
        return (Pagination) getHibernateTemplate().execute(callback);  
    }  

Service 对应方法：

   /** 
     * get appCodes by Pagination 
     * @param appCode 
     * @param pagination 
     */  
    public Pagination getAppCodes(AppCode appCode, Pagination pagination) {
        return appCodeDao.getAppCodes(appCode, pagination);  
    }  

    /* 因为同事说 Flex 那边封装多个 Map 参数的方法给他调用，而且方法签名都一样，所以多了以下方法 */
    /** 
     * get appCodes by Pagination for Flex 
     * @param map 
     * @param pagination 
     */  
    public Pagination query(Map<String, String> map, Pagination pagination) {  
        if (map.isEmpty()) {  
            return getAppCodes(new AppCode(), pagination);  
        }  
        AppCode appCode = new AppCode();  
        if (StringUtils.isNotEmpty(map.get("id"))) {  
            appCode.setId(map.get("id"));  
        }  
        if (StringUtils.isNotEmpty(map.get("codeId"))) {  
            appCode.setCodeId(map.get("codeId"));  
        }  
        if (StringUtils.isNotEmpty(map.get("codeName"))) {  
            appCode.setCodeName(map.get("codeName"));  
        }  
        if (StringUtils.isNotEmpty(map.get("category"))) {  
            appCode.setCategory(map.get("category"));  
        }  
        if (StringUtils.isNotEmpty(map.get("categoryDesc"))) {  
            appCode.setCategoryDesc(map.get("categoryDesc"));  
        }  
        if (StringUtils.isNotEmpty(map.get("description"))) {  
            appCode.setDescription(map.get("description"));  
        }  
        if (StringUtils.isNotEmpty(map.get("status"))) {  
            appCode.setStatus(map.get("status"));  
        }  
        if (StringUtils.isNotEmpty(map.get("createDate"))) {  
            appCode.setCreateDate(DateTypeConverter.convertFromString(map.get("createDate")));  
        }  
        return getAppCodes(appCode, pagination);  
    }  

Struts2 Action 代码：

@SuppressWarnings("serial")  
public class AppCodeAction extends BaseAction{  

    @Resource(name="appCodeService")  
  private AppCodeService appCodeService;  
  private AppCode appCode;  

    public AppCode getAppCode() {  
        return appCode;  
    }  

    public void setAppCode(AppCode appCode) {  
        this.appCode = appCode;  
    }  

    public String query() {  
        if (LOG.isDebugEnabled()) {  
            LOG.debug("Entering query method...");  
        }  
        if (this.pagination == null) {  
            this.pagination = new Pagination(CConstants.PAGE_SIZE);  
        }  
        if (this.appCode == null) {  
            this.appCode = new AppCode();  
        }  
        try{  
            this.pagination = appCodeService.getAppCodes(appCode, pagination);  
        }catch (Exception e) {  
            addActionError(getText("search.exception", new String []{getText("AppCode")}));  
            return ERROR;  
        }  
        return SUCCESS;  
    }  
}  

BaseAction 代码

import com.opensymphony.xwork2.ActionSupport;  
import com.tjsoft.util.Pagination;  
@SuppressWarnings("serial")  
public class BaseAction extends ActionSupport {  

    /** 分页类 */  
    protected Pagination pagination;  

    public Pagination getPagination() {  
        return pagination;  
    }  

    public void setPagination(Pagination pagination) {  
        this.pagination = pagination;  
    }  

    public String preAdd(){  
        if (LOG.isDebugEnabled()) {  
            LOG.debug("entering preAdd  method...");  
        }  
        return INPUT;  
    }  

}  

分页导航代码：

<%@ page contentType="text/html; charset=UTF-8"%>  
<%@ include file="/pages/taglibs.jsp" %>  
<s:if test="#request.pagination.totalPage>0">  
    <div class="pageDiv" id="pageDiv">  
        <!-- 总记录数   
        <span>${pagination.totalRow}</span>-->  
        <!-- 当前页/总页数   
        <span>${pagination.currentPage}/${pagination.totalPage}</span>-->  
        <!-- 当前页不是第一页时生成首页和上一页 -->  
        <c:if test="${pagination.currentPage>1}">  
            <span onclick="doPage('1')"><a>首页</a></span>  
            <span onclick="doPage('pre')"><a>« 上一页</a></span>  
        </c:if>  
        <!-- 计算要分几次显示页码，每次显示10页 -->  
        <c:choose>  
            <c:when test="${pagination.totalPage %10 > 0}">  
                <c:set var="count" value="${pagination.totalPage/pagination.pageSize+1}" />  
            </c:when>  
            <c:otherwise>  
                <c:set var="count" value="${pagination.totalPage/pagination.pageSize}" />  
            </c:otherwise>  
        </c:choose>  
        <!-- count > 1 -->  
        <c:choose>  
            <c:when test="${count - 1 > 1}">  
                <!-- 1~10页先生成 -->  
                <label id="p_1" class="cruLabel">  
                <c:forEach var="p" begin="1" end="10">  
                    <span onclick="doPage('${p}')" <c:if test="${p==pagination.currentPage}">class='selected'</c:if>><a>${p}</a></span>  
                </c:forEach>  
                <span onclick="doPageLabel('p_2')"><a> »</a></span>  
                </label>  
                <c:forEach var="index" begin="2" end="${count}">  
                <label id="p_${index}" class="hideLabel">  
                    <span onclick="doPageLabel('p_${index-1}')"><a>« </a></span>  
                    <c:forEach items="${pagination.pages}" var="page" begin="${(index-1)*pagination.pageSize}" end="${index*pagination.pageSize-1}">  
                        <c:if test="${page>10}">  
                            <span onclick="doPage('${page}')" <c:if test="${page==pagination.currentPage}">class='selected'</c:if>><a>${page}</a></span>  
                        </c:if>  
                    </c:forEach>  
                    <c:if test="${count - index > 1}">  
                        <span onclick="doPageLabel('p_${index+1}')"><a> »</a></span>  
                    </c:if>  
                </label>  
                </c:forEach>  
            </c:when>  
            <c:otherwise>  
                <c:forEach items="${pagination.pages}" var="page">  
                    <span onclick="doPage('${page}')" <c:if test="${page==pagination.currentPage}">class='selected'</c:if>><a>${page}</a></span>  
                </c:forEach>  
            </c:otherwise>  
        </c:choose>  
        <!-- 当前页不是最后页时生成下一页 末页 -->  
        <c:if test="${pagination.currentPage!=pagination.totalPage}">  
            <span onclick="doPage('next')"><a>下一页 »</a></span>  
        <!-- <span onclick="doPage('${pagination.totalPage}')"><a>末页</a></span>-->  
        </c:if>  
        <!--<span>转到</span>  
        <select id="to_p">  
            <c:forEach items="${pagination.pages}" var="tp">  
                <option value="${tp}"  
                    <c:if test="${tp eq pagination.currentPage}">  
                    selected="selected"  
                    </c:if>  
                >${tp}</option>  
            </c:forEach>  
        </select>  
        <span>页</span>  
        <span onclick="doPage(document.getElementById('to_p').value)">确定</span>-->  
    </div>  
  </s:if>  
<script type="text/javascript">  
/*** 翻页*/  
function doPage(page){  
    var form=document.forms[0];  
    if('${pagination.currentPage}'===page){  
        return;  
    }else if("next"===page){  
        if('${pagination.currentPage}'=='${pagination.totalPage}')return;  
        form.action='<s:url />?pagination.currentPage='+(new Number('${pagination.currentPage}')+1);  
    }else if("pre"===page){  
        if('${pagination.currentPage}'==1)return;  
        form.action='<s:url />?pagination.currentPage='+(new Number('${pagination.currentPage}')-1);  
    }else {  
        form.action='<s:url />?pagination.currentPage='+page;  
    }  
    form.submit();  
}  
</script>

[img]http://dl.iteye.com/upload/attachment/198986/515edc88-c097-34dc-a48d-32b1ece95b9e.jpg[/img]

[img]http://dl.iteye.com/upload/attachment/198984/0c7e6325-776b-34ff-913d-eb2a2f2c92e9.jpg[/img]