package?com.dao;

import?java.sql.*;
import?java.util.*;

import?com.tool.JDBConnection;
import?com.tool.FinalConstants;
import?com.domain.AfficheForm;

//對公告信息的操作
public?class?AfficheDao?{
??private?Connection?connection?=?null;?//定義連接的對象
??private?PreparedStatement?ps?=?null;?//定義預準備的對象
??private?JDBConnection?jdbc?=?null;?//定義數據庫連接對象
??public?AfficheDao（）?{
????jdbc?=?new?JDBConnection（）;
????connection?=?jdbc.connection;?//利用構造方法取得數據庫連接
??}

??//刪除的方法
??public?void?deleteAffiche（Integer?id）?{
????try?{
??????ps?=?connection.prepareStatement（FinalConstants.affice_delete）;
??????ps.setInt（1?id.intValue（））;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????}
??}

??//修改的方法
??public?void?updateAffiche（AfficheForm?form）?{
????try?{
??????ps?=?connection.prepareStatement（FinalConstants.affice_update）;
??????ps.setString（1?form.getName（））;
??????ps.setString（2?form.getContent（））;
??????ps.setInt（3?form.getId（）.intValue（））;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????}
??}

//添加的方法
??public?void?insertAffiche（AfficheForm?form）?{
????try?{
??????ps?=?connection.prepareStatement（FinalConstants.affice_insert）;
??????ps.setString（1?form.getName（））;
??????ps.setString（2?form.getContent（））;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????}
??}

//以數據庫流水號為條件查詢信息
??public?AfficheForm?selectOneAffiche（Integer?id）?{
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement（FinalConstants.affice_selectOne）;
??????ps.setInt（1?id.intValue（））;
??????ResultSet?rs?=?ps.executeQuery（）;
??????while?（rs.next（））?{
????????affiche?=?new?AfficheForm（）;
????????affiche.setId（Integer.valueOf（rs.getString（1）））;
????????affiche.setName（rs.getString（2））;
????????affiche.setContent（rs.getString（3））;
????????affiche.setIssueTime（rs.getString（4））;
??????}
????}
????catch?（SQLException?ex）?{
????}
????return?affiche;
??}

//全部查詢的方法
??public?List?selectAffiche（）?{
????List?list?=?new?ArrayList（）;
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement（FinalConstants.affiche_select）;
??????ResultSet?rs?=?ps.executeQuery（）;
??????while?（rs.next（））?{
????????affiche?=?new?AfficheForm（）;
????????affiche.setId（Integer.valueOf（rs.getString（1）））;
????????affiche.setName（rs.getString（2））;
????????affiche.setContent（rs.getString（3））;
????????affiche.setIssueTime（rs.getString（4））;
????????list.add（affiche）;
??????}
????}
????catch?（SQLException?ex）?{
????}
????return?list;

??}

}

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

?????文件???????2417??2018-06-27?15:40??marketplace\.classpath

?????文件????????306??2008-12-03?12:09??marketplace\.mymetadata

?????文件????????262??2008-12-05?22:08??marketplace\.mystrutsdata

?????文件???????1837??2018-06-27?01:10??marketplace\.project

?????文件????????500??2008-12-03?09:30??marketplace\.settings\.jsdtscope

?????文件????????390??2018-06-27?01:10??marketplace\.settings\com.genuitec.eclipse.migration.prefs

?????文件?????????55??2018-06-27?01:14??marketplace\.settings\org.eclipse.core.resources.prefs

?????文件????????334??2008-12-03?09:30??marketplace\.settings\org.eclipse.jdt.core.prefs

?????文件????????637??2018-06-27?01:10??marketplace\.settings\org.eclipse.wst.common.component

?????文件????????354??2018-07-01?17:59??marketplace\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件????????411??2018-06-27?01:10??marketplace\.settings\org.eclipse.wst.common.project.facet.core.xml.bak

?????文件?????????49??2008-12-03?09:30??marketplace\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2008-12-03?09:30??marketplace\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3091??2007-01-15?11:16??marketplace\src\com\dao\AfficheDao.class

?????文件???????2725??2008-12-07?09:58??marketplace\src\com\dao\AfficheDao.java

?????文件???????3301??2007-01-15?11:16??marketplace\src\com\dao\BigTypeDao.class

?????文件???????2939??2008-01-06?00:53??marketplace\src\com\dao\BigTypeDao.java

?????文件???????6502??2007-01-15?11:16??marketplace\src\com\dao\GoodsDao.class

?????文件???????7967??2008-12-04?17:02??marketplace\src\com\dao\GoodsDao.java

?????文件???????3621??2007-01-15?11:16??marketplace\src\com\dao\linkDao.class

?????文件???????3432??2008-12-04?17:02??marketplace\src\com\dao\linkDao.java

?????文件???????3815??2007-01-15?11:16??marketplace\src\com\dao\ManagerDao.class

?????文件???????3795??2008-01-06?00:53??marketplace\src\com\dao\ManagerDao.java

?????文件???????5427??2007-01-15?11:16??marketplace\src\com\dao\MemberDao.class

?????文件???????6352??2008-12-06?20:43??marketplace\src\com\dao\MemberDao.java

?????文件???????4384??2007-01-15?11:16??marketplace\src\com\dao\OrderDao.class

?????文件???????4284??2008-12-04?17:04??marketplace\src\com\dao\OrderDao.java

?????文件???????3091??2007-01-15?11:16??marketplace\src\com\dao\OrderDetailDao.class

?????文件???????1977??2008-12-04?17:04??marketplace\src\com\dao\OrderDetailDao.java

?????文件???????3901??2007-01-15?11:16??marketplace\src\com\dao\SmallTypeDao.class

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