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?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-23?14:40??renliziyuan\
?????文件?????????727??2015-06-23?10:39??renliziyuan\.classpath
?????文件????????1046??2015-06-23?14:34??renliziyuan\.project
?????目錄???????????0??2015-06-23?14:36??renliziyuan\.settings\
?????文件?????????503??2015-06-23?10:39??renliziyuan\.settings\.jsdtscope
?????文件?????????364??2015-06-23?10:39??renliziyuan\.settings\org.eclipse.jdt.core.prefs
?????文件?????????491??2015-06-23?14:34??renliziyuan\.settings\org.eclipse.wst.common.component
?????文件?????????305??2015-06-23?10:39??renliziyuan\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-06-23?10:39??renliziyuan\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-06-23?10:39??renliziyuan\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\spring\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\springmvc\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\springmvc\controller\
?????文件????????1698??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\springmvc\controller\LoginController.class
?????文件????????4086??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\springmvc\controller\TeacherController.class
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\spring\common\
?????文件????????3876??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\common\PagingList.class
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\spring\dao\
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\spring\dao\impl\
?????文件????????2689??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\dao\impl\TeacherDaoImpl.class
?????文件????????1211??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\dao\impl\UserDaoImpl.class
?????文件?????????311??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\dao\TeacherDao.class
?????文件?????????182??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\dao\UserDao.class
?????目錄???????????0??2015-06-23?14:36??renliziyuan\build\classes\com\edu\neusoft\spring\model\
?????文件????????1517??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\model\Teacher.class
?????文件????????1223??2015-06-23?14:34??renliziyuan\build\classes\com\edu\neusoft\spring\model\User.class
............此處省略90個文件信息