package?com.DAO;

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

import?com.entity.*;
import?com.DBManage.*;
import?com.DAO.*;


public?class?ConsumeDAO?{
	static?ResultSet?rs?=?null;
	//增加
	public?static?void?addConsume（Consume?c）{
		String?strSql?=?“insert?into??tblConsume?values?（???????）“;
		List?list?=?new?ArrayList（）;
		list.add（c.getConmphone（））;
		list.add（c.getConemid（））;
		list.add（c.getConserid（））;
		list.add（new?java.sql.Date（c.getCondate（）.getTime（）））;
		list.add（c.getConagio（））;
		list.add（c.getConmoney（））;
		list.add（c.getConremark（））;
		
		DBManage.executeSql（strSql?list）;
	}

	//更改
	public?static?void?updateConsume（Consume?c）{
		String?strSql?=?“update?tblConsume?set?conemid?=??conserid?=??condate?=??conagio?=??conmoney?=??conremark?=??where?conmphone=??“;
		List?list?=?new?ArrayList（）;
		list.add（c.getConemid（））;
		list.add（c.getConserid（））;
		list.add（new?java.sql.Date（c.getCondate（）.getTime（）））;
		list.add（c.getConagio（））;
		list.add（c.getConmoney（））;
		list.add（c.getConremark（））;
		list.add（c.getConmphone（））;
		
		DBManage.executeSql（strSql?list）;
	}
	
	//根據消費ID更改
	public?static?void?updateConsumeByConID（int?conid）{
		String?strSql?=?“update?tblConsume?conremark?=??where?conid=??“;
		List?list?=?new?ArrayList（）;
		list.add（conid）;
		DBManage.executeSql（strSql?list）;
	}
	
	//按照conID更改電話號碼
	public?static?void?updateConsumePhoneByConID（String?conmphone?int?conid）{
		String?strSql?=?“update?tblConsume?set?conmphone?=???where?conid=??“;
		List?list?=?new?ArrayList（）;
		list.add（conmphone）;
		list.add（conid）;
		DBManage.executeSql（strSql?list）;
	}
	
	//查詢全部
	public?static?List?selectAll（）{
		String?strSql?=?“select?*?from?tblConsume“;
		List?list?=?new?ArrayList（）;
		rs?=?DBManage.selectMember（strSql?null）;
		List??listmember?=?new?ArrayList（）;
		try?{
			while（rs.next（））{
				Consume?s?=?new?Consume（）;
				s.setConid（rs.getInt（“conid“））;
				s.setConmphone（rs.getString（“conmphone“））;
				s.setConemid（rs.getInt（“conemid“））;
				s.setConserid（rs.getInt（“conserid“））;
				s.setCondate（rs.getDate（“condate“））;
				s.setConagio（rs.getInt（“conagio“））;
				s.setConmoney（rs.getInt（“conmoney“））;
				s.setConremark（rs.getString（“conremark“））;
				
				listmember.add（s）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		finally{
			closeSelect（）;
		}
		return?listmember;
	}
	//按照消費ID查詢
	
	public?static?List?selectByConID（int?conid）{
		String?strSql?=?“select?*?from?tblConsume?where?conid?=??“;
		List?list?=?new?ArrayList（）;
		list.add（conid）;
		rs?=?DBManage.selectMember（strSql?list）;
		List??listmember?=?new?ArrayList（）;
		try?{
			while（rs.next（））{
				Consume?s?=?new?Consume（）;
				s.setConid（rs.getInt（“conid“））;
				s.setConmphone（rs.getString（“conmphone“））;
				s.setConemid（rs.getInt（“conemid“））;
			

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

?????文件????????687??2011-10-26?01:14??MemberManagement-v11.9\.classpath

?????文件????????392??2010-11-01?11:11??MemberManagement-v11.9\.project

?????文件????????629??2010-11-08?22:52??MemberManagement-v11.9\.settings\org.eclipse.jdt.core.prefs

?????文件?????540852??2011-10-25?21:20??MemberManagement-v11.9\bin\mysql-connector-java-5.0.8-bin.jar

?????文件?????466359??2011-10-25?23:56??MemberManagement-v11.9\bin\SQLServerJDBC.jar

?????文件???????1202??2011-10-26?01:00??MemberManagement-v11.9\bin\com\entity\Services.class

?????文件???????3654??2011-10-26?01:00??MemberManagement-v11.9\bin\com\entity\Member.class

?????文件???????5670??2011-10-26?01:00??MemberManagement-v11.9\bin\com\entity\Employee.class

?????文件???????2730??2011-10-26?01:00??MemberManagement-v11.9\bin\com\entity\Consume.class

?????文件???????6743??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe.class

?????文件????????690??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$7.class

?????文件????????689??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$2.class

?????文件????????692??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$10.class

?????文件????????690??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$8.class

?????文件????????690??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$6.class

?????文件????????690??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$5.class

?????文件????????692??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$9.class

?????文件???????2279??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$12.class

?????文件????????692??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$11.class

?????文件????????689??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$3.class

?????文件????????689??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$1.class

?????文件????????677??2011-10-26?01:07??MemberManagement-v11.9\bin\com\Main\Mainframe$4.class

?????文件???????8776??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe.class

?????文件????????705??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$11.class

?????文件???????1093??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$3.class

?????文件???????1125??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$5.class

?????文件???????3100??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$8.class

?????文件???????1843??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$4.class

?????文件???????2496??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$10.class

?????文件???????1660??2011-10-26?01:00??MemberManagement-v11.9\bin\com\frames\Registframe$9.class

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