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;

/**
?*?執行數據庫操作的工具類。
?*?
?*?@author?北大青鳥
?*/
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;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\
?????文件????????1585??2018-06-13?15:23??News_chapter_12\.classpath
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\.myeclipse\
?????文件?????????305??2017-02-15?21:00??News_chapter_12\.mymetadata
?????文件????????1757??2017-02-14?21:07??News_chapter_12\.project
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\.settings\
?????文件?????????500??2016-08-01?16:39??News_chapter_12\.settings\.jsdtscope
?????文件????????1009??2018-06-12?15:17??News_chapter_12\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????247??2018-06-11?22:46??News_chapter_12\.settings\com.genuitec.eclipse.migration.prefs
?????文件??????????57??2018-06-12?15:17??News_chapter_12\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-02-13?15:02??News_chapter_12\.settings\org.eclipse.jdt.core.prefs
?????文件?????????713??2018-06-12?15:17??News_chapter_12\.settings\org.eclipse.wst.common.component
?????文件?????????361??2018-06-11?22:46??News_chapter_12\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-08-01?16:39??News_chapter_12\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-08-01?16:39??News_chapter_12\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\meta-INF\
?????文件??????????36??2016-08-01?16:39??News_chapter_12\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\classes\meta-INF\
?????文件??????????25??2018-06-11?22:46??News_chapter_12\WebRoot\WEB-INF\classes\meta-INF\MANIFEST.MF
?????文件?????????241??2018-06-11?22:59??News_chapter_12\WebRoot\WEB-INF\classes\database.properties
?????文件?????????504??2016-08-01?16:44??News_chapter_12\WebRoot\WEB-INF\classes\log4j.properties
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\classes\org\
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\classes\org\news\
?????目錄???????????0??2018-07-23?19:54??News_chapter_12\WebRoot\WEB-INF\classes\org\news\dao\
?????文件????????1814??2018-07-13?19:13??News_chapter_12\WebRoot\WEB-INF\classes\org\news\dao\baseDao.class
?????文件?????????432??2018-07-13?19:13??News_chapter_12\WebRoot\WEB-INF\classes\org\news\dao\CommentsDao.class
?????文件????????1077??2018-07-13?19:13??News_chapter_12\WebRoot\WEB-INF\classes\org\news\dao\NewsDao.class
?????文件?????????507??2018-07-13?19:13??News_chapter_12\WebRoot\WEB-INF\classes\org\news\dao\TopicsDao.class
............此處省略147個文件信息