package?com.yjjj.dao;

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

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

//對公告信息的操作
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）?{
????}
??}

??//修改的方法
??public?void?updateAffiche（AfficheForm?form）?{
????try?{
??????ps?=?connection.prepareStatement（“update?tb_affiche?set?name=?content=??where?id=?“）;
??????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（“insert?into?tb_affiche?values?（??getDate（））“）;
??????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（“select?*?from?tb_affiche?where?id=?“）;
??????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（“select?*?from?tb_affiche?order?by?id?DESC“）;
??????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;

??}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-12-16?18:26??宜家家居\
?????目錄???????????0??2010-11-10?08:06??宜家家居\Database_db_shopping\
?????文件?????1395200??2010-11-10?00:13??宜家家居\Database_db_shopping\db_shopping.bak
?????文件?????1310720??2010-11-10?07:37??宜家家居\Database_db_shopping\db_shopping_Data.MDF
?????文件?????1048576??2010-11-10?07:37??宜家家居\Database_db_shopping\db_shopping_Log.LDF
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\
?????文件?????????742??2010-11-09?00:43??宜家家居\yjjj\.classpath
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\.myeclipse\
?????文件?????????286??2010-11-10?00:51??宜家家居\yjjj\.mymetadata
?????文件?????????240??2010-11-08?11:56??宜家家居\yjjj\.mystrutsdata
?????文件????????1493??2010-11-10?00:29??宜家家居\yjjj\.project
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\.settings\
?????文件?????????406??2010-11-08?11:48??宜家家居\yjjj\.settings\.jsdtscope
?????文件????????1040??2010-11-10?00:51??宜家家居\yjjj\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????629??2010-11-09?00:29??宜家家居\yjjj\.settings\org.eclipse.jdt.core.prefs
?????文件?????????137??2010-11-10?00:51??宜家家居\yjjj\.settings\org.eclipse.ltk.core.refactoring.prefs
?????文件??????????49??2010-11-08?11:48??宜家家居\yjjj\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2010-11-08?11:48??宜家家居\yjjj\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\src\
?????文件??????????62??2010-11-08?11:56??宜家家居\yjjj\src\ApplicationResources.properties
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\src\com\
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\src\com\yjjj\
?????目錄???????????0??2010-11-10?08:06??宜家家居\yjjj\src\com\yjjj\dao\
?????文件????????2776??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\AfficheDao.java
?????文件????????2097??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\BigTypeDao.java
?????文件????????8781??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\GoodsDao.java
?????文件????????1573??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\linkDao.java
?????文件????????2961??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\ManagerDao.java
?????文件????????6102??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\MemberDao.java
?????文件????????4697??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\OrderDao.java
?????文件????????2020??2010-11-10?00:28??宜家家居\yjjj\src\com\yjjj\dao\OrderDetailDao.java
............此處省略235個文件信息