package?org.pagedemo.biz;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Iterator;
import?java.util.List;

import?org.pagedemo.dao.baseDao;
import?org.pagedemo.entity.PageBean;
import?org.pagedemo.entity.Person;

public?class?PersonBiz?{

	private?baseDao?baseDao?=?new?baseDao（）;

	//?分頁查詢
	public?void?listPage（PageBean?pageBean）?{
		//?1.獲得總記錄數(shù)
		String?countSql?=?“select?count（*）?from?sanguo“;
		ResultSet?rs?=?baseDao.executeQuery（countSql）;
		try?{
			rs.next（）;//?結(jié)果集游標下移一位
			int?totalRecord?=?rs.getInt（1）;
			pageBean.setTotalRecord（totalRecord）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}

		//防止當前頁越界
		if?（pageBean.getCurrent（）?>?pageBean.getTotalPage（））?{
			pageBean.setCurrent（pageBean.getTotalPage（））;
		}

		//?2.獲得區(qū)間數(shù)據(jù)
		String?limitSql?=?“select?top?“?+?pageBean.getPageSize（）
				+?“?*?from?sanguo?where?id?not?in（select?top?“
				+?（pageBean.getCurrent（）?-?1）?*?pageBean.getPageSize（）
				+?“?id?from?sanguo）“;
		rs?=?baseDao.executeQuery（limitSql）;
		try?{
			List?list?=?new?ArrayList（）;
			while?（rs.next（））?{
				Person?p?=?new?Person（）;
				p.setId（new?Integer（rs.getInt（1）））;
				p.setName（rs.getString（2））;
				p.setAge（rs.getInt（3））;
				p.setPhoto（rs.getString（4））;
				p.setAddress（rs.getString（5））;
				p.setInfo（rs.getString（6））;
				list.add（p）;
			}
			pageBean.setList（list）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	public?static?void?main（String[]?args）?{
		PersonBiz?personBiz?=?new?PersonBiz（）;
		PageBean?pageBean?=?new?PageBean（）;
		pageBean.setCurrent（2）;
		personBiz.listPage（pageBean）;
		Iterator?it?=?pageBean.getList（）.iterator（）;
		while?（it.hasNext（））?{
			Person?person?=?（Person）?it.next（）;
			System.out.println（person.getName（））;
		}
	}
}

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

?????文件????????410??2009-07-24?08:31??PageDemo\.classpath

?????文件????????297??2009-07-24?08:09??PageDemo\.mymetadata

?????文件???????1226??2009-07-24?08:59??PageDemo\.project

?????文件??????11201??2007-12-09?03:11??PageDemo\image\caocao.jpg

?????文件??????18084??2007-12-09?03:18??PageDemo\image\daqiao.jpg

?????文件??????31035??2007-12-09?03:15??PageDemo\image\diaochan.jpg

?????文件???????9477??2007-12-09?03:21??PageDemo\image\dongzhuo.jpg

?????文件???????7614??2007-12-09?03:23??PageDemo\image\fazheng.jpg

?????文件??????10637??2007-12-09?03:22??PageDemo\image\ganning.jpg

?????文件??????10752??2007-12-09?03:11??PageDemo\image\guanyu.jpg

?????文件???????9182??2007-12-09?03:11??PageDemo\image\guojia.jpg

?????文件??????24503??2007-12-09?03:17??PageDemo\image\huanggai.jpg

?????文件??????19997??2007-12-09?03:15??PageDemo\image\huangzhong.jpg

?????文件??????10820??2007-12-09?03:11??PageDemo\image\jiangwei.jpg

?????文件??????10101??2007-12-09?03:17??PageDemo\image\jiaxu.jpg

?????文件???????8884??2007-12-09?03:25??PageDemo\image\kongrong.jpg

?????文件???????9261??2007-12-09?03:11??PageDemo\image\liubei.jpg

?????文件??????10889??2007-12-09?03:15??PageDemo\image\luxun.jpg

?????文件??????27166??2007-12-09?03:11??PageDemo\image\lvbu.jpg

?????文件??????13390??2007-12-09?03:11??PageDemo\image\machao.jpg

?????文件??????10465??2007-12-09?03:23??PageDemo\image\pangde.jpg

?????文件??????15155??2007-12-09?03:18??PageDemo\image\simayi.jpg

?????文件???????9243??2007-12-09?03:17??PageDemo\image\sunquan.jpg

?????文件??????17864??2007-12-12?09:31??PageDemo\image\taishici.jpg

?????文件???????1746??2007-12-10?05:32??PageDemo\image\TEST.HTM

????..A.SH.????144896??2008-05-24?15:55??PageDemo\image\Thumbs.db

?????文件??????26577??2007-12-09?03:16??PageDemo\image\weiyan.jpg

?????文件??????17648??2007-12-09?03:18??PageDemo\image\xiaoqiao.jpg

?????文件??????25025??2007-12-09?03:24??PageDemo\image\xuchu.jpg

?????文件???????8668??2007-12-09?03:24??PageDemo\image\xushu.jpg

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