package?cn.edu.luas.dao;

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

import?cn.edu.luas.db.DBHelper;
import?cn.edu.luas.model.Article;
import?cn.edu.luas.model.User;

public?class?ArticleDAO?{
	//?創建一個數據庫執行的對象
		DBHelper?db?=?new?DBHelper（）;

		//?增加一個article
		public?void?addArticle（Article?article）?throws?SQLException?{
			//?增加一個article的數據庫sql語句
			String?sql?=?“insert?into?article（authoridtitlecontent）?values（?“?+?article.getAuthorid（）
					+?“?“?+?“?‘“?+?article.gettitle（）?+?“‘??‘“?+?article.getContent（）?+?“‘?）“;
			System.out.println（sql）;
			//?執行sql語句
			int?rows?=?db.executeSql（sql）;
			System.out.println（rows?+?“行記錄被插入數據庫中。。。“）;
		}
		
		//?刪除一個article
		public?void?delArticle（int?id）?throws?SQLException?{
			//?刪除一個Article的sql
			String?sql?=?“delete?from?article?where?id?=?“?+?id;
			//?執行sql
			int?rows?=?db.executeSql（sql）;
			System.out.println（rows?+?“行記錄被刪除...“）;
		}
		
		//?修改一個Article信息
		public?void?updateArticle（Article?article）?throws?SQLException?{
			//?修改一個user的sql語句
			String?sql?=?“update?article?set?title?=?‘“+article.gettitle（）+“‘?content?=?‘“+article.getContent（）+“‘?publishtime?=?‘“+article.getPublishTime（）+“‘?where?id?=?“?+?article.getId（）;
			//?執行修改user的sql語句
			int?rows?=?db.executeSql（sql）;
			System.out.println（rows?+?“行記錄被修改...“）;
		}
		
		//?修改一個Article信息
		public?void?clicksAdd（Article?article）?throws?SQLException?{
			//?修改一個user的sql語句
			String?sql?=?“update?article?set?clicks?=clicks+1??where?id?=?“?+?article.getId（）;
			System.out.println（sql）;
			//?執行修改user的sql語句
			int?rows?=?db.executeSql（sql）;
			System.out.println（rows?+?“行記錄被修改...“）;
		}
		
		//?查詢全部用戶信息
		public?ArrayList
?findAll（）?throws?SQLException?{
			//?聲明保存用戶的列表集合
			ArrayList
?articleList=?new?ArrayList
（）;
			//?查詢全部用戶的sql語句
			String?sql?=?“select?*?from?article“;
			//?執行查詢語句
			ResultSet?rs?=?db.executeQuery（sql）;
			//?遍歷查詢結果，并把查詢結果放到保存用戶的集合中
			while（rs.next（））?{
				Article?article?=?new?Article（）;
				article.setId（rs.getInt（“id“））;
				article.setAuthorid（rs.getInt（“authorid“））;
				article.settitle（rs.getString（“title“））;
				article.setContent（rs.getString（“content“））;
				article.setPublishTime（rs.getTimestamp（“publishTime“））;
				article.setClicks（rs.getInt（“clicks“））;
				article.setCommentCount（rs.getInt（“commentCount“））;
				//?把用戶添加到集合中
				articleList.add（article）;
			}
			
			//?返回查詢到的集合數據
			return?articleList;
		}
		
		//?查詢全部用戶信息
		public?ArrayList
?findArticleByAuthorId（int?authorid）?throws?SQLException?{
			//?聲明保存用戶的列表集合
			ArrayList
?articleList=?new?ArrayList
（）;
			//?查詢全部用戶的sql語句
			String?sql?=?“select?*?from?article?where?authorid=“+authorid;
			//?執行查詢語句
			ResultSet?rs?=?db.executeQuery（sql）;
			//?遍歷查詢結果，并把查詢結果放到保存用戶的集合中
			while（rs.next（））?{
				Article?article?=?new?Article（）;
				article.setId（rs.getInt（“id“））;
				a

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

?????文件???????1210??2014-01-03?15:12??myblog\.classpath

?????文件????????918??2013-12-29?17:17??myblog\.myeclipse\profiler\Test.xml

?????文件???????1405??2013-12-29?17:09??myblog\.project

?????文件????????522??2013-12-26?10:28??myblog\.settings\.jsdtscope

?????文件????????364??2013-12-26?10:28??myblog\.settings\org.eclipse.jdt.core.prefs

?????文件????????479??2013-12-26?10:28??myblog\.settings\org.eclipse.wst.common.component

?????文件????????414??2013-12-26?10:28??myblog\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-12-26?10:28??myblog\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-12-26?10:28??myblog\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4317??2014-01-02?18:19??myblog\blog.sql

?????文件???????4558??2014-01-02?17:28??myblog\src\cn\edu\luas\dao\ArticleDAO.java

?????文件???????1687??2014-01-02?17:24??myblog\src\cn\edu\luas\dao\CommentDAO.java

?????文件???????4410??2014-01-03?15:22??myblog\src\cn\edu\luas\dao\UserDAO.java

?????文件????????999??2013-12-28?15:17??myblog\src\cn\edu\luas\db\ConnectionManager.java

?????文件????????888??2013-12-28?10:56??myblog\src\cn\edu\luas\db\DBHelper.java

?????文件???????1157??2014-01-02?09:50??myblog\src\cn\edu\luas\model\Article.java

?????文件????????332??2013-12-31?16:51??myblog\src\cn\edu\luas\model\Comment.java

?????文件???????1454??2014-01-02?17:49??myblog\src\cn\edu\luas\model\User.java

?????文件????????805??2013-12-25?18:04??myblog\src\cn\edu\luas\test\Test.java

?????文件????????347??2014-01-02?17:59??myblog\src\cn\edu\luas\util\RenameFile.java

?????文件????????976??2014-01-02?10:20??myblog\WebRoot\acceptArticle.jsp

?????文件???????8705??2014-01-03?15:47??myblog\WebRoot\addArticle.jsp

?????文件???????7395??2014-01-02?10:22??myblog\WebRoot\articledetail1.jsp

?????文件??????12440??2014-01-02?17:30??myblog\WebRoot\articleinfo.jsp

?????文件???????7350??2013-12-31?17:09??myblog\WebRoot\articlelist.jsp

?????文件???????8844??2014-01-02?17:14??myblog\WebRoot\articlemanagerlist.jsp

?????文件???????9391??2013-12-30?16:19??myblog\WebRoot\changepwd.jsp

?????文件???????3002??2013-12-30?11:51??myblog\WebRoot\ckeditor\adapters\jquery.js

?????文件???????2769??2013-12-30?11:51??myblog\WebRoot\ckeditor\build-config.js

?????文件??????44082??2013-12-30?11:51??myblog\WebRoot\ckeditor\CHANGES.md

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