package?dao;

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

import?entity.Blog;
import?entity.Rep;
import?util.DBHelper;

public?class?BlogDAO?{
	private?DBHelper?connDB?=?new?DBHelper（）;
	private?Connection?conn?=?null;
	private?PreparedStatement?ps?=?null;
	private?ResultSet?rs?=?null;
	public?void?addBlog（String?username?String?blogint?id）?throws?Exception?{
		String?sql=“insert?into?t_blog（usernamecontenttimeuserId）“
				+“?values（????）“;

		conn?=?connDB.getConnection（）;
		PreparedStatement?ptmt=conn.prepareStatement（sql）;
		ptmt.setString（1?username）;
		ptmt.setString（2?blog）;
		ptmt.setTimestamp（3?new?Timestamp（System.currentTimeMillis（）））;?
		ptmt.setInt（4?id）;
		ptmt.execute（）;
		
		
	}
	public?int?findAllCount（）?throws?Exception?{
		
		
		String?sql=“select?*?from?t_blog“;
		Connection?conn=DBHelper.getConnection（）;
		Statement?stmt=conn.createStatement（）;
		
		ResultSet?rs=stmt.executeQuery（sql）;
		int?count=0;
		while（rs.next（））
		{
			count++;
		}
		return?count;
		
	}
	public?List?getListOfBlog（int?begin?int?pageSize）?throws?Exception?{
		List?list=new?ArrayList（）;
		Blog?blog=null;
		String?sql=“select?*?from?t_blog?order?by?time?DESC?limit?????“;
		Connection?conn=DBHelper.getConnection（）;
	
		PreparedStatement?ptmt=conn.prepareStatement（sql）;
		
		ptmt.setInt（1?begin）;
		ptmt.setInt（2?pageSize）;
		
		ResultSet?rs=ptmt.executeQuery（）;
		
		while（rs.next（））
		{
			blog=new?Blog（）;
			blog.setId（rs.getInt（“id“））;
			blog.setUsername（rs.getString（“username“））;
			blog.setContent（rs.getString（“content“））;
			blog.setUserId（rs.getInt（“userId“））;
			list.add（blog）;
		}
		
		return?list;
	}
	public?void?deleteBlog（int?id）?throws?Exception?{
		String?sql=“delete?from?t_blog?where??id?=?“;

		conn?=?connDB.getConnection（）;
		PreparedStatement?ptmt=conn.prepareStatement（sql）;
		ptmt.setInt（1?id）;
		ptmt.execute（）;
		
		
	}
	public?void?addRep（int?blogId?int?userId?String?contentString?userName）?throws?Exception?{
		String?sql=“insert?into?t_rep（blogIduserIdcontentuserName）“
				+“?values（????）“;

		conn?=?connDB.getConnection（）;
		PreparedStatement?ptmt=conn.prepareStatement（sql）;
		ptmt.setInt（1?blogId）;
		ptmt.setInt（2?userId）;
		ptmt.setString（3content）;
		ptmt.setString（4userName）;
		
		ptmt.execute（）;
		
	}
	public?List?getRep（int?blogId）?throws?Exception?{
		List?list=new?ArrayList（）;
		
		String?sql=“select?*?from?t_rep?where?blogId=??“;
		Connection?conn=DBHelper.getConnection（）;
	
		PreparedStatement?ptmt=conn.prepareStatement（sql）;
		
		ptmt.setInt（1?blogId）;
		ResultSet?rs=ptmt.executeQuery（）;
		
		while（rs.next（））
		{
			Rep?rep=new?Rep（）;
			rep.setId（rs

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-13?18:45??blogProject\
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\
?????文件????????1673??2018-05-12?08:37??blogProject\blog\.classpath
?????文件????????1329??2018-05-12?08:41??blogProject\blog\.project
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\.settings\
?????文件?????????522??2018-05-12?08:37??blogProject\blog\.settings\.jsdtscope
?????文件?????????364??2018-05-12?08:37??blogProject\blog\.settings\org.eclipse.jdt.core.prefs
?????文件?????????471??2018-05-12?08:40??blogProject\blog\.settings\org.eclipse.wst.common.component
?????文件?????????750??2018-05-12?08:37??blogProject\blog\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????509??2018-05-12?08:37??blogProject\blog\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-05-12?08:37??blogProject\blog\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-05-12?08:37??blogProject\blog\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\meta-INF\
?????文件??????????39??2018-05-12?08:37??blogProject\blog\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\classes\dao\
?????文件????????4244??2018-05-12?16:38??blogProject\blog\WebRoot\WEB-INF\classes\dao\BlogDAO.class
?????文件????????4086??2018-05-12?15:41??blogProject\blog\WebRoot\WEB-INF\classes\dao\UserDAO.class
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\classes\entity\
?????文件????????1275??2018-05-12?15:01??blogProject\blog\WebRoot\WEB-INF\classes\entity\Blog.class
?????文件????????1731??2018-05-12?13:22??blogProject\blog\WebRoot\WEB-INF\classes\entity\PageBean.class
?????文件????????1481??2018-05-12?16:31??blogProject\blog\WebRoot\WEB-INF\classes\entity\Rep.class
?????文件????????1069??2018-05-12?09:21??blogProject\blog\WebRoot\WEB-INF\classes\entity\User.class
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\classes\service\
?????文件????????2566??2018-05-12?16:32??blogProject\blog\WebRoot\WEB-INF\classes\service\BlogService.class
?????文件????????2144??2018-05-12?15:40??blogProject\blog\WebRoot\WEB-INF\classes\service\UserService.class
?????目錄???????????0??2018-05-13?18:45??blogProject\blog\WebRoot\WEB-INF\classes\servlet\
?????文件????????2426??2018-05-12?15:17??blogProject\blog\WebRoot\WEB-INF\classes\servlet\AddFriendServlet.class
?????文件????????2174??2018-05-12?15:59??blogProject\blog\WebRoot\WEB-INF\classes\servlet\DeleteBlogServlet.class
............此處省略50個文件信息