package?com.buy.bean.coin;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?com.buy.bean.comm.database.DBConnect;
public?class?AddcoinSelectBean?{
	String?s_year=?“1700“?s_month?=?“1“?s_day=?“1“?e_year=?“2099“?e_month=?“1“?e_day=?“1“type=“0“num=null;
	
	public?AddcoinSelectBean（）{
		
	}
	public?void?setNum（String?num）?{
		this.num?=?num;
	}
	
	public?void?setType（String?type）{
		this.type?=?type;
	}
	public?void?setS_year（String?s_year）?{
		this.s_year?=?s_year;
	}
	
	public?void?setS_month（String?s_month）?{
		this.s_month?=?s_month;
	}
	
	public?void?setS_day（String?s_day）?{
		this.s_day?=?s_day;
	}
	public?void?setE_year（String?e_year）?{
		this.e_year?=?e_year;
	}
	
	public?void?setE_month（String?e_month）?{
		this.e_month?=?e_month;
	}
	public?void?setE_day（String?e_day）?{
		this.e_day?=?e_day;
	}
	public?StringBuffer?selectAddcoin（String?userID）{
		String?type1?=?null;
		int?j?=?Integer.parseInt（type）;
		switch?（j）{
		case?0:
			type1?=?“Any“;break;
		case?1:
			type1?=?“在線充值“;break;
		case?2:
			type1?=?“個人銀行充值“;break;
		case?3:
			type1?=?“代理充值“;break;
		case?4:
			type1?=?“匯款充值“;break;
		}
		String?s_date?=?s_year?+?“-“?+?s_month?+?“-“?+?s_day;
		String?e_date?=?e_year?+?“-“?+?e_month?+?“-“?+?e_day;
		String?condition;
		
		if（num!=null）{
			condition?=?“select?addidtypecoindatetime?from?buy.add?where?USERID?=‘“+?userID?+?“‘?and?addid?=?“+num+““;?
		}else{
			condition?=?“select?addidtypecoindatetime?from?buy.add?where?USERID?=‘“+?userID?+?“‘?and?datetime?<=?‘“+?e_date+?“‘and?datetime?>=?‘“?+?s_date?+“‘“;
			
			if（j?!=?0）{
				condition?+=??“and?type?=‘“+type1+“‘“;??
			}
		}	
		ResultSet?rs?=?null;
		String?type?coin?datenum;
		Statement?sql?=?null;
		StringBuffer?buffer?=?new?StringBuffer（）;
		try?{
			Connection?conn?=?DBConnect.getConnection（）;
			sql?=?conn.createStatement（）;
			rs?=?sql.executeQuery（condition）;
			int?i?=?1;	
			buffer.append（““）;
			buffer.append（““）;
			buffer.append（“					+?“cal_td12“?+?“>充值編號“）;
			buffer.append（“					+?“cal_td12“?+?“>充值類型“）;
			buffer.append（“					+?“cal_td12“?+?“>充值金額“）;
			buffer.append（“					+?“cal_td12“?+?“>充值時間“）;
			buffer.append（““）;
			while?（rs.next（））?{
				buffer.append（““）;
				num?=?rs.getString（1）;//取得第一個字段的值
				if（i%2==1）{//根據奇偶行顯示不同的樣式
				buffer.append（“						+?“?class=“?+?“cal_td06“?+?“>“?+?num?+?““）;
				type?=?rs.getString（2）;//取得第二個字段的值
				buffer.append（“						+?“?class=“?+?“cal_td06“?+?“>“?+?type?+?““）;
	

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

?????文件????????433??2007-11-19?10:18??02\Buy\.classpath

?????目錄??????????0??2008-10-08?08:28??02\Buy\.myeclipse

?????文件????????282??2007-11-19?10:18??02\Buy\.mymetadata

?????文件???????1221??2007-11-19?10:18??02\Buy\.project

?????文件?????????88??2007-11-19?10:18??02\Buy\.settings\org.eclipse.core.resources.prefs

?????目錄??????????0??2008-10-08?08:28??02\Buy\.settings

?????文件???????4262??2007-11-19?10:18??02\Buy\src\com\buy\bean\coin\AddcoinSelectBean.java

?????文件???????3831??2007-11-19?10:18??02\Buy\src\com\buy\bean\coin\ConsumeSelectBean.java

?????文件???????1217??2007-11-19?10:18??02\Buy\src\com\buy\bean\coin\ConsumeSelectBean1.java

?????文件???????5755??2007-11-19?10:18??02\Buy\src\com\buy\bean\coin\OrderSelectBean.java

?????文件???????1911??2007-11-19?10:18??02\Buy\src\com\buy\bean\coin\UsercoinSelectBean.java

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy\bean\coin

?????文件????????784??2007-11-19?10:18??02\Buy\src\com\buy\bean\comm\database\Config.java

?????文件????????162??2007-11-19?10:18??02\Buy\src\com\buy\bean\comm\database\config.properties

?????文件????????783??2007-11-19?10:18??02\Buy\src\com\buy\bean\comm\database\DBConnect.java

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy\bean\comm\database

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy\bean\comm

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy\bean

?????文件???????3302??2007-11-19?10:18??02\Buy\src\com\buy\util\EncodingFilter.java

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy\util

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com\buy

?????目錄??????????0??2008-10-08?08:28??02\Buy\src\com

?????目錄??????????0??2008-10-08?08:28??02\Buy\src

?????目錄??????????0??2008-10-08?08:28??02\Buy\WebRoot\Buy\scripts

?????文件??????15760??2007-11-19?10:18??02\Buy\WebRoot\Buy\style\cal\rightcal_style01.css

?????目錄??????????0??2008-10-08?08:28??02\Buy\WebRoot\Buy\style\cal

?????文件??????14654??2007-11-19?10:18??02\Buy\WebRoot\Buy\style\style.css

?????目錄??????????0??2008-10-08?08:28??02\Buy\WebRoot\Buy\style

?????目錄??????????0??2008-10-08?08:28??02\Buy\WebRoot\Buy

?????文件???????9647??2007-11-19?10:18??02\Buy\WebRoot\COIN\addcoinrecord.jsp

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