package?com.dao;

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

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

//對(duì)公告信息的操作
public?class?AfficheDao?{
??private?Connection?connection?=?null;?//定義連接的對(duì)象
??private?PreparedStatement?ps?=?null;?//定義預(yù)準(zhǔn)備的對(duì)象
??private?JDBConnection?jdbc?=?null;?//定義數(shù)據(jù)庫連接對(duì)象
??public?AfficheDao（）?{
????jdbc?=?new?JDBConnection（）;
????connection?=?jdbc.connection;?//利用構(gòu)造方法取得數(shù)據(jù)庫連接
??}

??//刪除的方法
??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）?{
????}
??}

//以數(shù)據(jù)庫流水號(hào)為條件查詢信息
??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;

??}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????652??2008-06-05?08:45??marketplace\.classpath

?????文件????????306??2008-06-05?08:47??marketplace\.mymetadata

?????文件???????1229??2008-04-18?11:45??marketplace\.project

?????文件????1054208??2008-06-06?11:21??marketplace\程序使用說明書.doc

?????文件???????5531??2007-01-15?11:16??marketplace\src\com\webtier\AfficheAction.java

?????文件???????5135??2007-01-15?11:16??marketplace\src\com\webtier\BigTypeAction.java

?????文件??????18370??2008-05-07?11:13??marketplace\src\com\webtier\GoodsAction.java

?????文件???????4954??2007-01-15?11:16??marketplace\src\com\webtier\linkAction.java

?????文件???????8738??2008-04-25?08:45??marketplace\src\com\webtier\ManagerAction.java

?????文件???????8487??2008-06-05?10:49??marketplace\src\com\webtier\MemberAction.java

?????文件???????4246??2007-01-15?11:16??marketplace\src\com\webtier\OrderAction.java

?????文件???????6707??2007-01-15?11:16??marketplace\src\com\webtier\SmallTypeAction.java

?????文件????????908??2007-01-15?11:16??marketplace\src\com\tool\Chinese.java

?????文件???????8400??2008-05-07?10:53??marketplace\src\com\tool\FinalConstants.java

?????文件????????555??2007-01-15?11:16??marketplace\src\com\tool\JDBConnection.java

?????文件????????867??2007-01-15?11:16??marketplace\src\com\tool\ManagerList.java

?????文件????????780??2007-01-15?11:16??marketplace\src\com\tool\ManagerTrace.java

?????文件????????856??2007-01-15?11:16??marketplace\src\com\tool\MemberList.java

?????文件???????1310??2007-01-15?11:16??marketplace\src\com\domain\AfficheForm.java

?????文件???????1152??2007-01-15?11:16??marketplace\src\com\domain\BigTypeForm.java

?????文件???????2515??2007-01-15?11:16??marketplace\src\com\domain\GoodsForm.java

?????文件???????1639??2007-01-15?11:16??marketplace\src\com\domain\linkForm.java

?????文件???????1463??2007-01-15?11:16??marketplace\src\com\domain\ManagerForm.java

?????文件???????2314??2008-04-24?08:50??marketplace\src\com\domain\MemberForm.java

?????文件???????1314??2007-01-15?11:16??marketplace\src\com\domain\OrderDetailForm.java

?????文件???????2208??2007-01-15?11:16??marketplace\src\com\domain\OrderForm.java

?????文件????????170??2007-01-15?11:16??marketplace\src\com\domain\SellGoodsForm.java

?????文件???????1380??2007-01-15?11:16??marketplace\src\com\domain\SmallTypeForm.java

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

?????文件???????2939??2008-05-07?09:42??marketplace\src\com\dao\BigTypeDao.java

............此處省略271個(gè)文件信息