spring4 -- 基于jdbcTemplate的分页

项目中的通用分页组主要是分页类，下面的分页类是对网上常见的一个类的稍稍改造，针对的库是mysql，所以分页语句就比较简单，使用了limit关键字：

public class Page{
	//一页显示的记录数
	private int numPerPage;
	//记录总数
	private int totalRows;
	//总页数
	private int totalPages;
	//当前页码
	private int currentPage;
	//起始行数
	private int startIndex;
	//结束行数
	private int lastIndex;
	//结果集存放List
	private List<Map<String, Object>> resultList;
	
	
	/**分页构造函数
	* @param sql 包含筛选条件的sql，但不包含分页相关约束，如mysql的limit
	* @param currentPage 当前页
	* @param numPerPage 每页记录数
	* @param jTemplate JdbcTemplate实例
	*/
	public Page(String sql,int currentPage,int numPerPage,JdbcTemplate jTemplate){
		if(jTemplate == null){
		throw new IllegalArgumentException("Page.jTemplate is null");
		}else if(sql == null || sql.equals("")){
		throw new IllegalArgumentException("Page.sql is empty");
		}
		//设置每页显示记录数
		setNumPerPage(numPerPage);
		//设置要显示的页数
		setCurrentPage(currentPage);
		//计算总记录数
		StringBuffer totalSQL = new StringBuffer(" SELECT count(*) FROM ( ");
		totalSQL.append(sql);
		totalSQL.append(" ) totalTable ");
		//总记录数
		setTotalRows(jTemplate.queryForInt(totalSQL.toString()));
		//计算总页数
		setTotalPages();
		//计算起始行数
		setStartIndex();
		//计算结束行数
		setLastIndex();
		System.out.println("lastIndex="+lastIndex);
		//使用mysql时直接使用limits
		StringBuffer paginationSQL = new StringBuffer();
		paginationSQL.append(sql);
		paginationSQL.append(" limit " + startIndex + "," + lastIndex);
		//装入结果集
		setResultList(jTemplate.queryForList(paginationSQL.toString()));
	}
	
	public int getCurrentPage() {
		return currentPage;
	}
	
	public void setCurrentPage(int currentPage) {
		this.currentPage = currentPage;
	}
	
	public int getNumPerPage() {
		return numPerPage;
	}
	
	public void setNumPerPage(int numPerPage) {
		this.numPerPage = numPerPage;
	}
	
	public List<Map<String, Object>> getResultList() {
		return resultList;
	}
	
	public void setResultList(List<Map<String, Object>> resultList) {
		this.resultList = resultList;
	}
	
	public int getTotalPages() {
		return totalPages;
	}
	
	//计算总页数
	public void setTotalPages() {
		if(totalRows % numPerPage == 0){
			this.totalPages = totalRows / numPerPage;
		}else{
			this.totalPages = (totalRows / numPerPage) + 1;
		}
	}
	
	public int getTotalRows() {
		return totalRows;
	}
	
	public void setTotalRows(int totalRows) {
		this.totalRows = totalRows;
	}
	
	public int getStartIndex() {
		return startIndex;
	}
	
	public void setStartIndex() {
		this.startIndex = (currentPage - 1) * numPerPage;
	}
	
	public int getLastIndex() {
		return lastIndex;
	}


	//计算结束时候的索引
	public void setLastIndex() {
		System.out.println("totalRows="+totalRows);///
		System.out.println("numPerPage="+numPerPage);///
		if( totalRows < numPerPage){
			this.lastIndex = totalRows;
		}else if((totalRows % numPerPage == 0) || (totalRows % numPerPage != 0 && currentPage < totalPages)){
			this.lastIndex = currentPage * numPerPage;
		}else if(totalRows % numPerPage != 0 && currentPage == totalPages){//最后一页
			this.lastIndex = totalRows ;
		}
	}
}

dao层：

       /**
	 * 查询包含所有字段的分页数据
	 * @param tableName
	 * @param where
	 * @return
	 */
	public List<Map<String, Object>> getPageListAllCol(String tableName,String where,int currentPage,int numPerPage){
		String sql = "select * from " + tableName + where; 
		Page page = new Page(sql, currentPage, numPerPage, sjc);
		return page.getResultList();
	}

部分数据结果：

totalRows=60
numPerPage=15
lastIndex=15

其中分页类中用到的数据源，是由dao层作为参数传递进去的，dao层的数据源使用@autowared自动注入，具体注入可参考前面内容