package?com.wgh.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.DateFormat;
import?java.text.ParseException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?com.wgh.model.Diary;
import?com.wgh.tools.ConnDB;

public?class?DiaryDao?{
	private?ConnDB?conn?=?null;//?創建數據庫連接對象

	public?DiaryDao（）?{
		conn?=?new?ConnDB（）;//?實例化數據庫連接對象
	}

	/**
	?*?查詢日記
	?*?
	?*?@param?sql
	?*?@return
	?*/
	public?List?queryDiary（String?sql）?{
		ResultSet?rs?=?conn.executeQuery（sql）;//?執行查詢語句
		List?list?=?new?ArrayList（）;
		try?{//?捕獲異常
			while?（rs.next（））?{
				Diary?diary?=?new?Diary（）;
				diary.setId（rs.getInt（1））;//?獲取并設置ID
				diary.settitle（rs.getString（2））;//?獲取并設置日記標題
				diary.setAd

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-04?15:29??21\
?????文件????????1012??2018-05-27?14:55??21\.classpath
?????文件????????1177??2018-05-27?06:40??21\.project
?????目錄???????????0??2018-05-28?13:13??21\.settings\
?????文件?????????454??2011-05-07?09:38??21\.settings\.jsdtscope
?????文件??????????80??2018-05-27?06:38??21\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????111??2018-05-27?11:10??21\.settings\org.eclipse.core.resources.prefs
?????文件?????????330??2011-05-07?09:38??21\.settings\org.eclipse.jdt.core.prefs
?????文件?????????410??2011-06-11?09:36??21\.settings\org.eclipse.wst.common.component
?????文件?????????320??2018-05-27?06:38??21\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2011-05-07?09:38??21\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-05-07?09:38??21\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-28?13:13??21\WebContent\
?????目錄???????????0??2018-05-28?13:13??21\WebContent\CSS\
?????文件?????????485??2011-06-08?13:01??21\WebContent\CSS\style.css
?????目錄???????????0??2018-05-28?13:13??21\WebContent\Database\
?????文件????????3447??2011-06-11?09:01??21\WebContent\Database\db_9griddiary.sql
?????目錄???????????0??2018-05-28?13:13??21\WebContent\JS\
?????文件????????1937??2011-06-08?14:21??21\WebContent\JS\AjaxRequest.js
?????文件???????37315??2011-05-28?15:26??21\WebContent\JS\excanvas-modified.js
?????文件???????57254??2011-05-30?08:35??21\WebContent\JS\jquery-1.3.2.min.js
?????文件????????4780??2011-05-30?08:35??21\WebContent\JS\jquery.pngFix.js
?????文件????????2495??2011-05-30?08:35??21\WebContent\JS\jquery.pngFix.pack.js
?????文件????????1333??2011-05-26?14:26??21\WebContent\JS\wghFunction.js
?????目錄???????????0??2018-05-28?13:13??21\WebContent\meta-INF\
?????文件??????????39??2011-05-07?09:38??21\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-05-28?13:13??21\WebContent\WEB-INF\
?????目錄???????????0??2018-05-28?13:13??21\WebContent\WEB-INF\lib\
?????文件???????30677??2018-05-27?06:58??21\WebContent\WEB-INF\lib\jstl-api-1.2.jar
?????文件??????392421??2018-05-27?06:58??21\WebContent\WEB-INF\lib\jstl-impl-1.2.jar
?????文件??????969020??2018-05-27?06:39??21\WebContent\WEB-INF\lib\mysql-connector-java-5.1.32-bin.jar
............此處省略72個文件信息