package?com.blog.dao;

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

import?com.blog.entity.Article;
import?com.blog.util.DBHelp;

public?class?ArticleDao?{
	Connection?conn;
	PreparedStatement?ps;
	ResultSet?rs;
	DBHelp?dbhelp=null;
	public?ArticleDao（）{
		dbhelp=new?DBHelp（）;
		conn=dbhelp.getConnection（）;
	}
	//發表文章
	public?boolean?addArticle（Article?article）{
		String?sql=“insert?into?tb_article（article_typeID?article_titlearticle_contentarticle_sdTimearticle_createarticle_info）?values（??????）“;
		try?{
			ps=conn.prepareStatement（sql）;
			ps.setInt（1?article.getArticle_typeID（））;
			ps.setString（2?article.getArticle_title（））;
			ps.setString（3?article.getArticle_content（））;
			ps.setString（4?article.getArticle_sdTime（））;
			ps.setString（5?article.getArticle_create（））;
			ps.setString（6?article.getArticle_info（））;
			ps.executeUpdate（）;
			return?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}
	}
	//查詢所有文章
	public?List?selectArticle（）{
		List?articlelist=new?ArrayList（）;
		String?sql=“select?*?from?tb_article“;
		try?{
			ps=conn.prepareStatement（sql）;
			rs=ps.executeQuery（）;
			while（rs.next（））{
				Article?article=new?Article（）;
				article.setId（rs.getInt（1））;
				article.setArticle_typeID（rs.getInt（2））;
				article.setArticle_title（rs.getString（3））;
				article.setArticle_content（rs.getString（4）.substring（0?5））;
				article.setArticle_sdTime（rs.getString（5））;
				article.setArticle_create（rs.getString（6））;
				article.setArticle_info（rs.getString（7））;
				article.setArticle_count（rs.getInt（8））;
				articlelist.add（article）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?articlelist;
	}
	
	//根據id查詢文章
	public?Article?selectByid（int?id）{
		Article?article=null;
		String??sql=“select?*?from?tb_article?where?id=?“;
		try?{
			ps=conn.prepareStatement（sql）;
			ps.setInt（1?id）;
			rs=ps.executeQuery（）;
			while（rs.next（））{
				article=new?Article（）;
				article.setId（rs.getInt（1））;
				article.setArticle_typeID（rs.getInt（2））;
				article.setArticle_title（rs.getString（3））;
				article.setArticle_content（rs.getString（4））;
				article.setArticle_sdTime（rs.getString（5））;
				article.setArticle_create（rs.getString（6））;
				article.setArticle_info（rs.getString（7））;
				article.setArticle_count（rs.getInt（8））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?article;
	}
	//根據類別ID查詢
	public?List?selectByTypeid（int?typeid）{
		List?articlelist=new?ArrayList（）;
		String??sql=“select?*?from?tb_article?where?article_typeID=?“;
		try?{
			ps=conn.prepareStatement（sql）;
			ps.setInt（1?typeid）;
			rs=ps.executeQuery（）;
			while（rs.ne

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

?????文件????????698??2011-05-10?18:57??BlogTest\.classpath

?????文件????????297??2011-05-10?18:57??BlogTest\.mymetadata

?????文件???????1414??2011-05-10?18:57??BlogTest\.project

?????文件????????500??2011-05-10?18:57??BlogTest\.settings\.jsdtscope

?????文件????????330??2011-05-10?18:57??BlogTest\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-05-10?18:57??BlogTest\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-05-10?18:57??BlogTest\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????12011??2011-05-10?18:57??BlogTest\Database\blog.sql

????..A.SH.?????46080??2011-05-10?20:49??BlogTest\photo\Thumbs.db

?????文件?????104805??2011-05-10?18:57??BlogTest\photo\孫燕姿.jpg

?????文件???????4201??2011-05-10?18:57??BlogTest\photo\孫燕姿__1.jpg

?????文件???????4658??2011-05-10?18:57??BlogTest\photo\孫燕姿_我要的幸福_1.jpg

?????文件??????88147??2011-05-10?18:57??BlogTest\photo\山雞.jpg

?????文件???????4264??2011-05-10?18:57??BlogTest\photo\張韶涵__1.jpg

?????文件???????9671??2011-05-10?18:57??BlogTest\photo\弦子__0.jpg

?????文件??????46009??2011-05-10?18:57??BlogTest\photo\林志玲.jpg

?????文件??????57167??2011-05-10?18:57??BlogTest\photo\百事啫喱水.jpg

?????文件??????91599??2011-05-10?18:57??BlogTest\photo\秦風.jpg

?????文件???????5078??2011-05-10?20:33??BlogTest\src\com\blog\dao\ArticleDao.java

?????文件???????4130??2011-05-10?18:57??BlogTest\src\com\blog\dao\ArticletypeDao.java

?????文件???????3074??2011-05-10?18:57??BlogTest\src\com\blog\dao\FriendDao.java

?????文件???????1382??2011-05-10?18:57??BlogTest\src\com\blog\dao\MasterDao.java

?????文件???????2316??2011-05-10?18:57??BlogTest\src\com\blog\dao\PhotoDao.java

?????文件???????2345??2011-05-10?18:57??BlogTest\src\com\blog\dao\ReviewDao.java

?????文件???????1866??2011-05-10?18:57??BlogTest\src\com\blog\dao\WordDao.java

?????文件???????1556??2011-05-10?18:57??BlogTest\src\com\blog\entity\Article.java

?????文件????????692??2011-05-10?18:57??BlogTest\src\com\blog\entity\Articletype.java

?????文件????????890??2011-05-10?18:57??BlogTest\src\com\blog\entity\Friend.java

?????文件????????806??2011-05-10?18:57??BlogTest\src\com\blog\entity\Master.java

?????文件????????707??2011-05-10?18:57??BlogTest\src\com\blog\entity\Photo.java

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