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）?{
????}
??}

??//修改的方法
??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;

??}

}

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

?????文件????????790??2010-12-10?12:08??電子商城\03\.classpath

?????文件????????279??2010-12-10?20:01??電子商城\03\.mymetadata

?????文件????????240??2009-12-31?23:52??電子商城\03\.mystrutsdata

?????文件???????1491??2009-12-31?23:59??電子商城\03\.project

?????文件????????500??2009-12-31?23:48??電子商城\03\.settings\.jsdtscope

?????文件????????334??2009-12-31?23:48??電子商城\03\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2009-12-31?23:48??電子商城\03\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2009-12-31?23:48??電子商城\03\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????13789??2007-08-22?13:49??電子商城\03\class?lib\jspSmartUpload.jar

?????文件?????286907??2008-03-13?11:46??電子商城\03\class?lib\msbase.jar

?????文件??????67228??2008-03-13?11:46??電子商城\03\class?lib\mssqlserver.jar

?????文件??????59074??2008-03-13?11:46??電子商城\03\class?lib\msutil.jar

?????文件????1079296??2008-01-11?11:44??電子商城\03\readme.doc

?????文件?????????62??2009-12-31?23:52??電子商城\03\src\ApplicationResources.properties

?????文件???????2770??2007-11-19?09:11??電子商城\03\src\com\wy\dao\AfficheDao.java

?????文件???????2089??2007-11-19?09:11??電子商城\03\src\com\wy\dao\BigTypeDao.java

?????文件???????9887??2010-01-07?13:03??電子商城\03\src\com\wy\dao\GoodsDao.java

?????文件???????1663??2007-11-19?09:11??電子商城\03\src\com\wy\dao\linkDao.java

?????文件???????2955??2007-11-19?09:11??電子商城\03\src\com\wy\dao\ManagerDao.java

?????文件???????6101??2010-01-06?00:00??電子商城\03\src\com\wy\dao\MemberDao.java

?????文件???????4689??2007-11-19?09:11??電子商城\03\src\com\wy\dao\OrderDao.java

?????文件???????2012??2007-11-19?09:11??電子商城\03\src\com\wy\dao\OrderDetailDao.java

?????文件???????3767??2007-11-19?09:11??電子商城\03\src\com\wy\dao\SmallTypeDao.java

?????文件???????1308??2010-12-09?22:46??電子商城\03\src\com\wy\domain\AfficheForm.java

?????文件???????1155??2007-11-08?13:17??電子商城\03\src\com\wy\domain\BigTypeForm.java

?????文件???????2317??2007-11-22?16:02??電子商城\03\src\com\wy\domain\GoodsForm.java

?????文件????????994??2009-12-31?23:56??電子商城\03\src\com\wy\domain\linkForm.java

?????文件???????1400??2007-11-09?14:55??電子商城\03\src\com\wy\domain\ManagerForm.java

?????文件???????1758??2009-12-31?23:57??電子商城\03\src\com\wy\domain\MemberForm.java

?????文件???????1317??2007-11-08?13:18??電子商城\03\src\com\wy\domain\OrderDetailForm.java

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