package?com.blog.dao;

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

import?com.blog.dto.Article;
import?com.blog.tools.*;
//table??article
public?class?ArticleDao?{
	?DBcon?????dba?=?new?DBcon（）;
	?DataDAO???dao?=?new?DataDAO（）;
	?String????sql?=?““;	?
	?//?isNull
	?public?boolean?isNull（）{		?
		????sql?=?“select?*?from??article?“;
			return??dao.isExist（sql）;
		?}
	?//?add?
	?public?int?add（Article?article）{		?
		?String??title?=?““;
		?String??content?=?““;
		?String??pubtime?=?““;
		?int?????blogid?=?0;
		?int?????sortid?=?0;
		?
		?//轉換成???str?-->?‘str‘?格式
		?title?=?dao.changSqlStr（article.gettitle（））;
		?content?=?dao.changSqlStr（article.gettitle（））;
		?pubtime?=?dao.changSqlStr（article.getPubtime（））;
		?blogid?=?article.getBlogid（）;	
		?sortid?=?article.getSortid（）;
		?sql?=?“insert?into??article?（titlecontentpubtimeblogidsortid）?values?（“+title+““+content+““+pubtime+““+blogid+““+sortid+“）“;
		?return??dao.executeUpdate（sql）;
	?}	?
	?//?update?
	?public?int?update（Article?article）{		?
		?String??title?=?““;
		?String??content?=?““;
		?String??pubtime?=?““;
		?int?????sortid?=?0;
		?int?????id?=?0;
		?
		?//轉換成???str?-->?‘str‘?格式
		?title?=?dao.changSqlStr（article.gettitle（））;
		?content?=?dao.changSqlStr（article.getContent（））;
		?pubtime?=?dao.changSqlStr（article.getPubtime（））;
		?id?=?article.getId（）;	
		?sortid?=?article.getSortid（）;
		?sql?=?“update?article?set?title=“+title+“content=“+content
		?????+“pubtime=“+pubtime+“sortid=“+sortid+“??where?id?=“+id;
		?return??dao.executeUpdate（sql）;
	?}		
	//?delete?
	?public?int?delete（int?id）{		?
		?sql?=?“delete?from?article???where?id?=“+id;
		?return??dao.executeUpdate（sql）;
	?}
	?//?List??
	?public?List?getList（）{		?
		List?list?=?new?ArrayList（）;
		Connection?conn?=?null;
		Statement??stmt?=?null;
		ResultSet?rs?=?null;
		sql?=?“select?a.ida.titlea.contenta.pubtimea.blogida.sortids.name?from??article?asort?s?where?a.sortid?=?s.id“;		
		try?{
			conn?=?dba.getConnection（）;
			stmt?=?conn.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
			while（rs.next（））{
				Article?article?=?new?Article（）;
				article.setId（rs.getInt（1））;
				article.settitle（rs.getString（2））;
				article.setContent（rs.getString（3））;
				article.setPubtime（rs.getString（4））;
				article.setBlogid（rs.getInt（5））;
				article.setSortid（rs.getInt（6））;
				article.setSort（rs.getString（7））;
			
				list.add（article）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	????return??list;
	?}
	?
	?//?article??
	?public?Article??getArticle（String??id）{
		Article?article?=?new?Article（）;
		Connection?conn?=?null;
		Statement??stmt?=?null;
		ResultSet?rs?=?null;
		sql?=?“select?a.ida.titlea.contenta.pubtimea.blogida.sortids.name?from??article?asor

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

?????文件?????331264??2011-03-09?20:52??blog系統\jsp作業.doc

?????文件???????8728??2011-01-11?15:26??blog系統\數據庫\blogver1\article.frm

?????文件???????8774??2011-01-11?14:44??blog系統\數據庫\blogver1\blog.frm

?????文件?????????65??2011-01-11?14:59??blog系統\數據庫\blogver1\db.opt

?????文件???????8726??2011-01-11?15:43??blog系統\數據庫\blogver1\feedback.frm

?????文件???????8648??2011-01-11?14:44??blog系統\數據庫\blogver1\links.frm

?????文件???????8620??2011-01-11?15:26??blog系統\數據庫\blogver1\sort.frm

?????文件???????5338??2011-01-12?14:38??blog系統\數據庫\blogver1.sql

?????文件????????869??2011-01-10?13:59??blog系統\源代碼\blog\.classpath

?????文件????????291??2011-01-11?14:12??blog系統\源代碼\blog\.mymetadata

?????文件???????1475??2011-01-10?12:51??blog系統\源代碼\blog\.project

?????文件????????354??2011-01-10?13:06??blog系統\源代碼\blog\.tomcatplugin

?????文件???????7810??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dao\ArticleDao.java

?????文件???????4676??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dao\FeedbackDao.java

?????文件???????4333??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dao\linkDao.java

?????文件???????3315??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dao\SortDao.java

?????文件???????6605??2011-01-13?11:06??blog系統\源代碼\blog\src\com\blog\dao\UserDao.java

?????文件???????1458??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dto\Article.java

?????文件???????1948??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dto\Feedback.java

?????文件???????1285??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dto\link.java

?????文件???????1182??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dto\Sort.java

?????文件???????1750??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\dto\User.java

?????文件???????3534??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\servlet\ArticleServlet.java

?????文件???????3168??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\servlet\FeedbackServlet.java

?????文件???????2893??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\servlet\linkServlet.java

?????文件???????2951??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\servlet\SortServlet.java

?????文件???????2868??2011-01-12?11:02??blog系統\源代碼\blog\src\com\blog\servlet\UserServlet.java

?????文件???????2993??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\tools\DataDAO.java

?????文件????????147??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\tools\db.properties

?????文件???????1962??2009-09-10?08:53??blog系統\源代碼\blog\src\com\blog\tools\DBcon.java

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