package?com.java.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.java.model.Diary;
import?com.java.model.PageBean;
import?com.java.util.DateUtil;
import?com.java.util.StringUtil;

public?class?DiaryDao?{
	
	/**
	?*?查詢?nèi)沼浟斜硭袛?shù)據(jù)
	?*?@param?con
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?diaryList（Connection?conPageBean?pageBeanDiary?s_diary）?throws?Exception{
		List?diaryList=new?ArrayList（）;
		StringBuffer?sb=new?StringBuffer（“select?*?from?t_diary?t1t_diarytype?t2?where?t1.typeId=t2.diaryTypeId“）;
		//搜索日志DAO
		if（StringUtil.isNotEmpty（s_diary.gettitle（）））{
			sb.append（“?and?t1.title?like?‘%“+s_diary.gettitle（）+“%‘“）;
		}
		if（s_diary.getTypeId（）!=-1）{
			sb.append（“?and?t1.typeId=“+s_diary.getTypeId（））;
		}
		//按日期查詢DAO
		if（StringUtil.isNotEmpty（s_diary.getReleaseDateStr（）））{
			sb.append（“?and?date_format（t1.releaseDate‘%Y年%m月‘）=‘“+s_diary.getReleaseDateStr（）+“‘“）;
		}
		//查詢所有時(shí)降續(xù)查詢
		sb.append（“?order?by?t1.releaseDate?desc?“）;
		if（pageBean!=null）{
			sb.append（“?limit?“+pageBean.getStart（）+““+pageBean.getPageSize（））;
		}
		PreparedStatement?pstm?=?con.prepareStatement（sb.toString（））;
		ResultSet?rs=pstm.executeQuery（）;
		while（rs.next（））{
			Diary?diary=new?Diary（）;
			diary.setDiaryId（rs.getInt（“diaryId“））;
			diary.settitle（rs.getString（“title“））;
			diary.setContent（rs.getString（“content“））;
			diary.setReleaseDate（DateUtil.formatString（rs.getString（“releaseDate“）?“yyyy-MM-dd?HH:mm:ss“））;
			diaryList.add（diary）;
		}
		return?diaryList;
	}
	
	/**
	?*?總記錄
	?*?@throws?Exception?
	?*/
	public?int?diaryCount（Connection?conDiary?s_diary）?throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?count（*）?as?total?from?t_diary?t1t_diarytype?t2?where?t1.typeId=t2.diaryTypeId“）;
		if（StringUtil.isNotEmpty（s_diary.gettitle（）））{
			sb.append（“?and?t1.title?like?‘%“+s_diary.gettitle（）+“‘“）;
		}
		if（s_diary.getTypeId（）!=-1）{
			sb.append（“?and?t1.typeId=“+s_diary.getTypeId（））;
		}
		if（StringUtil.isNotEmpty（s_diary.getReleaseDateStr（）））{
			sb.append（“?and?date_format（releaseDate‘%Y年%m月‘）=‘“+s_diary.getReleaseDateStr（）+“‘“）;
		}
		PreparedStatement?pstm?=?con.prepareStatement（sb.toString（））;
		ResultSet?rs=pstm.executeQuery（）;
		if（rs.next（））{
			return?rs.getInt（“total“）;
		}else{
			return?0;
		}
	}
	/**
	?*?按日期查詢
	?*?@param?con
	?*?@return
	?*?@throws?SQLException
	?*/
	public?List?diaryCounList（Connection?con）?throws?SQLException{
		List?diaryCountList?=?new?ArrayList（）;
		String?sql=“select?date_format（releaseDate‘%Y年%m月‘）?as?releaseDateStr?count（*）?as?diaryCount?from?t_diary?group?by?date_format（releaseDate‘%Y年%m月‘）?order?by?date_format（releaseDate‘%Y年%m月‘）?desc;“;
		PreparedStatement?pstm?=?con.prepareStatement（sql）;
		ResultSet?rs=pstm.executeQuery（）;

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????715??2017-07-20?11:48??Diary\.classpath

?????文件???????1038??2017-07-20?11:37??Diary\.project

?????文件????????503??2017-06-27?17:24??Diary\.settings\.jsdtscope

?????文件????????364??2017-06-27?17:24??Diary\.settings\org.eclipse.jdt.core.prefs

?????文件????????467??2017-07-20?11:37??Diary\.settings\org.eclipse.wst.common.component

?????文件????????305??2017-06-27?17:24??Diary\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-06-27?17:24??Diary\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-06-27?17:24??Diary\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????5851??2017-09-04?14:17??Diary\build\classes\com\java\dao\DiaryDao.class

?????文件???????1878??2017-09-04?14:17??Diary\build\classes\com\java\dao\DiaryTypeDao.class

?????文件???????2183??2017-09-04?14:17??Diary\build\classes\com\java\dao\UserDao.class

?????文件???????2087??2017-09-04?14:17??Diary\build\classes\com\java\filter\LoginFsilter.class

?????文件???????2284??2017-09-04?14:17??Diary\build\classes\com\java\model\Diary.class

?????文件???????1116??2017-09-04?14:17??Diary\build\classes\com\java\model\DiaryType.class

?????文件????????817??2017-09-04?14:17??Diary\build\classes\com\java\model\PageBean.class

?????文件???????1929??2017-09-04?14:17??Diary\build\classes\com\java\model\User.class

?????文件???????1129??2017-09-04?14:17??Diary\build\classes\com\java\util\DateUtil.class

?????文件???????1586??2017-09-04?14:17??Diary\build\classes\com\java\util\DbUtil.class

?????文件???????1468??2017-09-04?14:17??Diary\build\classes\com\java\util\MD5Util.class

?????文件???????1067??2017-09-04?14:17??Diary\build\classes\com\java\util\PropertiesUtil.class

?????文件????????625??2017-09-04?14:17??Diary\build\classes\com\java\util\StringUtil.class

?????文件???????3735??2017-09-04?14:17??Diary\build\classes\com\java\web\DiaryServlet.class

?????文件???????3865??2017-09-04?14:17??Diary\build\classes\com\java\web\LoginServlet.class

?????文件???????6021??2017-09-04?14:17??Diary\build\classes\com\java\web\MainServlet.class

?????文件????????145??2017-07-20?11:37??Diary\build\classes\diary.properties

?????文件???????5025??2017-07-20?11:37??Diary\src\com\java\dao\DiaryDao.java

?????文件???????1115??2017-07-20?11:37??Diary\src\com\java\dao\DiaryTypeDao.java

?????文件???????1350??2017-07-20?11:37??Diary\src\com\java\dao\UserDao.java

?????文件???????1425??2017-07-20?11:37??Diary\src\com\java\filter\LoginFsilter.java

?????文件???????1761??2017-07-20?11:37??Diary\src\com\java\model\Diary.java

............此處省略77個(gè)文件信息