package?org.news.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?org.news.util.DatabaseUtil;

/**
?*?執行數據庫操作的工具類。
?*/
public?class?baseDao?{

????private?Connection?conn;
????
????public?baseDao（Connection?conn）?{
????????this.conn?=?conn;
????}
????
????/**
?????*?增、刪、改操作
?????*?
?????*?@param?sql
?????*????????????sql語句
?????*?@param?prams
?????*????????????參數數組
?????*?@return?執行結果
?????*?@throws?SQLException?
?????*/
????protected?int?executeUpdate（String?sql?object...?params）?throws?SQLException?{
????????int?result?=?0;
????????PreparedStatement?pstmt?=?null;
????????try?{
????????????pstmt?=?conn.prepareStatement（sql）;
????????????for?（int?i?=?0;?i?????????????????pstmt.setobject（i?+?1?params[i]）;
????????????}
????????????result?=?pstmt.executeUpdate（）;
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????????throw?e;
????????}?finally?{
????????????DatabaseUtil.closeAll（null?pstmt?null）;
????????}
????????return?result;
????}

????/**
?????*?查詢操作
?????*?
?????*?@param?sql
?????*????????????sql語句
?????*?@param?params
?????*????????????參數數組
?????*?@return?查詢結果集
?????*?@throws?SQLException?
?????*/
????protected?ResultSet?executeQuery（String?sql?object...?params）?throws?SQLException?{
????????PreparedStatement?pstmt?=?null;
????????ResultSet?rs?=?null;
????????try?{
????????????pstmt?=?conn.prepareStatement（sql）;
????????????for?（int?i?=?0;?i?????????????????pstmt.setobject（i?+?1?params[i]）;
????????????}
????????????rs?=?pstmt.executeQuery（）;
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????????throw?e;
????????}
????????return?rs;
????}
}

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

?????文件????????877??2016-08-01?16:44??案例：新聞發布系統\news_chapter13_full\.classpath

?????文件????????315??2017-11-22?10:01??案例：新聞發布系統\news_chapter13_full\.mymetadata

?????文件???????1762??2017-11-22?10:01??案例：新聞發布系統\news_chapter13_full\.project

?????文件????????500??2016-08-01?16:39??案例：新聞發布系統\news_chapter13_full\.settings\.jsdtscope

?????文件?????????94??2017-11-19?16:20??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2016-08-01?16:39??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.jdt.core.prefs

?????文件????????633??2017-11-22?10:01??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.wst.common.component

?????文件????????252??2016-08-01?16:39??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-08-01?16:39??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-08-01?16:39??案例：新聞發布系統\news_chapter13_full\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????242??2016-08-01?16:44??案例：新聞發布系統\news_chapter13_full\resources\database.properties

?????文件????????504??2016-08-01?16:44??案例：新聞發布系統\news_chapter13_full\resources\log4j.properties

?????文件???????1922??2017-11-19?16:20??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\baseDao.java

?????文件????????529??2017-02-13?21:55??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\CommentsDao.java

?????文件???????3122??2017-02-15?16:06??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\impl\CommentsDaoImpl.java

?????文件??????11023??2017-02-15?16:08??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\impl\NewsDaoImpl.java

?????文件???????2899??2016-08-20?18:24??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\impl\TopicsDaoImpl.java

?????文件???????1142??2016-08-20?18:27??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\impl\UserDaoImpl.java

?????文件???????1290??2017-02-15?16:04??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\NewsDao.java

?????文件????????583??2016-08-20?18:24??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\TopicsDao.java

?????文件????????228??2016-08-20?18:26??案例：新聞發布系統\news_chapter13_full\src\org\news\dao\UserDao.java

?????文件???????1099??2016-08-17?13:29??案例：新聞發布系統\news_chapter13_full\src\org\news\entity\Comment.java

?????文件???????2031??2016-08-20?14:41??案例：新聞發布系統\news_chapter13_full\src\org\news\entity\News.java

?????文件????????493??2016-08-17?13:28??案例：新聞發布系統\news_chapter13_full\src\org\news\entity\Topic.java

?????文件????????629??2016-08-17?13:25??案例：新聞發布系統\news_chapter13_full\src\org\news\entity\User.java

?????文件????????440??2017-02-15?16:10??案例：新聞發布系統\news_chapter13_full\src\org\news\service\CommentsService.java

?????文件???????2319??2017-02-15?16:13??案例：新聞發布系統\news_chapter13_full\src\org\news\service\impl\CommentsServiceImpl.java

?????文件???????7448??2017-02-15?16:15??案例：新聞發布系統\news_chapter13_full\src\org\news\service\impl\NewsServiceImpl.java

?????文件???????4178??2016-08-21?12:15??案例：新聞發布系統\news_chapter13_full\src\org\news\service\impl\TopicsServiceImpl.java

?????文件????????767??2016-08-21?09:31??案例：新聞發布系統\news_chapter13_full\src\org\news\service\impl\UserServiceImpl.java

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