package?com.dao;

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

import?com.toolsBean.Change;
import?com.toolsBean.DB;
import?com.valueBean.ArticleSingle;

public?class?ArticleDao?extends?SuperDao{
	/**
	?*?@功能：獲取在個人主頁中顯示的文章
	?*/
	public?List?getDefaultArticle（int?id）?throws?SQLException{
		String?sql=“select?top?4?*?from?tb_article?where?art_whoId=??order?by?art_pubTime?desc“;
		object[]?params={id};		
		List?articlelist=getList（sqlparams）;		
		return?articlelist;
	}
	/**
	?*?@功能：獲取當前頁顯示的所有文章
	?*/
	public?List?getListArticle（int?idString?showPageString?goWhich）?throws?SQLException{
		String?sqlall=“select?*?from?tb_article?where?art_whoId=?“;
		object[]?params={id};
		
		setPerR（5）;
		createPage（

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

?????文件????????741??2008-05-06?13:42??mediaBlog\css\style.css

?????文件????1310720??2008-05-23?10:45??mediaBlog\database\db_mediaBlog_Data.MDF

?????文件????1048576??2008-05-23?10:45??mediaBlog\database\db_mediaBlog_Log.LDF

?????文件???????1701??2008-05-02?10:42??mediaBlog\images\adminB.jpg

?????文件????????520??2008-05-03?20:47??mediaBlog\images\adminIco.jpg

?????文件???????1703??2008-05-03?20:14??mediaBlog\images\adminIndexB.jpg

?????文件???????2065??2008-05-03?20:47??mediaBlog\images\adminT.jpg

?????文件??????35182??2008-05-03?21:09??mediaBlog\images\admin_main.jpg

?????文件?????173730??2008-05-03?20:05??mediaBlog\images\admin_top.jpg

?????文件??????13410??2008-05-03?17:28??mediaBlog\images\allBack.jpg

?????文件???????1785??2008-05-02?10:42??mediaBlog\images\articleB.jpg

?????文件???????3136??2008-05-02?11:52??mediaBlog\images\articleT.jpg

?????文件???????3015??2008-05-02?10:13??mediaBlog\images\back.jpg

?????文件???????1599??2008-05-02?10:42??mediaBlog\images\defaultB.jpg

?????文件??????39249??2008-05-04?15:08??mediaBlog\images\end.jpg

?????文件???????1772??2008-05-03?20:14??mediaBlog\images\exitB.jpg

?????文件???????2310??2008-05-02?11:09??mediaBlog\images\friendT.jpg

?????文件??????29989??2008-05-02?11:21??mediaBlog\images\ico\myNull.jpg

?????文件???????1563??2008-05-02?10:42??mediaBlog\images\indexB.jpg

?????文件????????353??2008-05-02?12:58??mediaBlog\images\line.jpg

?????文件???????2204??2008-05-02?11:09??mediaBlog\images\linkT.jpg

?????文件???????1044??2008-05-03?22:25??mediaBlog\images\logonB.jpg

?????文件??????96951??2008-05-04?17:01??mediaBlog\images\logonBack.jpg

?????文件??????15797??2008-05-03?17:50??mediaBlog\images\mainT.jpg

?????文件????????722??2008-05-02?12:19??mediaBlog\images\mainT1.jpg

?????文件??????31735??2008-05-04?09:51??mediaBlog\images\media\null.jpg

?????文件???????1600??2008-05-02?10:42??mediaBlog\images\mediaB.jpg

?????文件???????2117??2008-05-02?11:09??mediaBlog\images\menuT.jpg

?????文件???????1251??2008-05-02?11:36??mediaBlog\images\menuTB.jpg

?????文件????????628??2008-05-02?12:13??mediaBlog\images\moreB.jpg

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