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.setAddress（rs.getString（3））;//?獲取并設置圖片地址
				Date?date;
				try?{
					date?=?DateFormat.getDateTimeInstance（）.parse（
							rs.getString（4））;
					diary.setWriteTime（date）;//?設置寫日記的時間
				}?catch?（ParseException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;//?輸出異常信息到控制臺
				}

				diary.setUserid（rs.getInt（5））;//?獲取并設置用戶ID
				diary.setUsername（rs.getString（6））;//?獲取并設置用戶名
				list.add（diary）;//?將日記信息保存到list集合中

			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;//?輸出異常信息
		}?finally?{
			conn.close（）;//?關閉數據庫連接
		}
		return?list;
	}

	/**
	?*?功能：保存九宮格日記到數據庫
	?*?
	?*?@param?diary
	?*?@return
	?*/
	public?int?saveDiary（Diary?diary）?{
		String?sql?=?“INSERT?INTO?tb_diary?（titleaddressuserid）?VALUES（‘“
				+?diary.gettitle（）?+?“‘‘“?+?diary.getAddress（）?+?“‘“
				+?diary.getUserid（）?+?“）“;		//保存數據的SQL語句
		int?ret?=?conn.executeUpdate（sql）;//?執行更新語句
		conn.close（）;//?關閉數據庫連接
		return?ret;
	}

	/**
	?*?刪除指定日記
	?*?
	?*?@param?id
	?*?@return
	?*/
	public?int?delDiary（int?id）?{
		String?sql?=?“DELETE?FROM?tb_diary?WHERE?id=“?+?id;
		int?ret?=?0;
		try?{
			ret?=?conn.executeUpdate（sql）;//?執行更新語句
		}?catch?（Exception?e）?{
			e.printStackTrace（）;//?輸出異常信息
		}?finally?{
			conn.close（）;//?關閉數據連接
		}
		return?ret;
	}
}

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

?????文件???????1053??2012-12-25?12:57??第14章\9GridDiary\.classpath

?????文件????????910??2012-12-25?12:57??第14章\9GridDiary\.project

?????文件????????503??2012-12-25?12:57??第14章\9GridDiary\.settings\.jsdtscope

?????文件????????364??2012-12-25?12:57??第14章\9GridDiary\.settings\org.eclipse.jdt.core.prefs

?????文件????????484??2012-12-25?12:57??第14章\9GridDiary\.settings\org.eclipse.wst.common.component

?????文件????????345??2012-12-25?12:57??第14章\9GridDiary\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-12-25?12:57??第14章\9GridDiary\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-12-25?12:57??第14章\9GridDiary\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3068??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\dao\DiaryDao.class

?????文件???????3482??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\dao\UserDao.class

?????文件???????1956??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\filter\CharacterEncodingFilter.class

?????文件???????7833??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\model\CityMap.class

?????文件???????1613??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\model\Diary.class

?????文件???????1727??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\model\User.class

?????文件???????5159??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\servlet\CreateImg.class

?????文件???????8421??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\servlet\DiaryServlet.class

?????文件???????7453??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\servlet\UserServlet.class

?????文件???????3320??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\tools\ConnDB.class

?????文件????????127??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\tools\connDB.properties

?????文件???????3318??2012-12-25?12:57??第14章\9GridDiary\build\classes\com\wgh\tools\MyPagination.class

?????文件???????2457??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\dao\DiaryDao.java

?????文件???????3665??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\dao\UserDao.java

?????文件???????1519??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\filter\CharacterEncodingFilter.java

?????文件???????4896??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\model\CityMap.java

?????文件???????1092??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\model\Diary.java

?????文件???????1199??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\model\User.java

?????文件???????5418??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\servlet\CreateImg.java

?????文件??????10747??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\servlet\DiaryServlet.java

?????文件??????10401??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\servlet\UserServlet.java

?????文件???????3718??2012-12-25?12:57??第14章\9GridDiary\src\com\wgh\tools\ConnDB.java

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