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.coin.database.DBConnect;

public?class?AddcoinSelectBean?{

	String?s_year=“1700“s_month?=?“1“?s_day?=?“1“
			e_year?=?“2012“?e_month?=?“12“?e_day?=“30“type?=?“0“?num?=?null;

	public?String?getS_year（）?{
		return?s_year;
	}

	public?void?setS_year（String?sYear）?{
		s_year?=?sYear;
	}

	public?String?getS_month（）?{
		return?s_month;
	}

	public?void?setS_month（String?sMonth）?{
		s_month?=?sMonth;
	}

	public?String?getS_day（）?{
		return?s_day;
	}

	public?void?setS_day（String?sDay）?{
		s_day?=?sDay;
	}

	public?String?getE_year（）?{
		return?e_year;
	}

	public?void?setE_year（String?eYear）?{
		e_year?=?eYear;
	}

	public?String?getE_month（）?{
		return?e_month;
	}

	public?void?setE_month（String?eMonth）?{
		e_month?=?eMonth;
	}

	public?String?getE_day（）?{
		return?e_day;
	}

	public?void?setE_day（String?eDay）?{
		e_day?=?eDay;
	}

	public?String?getType（）?{
		return?type;
	}

	public?void?setType（String?type）?{
		this.type?=?type;
	}

	public?String?getNum（）?{
		return?num;
	}

	public?void?setNum（String?num）?{
		this.num?=?num;
	}
	
	public?StringBuffer?selectAddcoin（int?userID）{
		String?type1?=?null;
		int?j?=?Integer.parseInt（type）;
		switch（j）{
		case?0:
			type?=?“Any“;?break;
		case?1:
			type?=?“在線充值“;?break;
		case?2:
			type?=?“個人銀行充值“;?break;
		case?3:
			type?=?“代理充值“;?break;
		case?4:
			type?=?“匯款充值“;?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?>=‘“+s_date+“‘?and?datetime<=‘“+e_date+“‘“;
			if（j!=0）{
				condition?+=?“?and?type?=‘“+type?+“‘“;
			}
		}
		
		Statement?st?=null;
		Connection?conn?=?null;
		ResultSet?rs?=?null;
		String?typecoindatenum;
		StringBuffer?buffer?=?new?StringBuffer（）;
		
		try{
			conn?=?new?DBConnect（）.getConnection（）;
			st?=?conn.createStatement（）;
			rs?=?st.executeQuery（condition）;
			buffer.append（““）;
			buffer.append（““）;
			buffer.append（“ “）;
			buffer.append（“充值編號“）;
			buffer.append（“充值類型“）;
			buffer.append（“充值金額“）;
			buffer.append（“充值時間“）;
			buf

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

?????文件????????478??2011-08-08?18:30??Buy\.classpath

?????文件????????282??2011-08-08?17:20??Buy\.mymetadata

?????文件???????1409??2011-08-08?20:11??Buy\.project

?????文件????????500??2011-08-08?17:20??Buy\.settings\.jsdtscope

?????文件????????330??2011-08-08?17:20??Buy\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-08-08?17:20??Buy\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-08-08?17:20??Buy\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2994??2011-08-09?20:14??Buy\data\buy.sql

?????文件???????1000??2011-08-09?20:24??Buy\readme.txt

?????文件???????3862??2011-08-09?19:31??Buy\src\com\buy\bean\coin\AddcoinSelectBean.java

?????文件???????3641??2011-08-09?20:12??Buy\src\com\buy\bean\coin\ConsumeSelectBean.java

?????文件???????1207??2011-08-08?19:32??Buy\src\com\buy\bean\coin\ConsumeSelectBean1.java

?????文件????????714??2011-08-08?18:27??Buy\src\com\buy\bean\coin\database\Config.java

?????文件????????149??2011-08-08?18:24??Buy\src\com\buy\bean\coin\database\config.properties

?????文件????????522??2011-08-09?19:19??Buy\src\com\buy\bean\coin\database\DBConnect.java

?????文件???????3978??2011-08-09?17:45??Buy\src\com\buy\bean\coin\OrderSelectBean.java

?????文件???????1348??2011-08-08?19:05??Buy\src\com\buy\bean\coin\UsercionselectBean.java

?????文件????????419??2011-08-09?19:26??Buy\src\com\buy\bean\test\Test.java

?????文件???????7362??2011-08-09?19:29??Buy\WebRoot\COIN\addcoinrecord.jsp

?????文件???????6880??2011-08-09?20:04??Buy\WebRoot\COIN\consumerecord.jsp

?????文件????????822??2011-08-08?20:25??Buy\WebRoot\COIN\left.jsp

?????文件???????7281??2011-08-09?18:31??Buy\WebRoot\COIN\order.jsp

?????文件???????2236??2011-08-08?20:24??Buy\WebRoot\COIN\usercoin.jsp

?????文件????????834??2011-08-08?17:20??Buy\WebRoot\index.jsp

?????文件?????????36??2011-08-08?17:20??Buy\WebRoot\meta-INF\MANIFEST.MF

?????文件???????5242??2011-08-09?19:31??Buy\WebRoot\WEB-INF\classes\com\buy\bean\coin\AddcoinSelectBean.class

?????文件???????5044??2011-08-09?20:12??Buy\WebRoot\WEB-INF\classes\com\buy\bean\coin\ConsumeSelectBean.class

?????文件???????2159??2011-08-08?19:32??Buy\WebRoot\WEB-INF\classes\com\buy\bean\coin\ConsumeSelectBean1.class

?????文件???????1138??2011-08-08?18:30??Buy\WebRoot\WEB-INF\classes\com\buy\bean\coin\database\Config.class

?????文件????????149??2011-08-08?18:24??Buy\WebRoot\WEB-INF\classes\com\buy\bean\coin\database\config.properties

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