tradetypedao.java

java阿里巴巴代码

package com.saas.sys.bpm;

import com.saas.sys.dbm.Dbexecute;
import java.util.*;

import com.saas.biz.commen.commMethodMgr;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import org.apache.commons.beanutils.PropertyUtils;
import com.saas.sys.log.Logger;

public class TradeTypeDAO {
	private Dbexecute exec;
	private commMethodMgr commen;
	ArrayList paramArray = new ArrayList();
	Logger log  = new Logger(this);
	private String trade_type_code;
	private String trade_name;
	private String bpm_id;
	private String judge_rights;
	private String trade_kind;
	private String cancel_tag;
	private String transe_type;
	private String enable_tag;
	private String succeed_fwd;
	private String error_fwd;
	private String start_date;
	private String end_date;
	private String rsrv_str1;
	private String rsrv_str2;
	private String rsrv_str3;
	private String rsrv_str4;
	private String rsrv_str5;
	private String rsrv_str6;
	private String rsrv_str7;
	private String rsrv_str8;
	private String rsrv_str9;
	private String rsrv_str0;
	private String in_date;
	private String remark;
	public String getTrade_type_code(){return trade_type_code;}
	public String getTrade_name(){return trade_name;}
	public String getBpm_id(){return bpm_id;}
	public String getJudge_rights(){return judge_rights;}
	public String getTrade_kind(){return trade_kind;}
	public String getCancel_tag(){return cancel_tag;}
	public String getTranse_type(){return transe_type;}
	public String getSucceed_fwd(){return succeed_fwd;}
	public String getError_fwd(){return error_fwd;}
	public String getEnable_tag(){return enable_tag;}
	public String getStart_date(){return start_date;}
	public String getEnd_date(){return end_date;}
	public String getRsrv_str1(){return rsrv_str1;}
	public String getRsrv_str2(){return rsrv_str2;}
	public String getRsrv_str3(){return rsrv_str3;}
	public String getRsrv_str4(){return rsrv_str4;}
	public String getRsrv_str5(){return rsrv_str5;}
	public String getRsrv_str6(){return rsrv_str6;}
	public String getRsrv_str7(){return rsrv_str7;}
	public String getRsrv_str8(){return rsrv_str8;}
	public String getRsrv_str9(){return rsrv_str9;}
	public String getRsrv_str0(){return rsrv_str0;}
	public String getIn_date(){return in_date;}
	public String getRemark(){return remark;}
	
	public void setTrade_type_code(String trade_type_code){this.trade_type_code=trade_type_code;}
	public void setTrade_name(String trade_name){this.trade_name=trade_name;}
	public void setBpm_id(String bpm_id){this.bpm_id=bpm_id;}
	public void setJudge_rights(String judge_rights){this.judge_rights=judge_rights;}
	public void setTrade_kind(String trade_kind){this.trade_kind=trade_kind;}
	public void setCancel_tag(String cancel_tag){this.cancel_tag=cancel_tag;}
	public void setTranse_type(String transe_type){this.transe_type=transe_type;}
	public void setEnable_tag(String enable_tag){this.enable_tag=enable_tag;}
	public void setSucceed_fwd(String succeed_fwd){this.succeed_fwd=succeed_fwd;}
	public void setError_fwd(String error_fwd){this.error_fwd=error_fwd;}
	public void setStart_date(String start_date){this.start_date=start_date;}
	public void setEnd_date(String end_date){this.end_date=end_date;}
	public void setRsrv_str1(String rsrv_str1){this.rsrv_str1=rsrv_str1;}
	public void setRsrv_str2(String rsrv_str2){this.rsrv_str2=rsrv_str2;}
	public void setRsrv_str3(String rsrv_str3){this.rsrv_str3=rsrv_str3;}
	public void setRsrv_str4(String rsrv_str4){this.rsrv_str4=rsrv_str4;}
	public void setRsrv_str5(String rsrv_str5){this.rsrv_str5=rsrv_str5;}
	public void setRsrv_str6(String rsrv_str6){this.rsrv_str6=rsrv_str6;}
	public void setRsrv_str7(String rsrv_str7){this.rsrv_str7=rsrv_str7;}
	public void setRsrv_str8(String rsrv_str8){this.rsrv_str8=rsrv_str8;}
	public void setRsrv_str9(String rsrv_str9){this.rsrv_str9=rsrv_str9;}
	public void setRsrv_str0(String rsrv_str0){this.rsrv_str0=rsrv_str0;}
	public void setIn_date(String in_date){this.in_date=in_date;}
	public void setRemark(String remark){this.remark=remark;}
	
	public ArrayList selByList(String selBy)
	{
		exec = new Dbexecute();
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tradetype");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		return dataArray;
	}
	
	public TradeTypeDAO selByInfo(String selBy)
	{
		exec = new Dbexecute();
		commen = new commMethodMgr();
		TradeTypeDAO tradeTypeDao = new TradeTypeDAO();
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tradetype");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		Field[] fields = tradeTypeDao.getClass().getDeclaredFields();
		for(Iterator it = dataArray.iterator(); it.hasNext();)
		{
			HashMap tradetype = (HashMap)it.next();
			for (int i=0;i<=fields.length-1;i++)
			{			
				if (tradetype.containsKey(fields[i].getName()))
				{
					try
					{
						PropertyUtils.setProperty(tradeTypeDao, fields[i].getName(), tradetype.get(fields[i].getName()));
					}
					catch (InvocationTargetException e)
					{		
						throw new RuntimeException(e);
					}
					catch (NoSuchMethodException  e)
					{		
						throw new RuntimeException(e);
					}
					catch (IllegalAccessException e)
					{		
						throw new RuntimeException(e);
					}
				}
			}
		}
		return tradeTypeDao;
	}
	
	public int selCount(String selBy)
	{
		exec = new Dbexecute();
		return 0;
	}
	
	public String insert()
	{
		String strQ = "";
		strQ = "insert into tradetype values (" +
				"'"+commen.convetStrToDb(this.getTrade_type_code())+"',"+
				"'"+commen.convetStrToDb(this.getTrade_name())+"',"+
				"'"+commen.convetStrToDb(this.getBpm_id())+"',"+
				"'"+commen.convetStrToDb(this.getJudge_rights())+"',"+
				"'"+commen.convetStrToDb(this.getTrade_kind())+"',"+
				"'"+commen.convetStrToDb(this.getCancel_tag())+"',"+
				"'"+commen.convetStrToDb(this.getTranse_type())+"',"+
				"'"+commen.convetStrToDb(this.getSucceed_fwd())+"',"+
				"'"+commen.convetStrToDb(this.getError_fwd())+"',"+
				"'"+commen.convetStrToDb(this.getEnable_tag())+"',"+
				"'"+commen.convetStrToDb(this.getStart_date())+"',"+
				"'"+commen.convetStrToDb(this.getEnd_date())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str1())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str2())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str3())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str4())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str5())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str6())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str7())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str8())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str9())+"',"+
				"'"+commen.convetStrToDb(this.getRsrv_str0())+"',"+
				"'"+commen.convetStrToDb(this.getIn_date())+"',"+
				"'"+commen.convetStrToDb(this.getRemark())+"'"+
				")";
		return strQ;
	}
	public void setParam(String paramName,Object paramValue)
	{
		HashMap paramMap = new HashMap();
		paramMap.put("paramName", paramName);
		paramMap.put("paramValue", paramValue);
		this.paramArray.add(paramMap);
	}
}