package?com.itshop.dao;

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

import?com.itshop.struts.form.BigTypeForm;
import?com.itshop.tool.Finalsql;
import?com.itshop.tool.JDBConnection;


public?class?BigTypeDao?{
??private?Connection?connection?=?null;?
??private?PreparedStatement?ps?=?null;?
??private?JDBConnection?jdbc?=?null;?
??public?BigTypeDao（）?{
????jdbc?=?new?JDBConnection（）;
????connection?=?jdbc.connection;?
??}

//以數據庫流水號為條件查詢大類別的名稱
??public?String?selectName（Integer?id）?{
????String?name?=?null;
????try?{
??????this.ps?=?connection.prepareStatement（Finalsql.big_selectOne）;
??????ps.setString（1?id.toString（））;
??????ResultSet?rs?=?ps.executeQuery（）;
??????while?（rs.next（））?{
????????name?=?rs.getString（“bigName“）;
??????}
????}
????catch?（SQLException?ex）?{
????}
????return?name;
??}

//刪除操作
??public?boolean?deleteBig（Integer?id）?{
????try?{
??????ps?=?connection.prepareStatement（Finalsql.big_delete）;
??????ps.setString（1?id.toString（））;
??????ps.executeUpdate（）;
??????ps.close（）;
??????return?true;
????}
????catch?（SQLException?ex）?{
??????return?false;
????}
??}

??//修改操作
??public?void?updateBig（BigTypeForm?form）?{
????try?{
??????ps?=?connection.prepareStatement（Finalsql.big_update）;
??????ps.setString（1?form.getBigName（））;
??????ps.setString（2?form.getId（）.toString（））;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????}
??}

???//添加操作
??public?void?insertBig（String?name）?{
????try?{
??????ps?=?connection.prepareStatement（Finalsql.big_insert）;
??????ps.setString（1?name）;
??????ps.executeUpdate（）;
??????ps.close（）;
????}
????catch?（SQLException?ex）?{
????}
??}

?//以數據庫流水號為條件查詢信息
??public?BigTypeForm?selectOneBig（Integer?id）?{
????BigTypeForm?big?=?null;
????try?{
??????this.ps?=?connection.prepareStatement（Finalsql.big_selectOne）;
??????ps.setString（1?id.toString（））;
??????ResultSet?rs?=?ps.executeQuery（）;
??????while?（rs.next（））?{
????????big?=?new?BigTypeForm（）;
????????big.setId（Integer.valueOf（rs.getString（1）））;
????????big.setBigName（rs.getString（2））;
????????big.setCreaTime（rs.getString（3））;
??????}
????}
????catch?（SQLException?ex）?{
????}
????return?big;
??}

???//全部查詢的操作
??public?List?selectBig（）?{
	List?list?=?new?ArrayList（）;
????BigTypeForm?big?=?null;
????try?{
?????
??????this.ps?=?connection.prepareStatement（Finalsql.big_select）;
??????ResultSet?rs?=?ps.executeQuery（）;
??????while?（rs.next（））?{
????????big?=?new?BigTypeForm（）;
????????big.setId（Integer.valueOf（rs.getString（1）））;
????????big.setBigName（rs.getString（2））;
????????big.setCreaTime（rs.getString（3））;
????????list.add（big）;
??????}
????}
????catch?（SQLException?ex）?{
????}
????return?list;
??}

}

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

?????文件?????709120??2011-03-30?18:47??論文答辨PPT.ppt

?????文件???????1473??2009-01-05?22:00??itshop\.classpath

?????文件????????291??2009-01-05?22:00??itshop\.mymetadata

?????文件????????257??2008-10-31?14:50??itshop\.mystrutsdata

?????文件???????1307??2008-10-31?14:50??itshop\.project

?????文件????????137??2008-11-06?09:08??itshop\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件????1835008??2009-01-05?17:24??itshop\database\db_shop_Data.MDF

?????文件????3932160??2009-01-05?17:24??itshop\database\db_shop_Log.LDF

?????文件???????2863??2008-11-13?15:17??itshop\src\com\itshop\dao\BigTypeDao.java

?????文件???????2338??2008-11-26?10:24??itshop\src\com\itshop\dao\FromDao.java

?????文件???????2686??2008-11-13?15:18??itshop\src\com\itshop\dao\GonggaoDao.java

?????文件???????8823??2008-12-02?10:24??itshop\src\com\itshop\dao\GoodsDao.java

?????文件???????3819??2008-12-03?18:19??itshop\src\com\itshop\dao\linkDao.java

?????文件???????3814??2008-11-19?17:05??itshop\src\com\itshop\dao\ManagerDao.java

?????文件???????3964??2008-12-10?11:17??itshop\src\com\itshop\dao\OrderDao.java

?????文件???????1869??2008-12-02?15:11??itshop\src\com\itshop\dao\OrderDetailDao.java

?????文件???????3914??2008-11-19?17:06??itshop\src\com\itshop\dao\SmallTypeDao.java

?????文件???????6194??2008-12-12?19:48??itshop\src\com\itshop\dao\UserDao.java

?????文件???????5315??2008-11-13?15:44??itshop\src\com\itshop\struts\action\BigTypeAction.java

?????文件???????4056??2008-11-26?11:43??itshop\src\com\itshop\struts\action\FromAction.java

?????文件???????6124??2009-01-05?16:26??itshop\src\com\itshop\struts\action\GonggaoAction.java

?????文件??????17087??2009-01-05?16:26??itshop\src\com\itshop\struts\action\GoodsAction.java

?????文件???????5418??2008-12-03?18:20??itshop\src\com\itshop\struts\action\linkAction.java

?????文件???????8486??2009-01-05?16:27??itshop\src\com\itshop\struts\action\ManagerAction.java

?????文件???????3633??2008-11-30?14:07??itshop\src\com\itshop\struts\action\OrderAction.java

?????文件???????6857??2009-01-05?16:23??itshop\src\com\itshop\struts\action\SmallTypeAction.java

?????文件???????7900??2009-01-05?16:27??itshop\src\com\itshop\struts\action\UserAction.java

?????文件?????????84??2008-10-31?14:50??itshop\src\com\itshop\struts\ApplicationResources.properties

?????文件???????1266??2008-11-06?14:04??itshop\src\com\itshop\struts\form\BigTypeForm.java

?????文件???????1522??2008-11-20?09:24??itshop\src\com\itshop\struts\form\FromForm.java

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