JavaEE人力资源管理

package com.edu.neusoft.spring.common; import java.util.List; import org.springframework.jdbc.core.JdbcTemplate; public class PagingList { private int rowCount = 0; // ��¼���� private int pageCount = 1; // ��ҳ���� private int pageSize = 5; // ÿҳ��¼�� private int pageNow = 1; // ��ǰҳ�� private int startIndex = 1; // ��ʼ��¼�� private int endIndex = 1; // �����¼�� private String srcSqlForCount;// ���ڼ����¼������SQL��� private String srcSql;// ԴSQL��� private List list;// ��¼�б� public PagingList(String srcSql, Object[] params, int pageNow, int pageSize, JdbcTemplate jdbcTemplate) { this(getCountSql(srcSql), srcSql, params, pageNow, pageSize, jdbcTemplate); } public PagingList(String srcSqlForCount, String srcSql, Object[] params, int pageNow, int pageSize, JdbcTemplate jdbcTemplate) { this.srcSqlForCount = srcSqlForCount; this.srcSql = srcSql; if (pageNow > 0) { this.pageNow = pageNow; } if (pageSize > 0) { this.pageSize = pageSize; } execute(jdbcTemplate, params); } private void execute(JdbcTemplate jdbcTemplate, Object[] params) { this.rowCount = jdbcTemplate.queryForObject(srcSqlForCount, Integer.class, params); if ((rowCount % pageSize) == 0) { pageCount = rowCount / pageSize; } else { pageCount = rowCount / pageSize + 1; } if (pageCount == 0) { pageCount = 1; } if (pageNow > pageCount && rowCount != 0) { pageNow = pageCount; } startIndex = (pageNow - 1) * pageSize + 1; endIndex = (pageNow) * pageSize; Object[] tmp = null; if (params != null) { int pLen = params.length; tmp = new Object[pLen + 2]; System.arraycopy(params, 0, tmp, 0, pLen); tmp[pLen] = new Integer(getStartIndex() - 1); tmp[pLen + 1] = new Integer(pageSize); } else { tmp = new Object[] { new Integer(getStartIndex() - 1), new Integer(pageSize) }; } setList(jdbcTemplate.queryForList(getPagingSql(), tmp)); } public List getList() { return list; } public void setList(List list) { this.list = list; } public String getPagingSql() { return getPagingSql(srcSql); } public int getStartIndex() { return startIndex; } public Integer getStartIndexInt() { return new Integer(startIndex); } public int getEndIndex() { return endIndex; } public Integer getEndIndexInt() { return new Integer(endIndex); } public int getPageCount() { return pageCount; } public int getPageNow() { return pageNow; } public int getPageSize() { return pageSize; } public int getRowCount() { return rowCount; } public static String getPagingSql(String srcSql) { StringBuffer pagingSql = new StringBuffer(); pagingSql.append("SELECT * FROM ( "); pagingSql.append(srcSql); pagingSql.append(" ) _t LIMIT ?, ?"); return pagingSql.toString(); } public static String getCountSql(String srcSql) { return "SELECT COUNT(*) FROM ( " + srcSql + " ) _t"; } }