package?com.wy.dao;

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

import?com.wy.tool.JDBConnection;
import?com.wy.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（“delete?from?tb_affiche?where?id=?“）;
??????ps.setInt（1?id.intValue（））;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????	ex.printStackTrace（）;
????}
??}

??//修改的方法
??public?void?updateAffiche（AfficheForm

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1043??2019-05-17?10:34??.project
?????文件?????????528??2019-05-23?12:02??readme?.txt
?????目錄???????????0??2019-05-17?10:35??.settings\
?????文件?????????503??2013-06-30?10:20??.settings\.jsdtscope
?????文件?????????670??2019-05-17?10:37??.settings\org.eclipse.jdt.core.prefs
?????文件?????????454??2013-06-30?10:20??.settings\org.eclipse.wst.common.component
?????文件?????????345??2013-06-30?10:20??.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-06-30?10:20??.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-06-30?10:20??.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-05-17?10:35??build\
?????目錄???????????0??2019-05-17?10:37??build\classes\
?????目錄???????????0??2019-05-17?10:37??build\classes\com\
?????目錄???????????0??2019-05-17?10:37??build\classes\com\wy\
?????目錄???????????0??2019-05-17?10:37??build\classes\com\wy\dao\
?????文件????????3322??2019-05-17?10:37??build\classes\com\wy\dao\AfficheDao.class
?????文件????????2860??2019-05-17?10:37??build\classes\com\wy\dao\BigTypeDao.class
?????文件????????6968??2019-05-17?10:37??build\classes\com\wy\dao\GoodsDao.class
?????文件????????2490??2019-05-17?10:37??build\classes\com\wy\dao\linkDao.class
?????文件????????3427??2019-05-17?10:37??build\classes\com\wy\dao\ManagerDao.class
?????文件????????5512??2019-05-17?10:37??build\classes\com\wy\dao\MemberDao.class
?????文件????????4701??2019-05-17?10:37??build\classes\com\wy\dao\OrderDao.class
?????文件????????3030??2019-05-17?10:37??build\classes\com\wy\dao\OrderDetailDao.class
?????文件????????4256??2019-05-17?10:37??build\classes\com\wy\dao\SmallTypeDao.class
?????目錄???????????0??2019-05-17?10:37??build\classes\com\wy\domain\
?????文件????????1807??2019-05-17?10:37??build\classes\com\wy\domain\AfficheForm.class
?????文件????????1662??2019-05-17?10:37??build\classes\com\wy\domain\BigTypeForm.class
?????文件????????3063??2019-05-17?10:37??build\classes\com\wy\domain\GoodsForm.class
?????文件????????1444??2019-05-17?10:37??build\classes\com\wy\domain\linkForm.class
?????文件????????2049??2019-05-17?10:37??build\classes\com\wy\domain\ManagerForm.class
?????文件????????2311??2019-05-17?10:37??build\classes\com\wy\domain\MemberForm.class
?????文件????????1954??2019-05-17?10:37??build\classes\com\wy\domain\OrderDetailForm.class
............此處省略198個文件信息