package?com.bbs.common;

import?com.bbs.DAO.*;
import?com.bbs.entitiy.*;
import?java.util.*;

public?class?TopicPageMaker?{
	//第一頁頁碼
	private?int?firstPage?=?1;
	//最后一頁頁碼
	private?int?lastPage;
	//上一頁
	private?int?prePage;
	//下一頁
	private?int?nextPage;
	//當前頁
	private?int?currentPage;
	//每頁顯示數量
	private?int?sizeOfPage?=?10;
	//板塊ID
	private?int?boardID?;
	
	private?TopicInfoDAO?topicDao?=?new?TopicInfoDAO（）;
	private?ReplyInfoDAO?replyDao?=?new?ReplyInfoDAO（）;
	
	public?TopicPageMaker（int?currentPageint?boardID）{
		this.currentPage?=?currentPage;
		
		this.firstPage?=?1;
		//如果是剛好可以除盡的數量?，則商就是頁數；否則商+1為頁數
		this.lastPage?=?topicDao.GetAllTopicCount（boardID）?%?sizeOfPage?==?0???topicDao.GetAllTopicCount（boardID）?/?sizeOfPage:topicDao.GetAllTopicCount（boardID）?/?sizeOfPage+1;	
	}
	
	public?TopicPageMaker（int?currentPageint?boardIDint?topicID）{
		this.currentPage?=?currentPage;
		
		this.firstPage?=?1;
		//如果是剛好可以除盡的數量?，則商就是頁數；否則商+1為頁數
		this.lastPage?=?replyDao.GetAllReplyCount（topicID）?%?sizeOfPage?==?0???replyDao.GetAllReplyCount（topicID）?/?sizeOfPage:replyDao.GetAllReplyCount（topicID）?/?sizeOfPage+1;	
	}
	
	
	public?int?getPrePage（）{
		if（this.currentPage?==?1）{
			this.prePage?=?1;
		}else{
			this.prePage?=?this.currentPage?-1;
		}
		return?this.prePage;
	}
	
	public?int?getNextPage（）{
		if（this.currentPage?==?this.lastPage）{
			this.nextPage?=?this.lastPage;
		}else{
			this.nextPage?=?this.currentPage?+?1;
		}
		return?this.nextPage;
	}
	
	public?List?getTopicByPage（int?boardID）{
		List?list?=?new?ArrayList（）;
		int?count?=?（this.currentPage-1）*sizeOfPage;
		//根據頁碼查詢帖子
		String?sql?=?“select?top?“+sizeOfPage+“?*?from?TopicInfo?where?boardID?=?“+boardID+“?and?TopicID?not?in?（select?top?“+count+“?topicID?from?TopicInfo?where?boardID=“+boardID+“）“;
		list?=?topicDao.GetTopicInfoBySql（sql）;
		return?list;
	}

	public?List?GetReplyByPage（int?topicID）{
		List?list?=?new?ArrayList（）;
		
		int?count?=?（this.currentPage-1）*（sizeOfPage-1）;
		String?sql?=“select?top?“+（sizeOfPage-1）+“?*?from?ReplyInfo?where?topicID?=?“+topicID+“?and?replyID?not?in?（select?top?“+count+“?replyID?from?replyInfo?where?topicID=“+topicID+“）“;
		list?=?replyDao.GetReplyInfoBySql（sql）;
		return?list;
	}
	
	public?void?setBoardID（int?boardID）?{
		this.boardID?=?boardID;
	}

	public?int?getBoardID（）?{
		return?boardID;
	}
	public??int?getFirstPage（）{
		return?this.firstPage;
	}
	
	public?int?getLastPage（）{
		return?this.lastPage;
	}
	
}

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

?????文件???????3181??2007-09-30?09:51??bbs\bbs靜態頁面\detail.html

?????文件????????712??2007-07-03?08:15??bbs\bbs靜態頁面\image\board.gif

?????文件???????3728??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\1.gif

?????文件???????3491??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\10.gif

?????文件???????3574??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\11.gif

?????文件???????3624??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\12.gif

?????文件???????3362??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\13.gif

?????文件???????3472??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\14.gif

?????文件???????3343??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\15.gif

?????文件???????3945??2007-07-26?22:48??bbs\bbs靜態頁面\image\head\2.gif

?????文件???????3762??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\3.gif

?????文件???????3560??2007-07-26?22:48??bbs\bbs靜態頁面\image\head\4.gif

?????文件???????3819??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\5.gif

?????文件???????3427??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\6.gif

?????文件???????3256??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\7.gif

?????文件???????3520??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\8.gif

?????文件???????3660??2007-07-26?22:47??bbs\bbs靜態頁面\image\head\9.gif

????..A.SH.??????8704??2007-08-06?11:50??bbs\bbs靜態頁面\image\head\Thumbs.db

?????文件???????3825??2007-07-18?14:25??bbs\bbs靜態頁面\image\logo.gif

?????文件???????1907??2007-07-27?19:18??bbs\bbs靜態頁面\image\post.gif

?????文件???????1958??2007-07-27?19:19??bbs\bbs靜態頁面\image\reply.gif

????..A.SH.?????12288??2007-08-06?11:50??bbs\bbs靜態頁面\image\Thumbs.db

?????文件????????311??2007-07-26?22:32??bbs\bbs靜態頁面\image\topic.gif

?????文件???????5441??2007-09-30?09:50??bbs\bbs靜態頁面\index.html

?????文件???????3622??2007-09-30?09:49??bbs\bbs靜態頁面\list.html

?????文件???????1544??2007-09-30?09:46??bbs\bbs靜態頁面\login.html

?????文件???????2445??2007-09-30?09:48??bbs\bbs靜態頁面\post.html

?????文件???????3212??2007-09-30?09:47??bbs\bbs靜態頁面\reg.html

?????文件???????2728??2007-07-30?09:38??bbs\bbs靜態頁面\style\style.css

?????文件???????2464??2007-09-30?09:48??bbs\bbs靜態頁面\update.html

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