package?com.yao.dao.baobiaodao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.yao.dao.commondao.CommonDao;
import?com.yao.dao.customerinfodao.ConditionDao;
import?com.yao.entity.ConditionNum;

public?class?ConditionNumDao?extends?CommonDao{
	/*public?static?void?main（String[]?args）?throws?SQLException?{
		ConditionNumDao?c=new?ConditionNumDao（）;
		List?list=c.queryAll（）;
		for?（ConditionNum?conditionNum?:?list）?{
			System.out.println（conditionNum）;
		}
	}*/
	public?List?queryAll（）?throws?SQLException{
		String?sql=“select?distinct?condition_id?from?customer_info?where?condition_id?is?not?null“;
		List?list=this.Query（sql）;
		return?list;
	}
	@Override
	public?ArrayList?getList（ResultSet?rs）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		ArrayList?list=new?ArrayList（）;
		ConditionDao?conddao=new?ConditionDao（）;
		CountDao?cd=new?CountDao（）;
		while（rs.next（））{
			ConditionNum?c=new?ConditionNum（）;
			c.setCondition_id（rs.getInt（1））;
			c.setCondition_name（conddao.queryNameById（rs.getInt（1）））;
			c.setNum（cd.queryByFlag（“condition_id=“+rs.getInt（1）））;
			list.add（c）;
		}
		return?list;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-05-10?00:09??aaaa\
?????文件????????6148??2017-05-10?00:09??aaaa\.DS_Store
?????目錄???????????0??2017-05-10?00:09??__MACOSX\
?????目錄???????????0??2017-05-10?00:09??__MACOSX\aaaa\
?????文件?????????120??2017-05-10?00:09??__MACOSX\aaaa\._.DS_Store
?????目錄???????????0??2017-05-09?22:27??aaaa\.idea\
?????目錄???????????0??2017-05-09?16:03??aaaa\.idea\artifacts\
?????文件?????????312??2017-05-09?16:03??aaaa\.idea\artifacts\aaaa_war.xml
?????文件?????????500??2017-05-09?14:57??aaaa\.idea\artifacts\aaaa_war_exploded.xml
?????目錄???????????0??2017-03-23?14:11??aaaa\.idea\inspectionProfiles\
?????文件?????????273??2017-03-22?09:52??aaaa\.idea\misc.xml
?????文件?????????248??2017-03-22?09:50??aaaa\.idea\modules.xml
?????文件???????63229??2017-05-09?22:27??aaaa\.idea\workspace.xml
?????文件????????1043??2017-03-22?09:55??aaaa\aaaa.iml
?????文件???????23189??2017-05-10?00:09??aaaa\crm.sql
?????文件?????????261??2017-05-10?00:09??__MACOSX\aaaa\._crm.sql
?????目錄???????????0??2017-05-09?14:58??aaaa\out\
?????文件????????6148??2017-05-09?16:04??aaaa\out\.DS_Store
?????目錄???????????0??2017-05-10?00:09??__MACOSX\aaaa\out\
?????文件?????????120??2017-05-09?16:04??__MACOSX\aaaa\out\._.DS_Store
?????目錄???????????0??2017-05-09?16:03??aaaa\out\artifacts\
?????文件????????6148??2017-05-09?16:04??aaaa\out\artifacts\.DS_Store
?????目錄???????????0??2017-05-10?00:09??__MACOSX\aaaa\out\artifacts\
?????文件?????????120??2017-05-09?16:04??__MACOSX\aaaa\out\artifacts\._.DS_Store
?????目錄???????????0??2017-05-09?16:03??aaaa\out\artifacts\aaaa_war\
?????文件?????3188516??2017-05-09?16:03??aaaa\out\artifacts\aaaa_war\aaaa_war.war
?????目錄???????????0??2017-03-23?14:15??aaaa\out\artifacts\aaaa_war_exploded\
?????目錄???????????0??2017-03-23?14:12??aaaa\out\artifacts\aaaa_war_exploded\css\
?????文件???????26132??2017-05-08?14:14??aaaa\out\artifacts\aaaa_war_exploded\css\bootstrap-theme.css
?????文件???????47706??2017-05-08?14:14??aaaa\out\artifacts\aaaa_war_exploded\css\bootstrap-theme.css.map
?????文件???????23409??2017-05-08?14:14??aaaa\out\artifacts\aaaa_war_exploded\css\bootstrap-theme.min.css
............此處省略944個文件信息