package?mvc.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;
		}
		//?判斷pageNum是否過界
		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;
	}

	/**
	?*?獲取加入分頁功能的SQL語句
	?*/
	public?String?getPagingSql（）?{
		return?getPagingSql（srcSql）;
	}

	public?int?getStartIndex（）?{
		return?startIndex;
	}

	/**
	?*?獲得起始記錄數的Integer形式
	?*/
	public?Integer?getStartIndexInt（）?{
		return?new?Integer（startIndex）;
	}

	public?int?getEndIndex（）?{
		return?endIndex;
	}

	/**
	?*?獲得結束記錄數的Integer形式
	?*/
	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;
	}

	/**
	?*?將源SQL語句增加分頁功能
	?*/
	public?static?String?getPagingSql（String?srcSql）?{
		StringBuffer?pagingSql?=?new?StringBuffer（）;
		pagingSql.append（“SELECT?*?FROM?（?“）;
		pagingSql.append（srcSql）;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????842??2016-10-22?21:51??greengrocer03\.classpath

?????文件???????1254??2016-04-16?21:19??greengrocer03\.project

?????文件????????503??2015-05-10?09:51??greengrocer03\.settings\.jsdtscope

?????文件????????130??2016-10-22?22:16??greengrocer03\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-09-29?16:36??greengrocer03\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2016-03-12?11:25??greengrocer03\.settings\org.eclipse.wst.common.component

?????文件????????345??2016-10-22?21:51??greengrocer03\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-05-10?09:51??greengrocer03\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-05-10?09:51??greengrocer03\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????456??2015-05-10?09:59??greengrocer03\.springBeans

?????文件????????111??2016-04-14?10:45??greengrocer03\build\classes\jdbc.properties

?????文件???????3838??2016-10-22?22:16??greengrocer03\build\classes\mvc\common\PagingList.class

?????文件???????3432??2016-10-22?22:16??greengrocer03\build\classes\mvc\controller\BillController.class

?????文件???????3601??2016-10-22?22:16??greengrocer03\build\classes\mvc\controller\CollectionController.class

?????文件???????7099??2016-10-22?22:16??greengrocer03\build\classes\mvc\controller\GoodsController.class

?????文件???????3342??2016-10-22?22:16??greengrocer03\build\classes\mvc\controller\MessageController.class

?????文件???????6265??2016-10-22?22:16??greengrocer03\build\classes\mvc\controller\UserController.class

?????文件????????324??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\BillDao.class

?????文件????????422??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\CollectionDao.class

?????文件????????495??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\GoodsDao.class

?????文件???????1439??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\BillDaoIm$1.class

?????文件???????2636??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\BillDaoIm.class

?????文件???????1370??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\CollectionDaoImp$1.class

?????文件????????905??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\CollectionDaoImp$2.class

?????文件???????2991??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\CollectionDaoImp.class

?????文件???????1600??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\GoodsDaoImp$1.class

?????文件????????941??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\GoodsDaoImp$2.class

?????文件???????1491??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\GoodsDaoImp$3.class

?????文件???????3631??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\GoodsDaoImp.class

?????文件???????1287??2016-10-22?22:16??greengrocer03\build\classes\mvc\dao\im\MessageDaoImp$1.class

............此處省略164個文件信息