bpmdefinitiondao.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 BpmDefinitionDAO {
	private Dbexecute exec;
	private commMethodMgr commen;
	Logger log  = new Logger(this);
	ArrayList paramArray = new ArrayList();
	private String trade_type_code;
	private String bpm_id;
	private String node_id;
	private String node_type;
	private int node_sequence;
	private String node_class;
	private String node_method;
	private String out_query;
	private String out_buffer;
	private String undo_tag;
	private String unde_class;
	private String undo_method;
	private String undo_out_query;
	private String undo_out_buffer;
	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 getBpm_id(){return bpm_id;}
	public String getNode_id(){return node_id;}
	public String getNode_type(){return node_type;}
	public int getNode_sequence(){return node_sequence;}
	public String getNode_class(){return node_class;}
	public String getNode_method(){return node_method;}
	public String getOut_query(){return out_query;}
	public String getOut_buffer(){return out_buffer;}
	public String getUndo_tag(){return undo_tag;}
	public String getUnde_class(){return unde_class;}
	public String getUndo_method(){return undo_method;}
	public String getUndo_out_query(){return undo_out_query;}
	public String getUndo_out_buffer(){return undo_out_buffer;}
	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 setBpm_id(String bpm_id){this.bpm_id=bpm_id;}
	public void setNode_id(String node_id){this.node_id=node_id;}
	public void setNode_type(String node_type){this.node_type=node_type;}
	public void setNode_sequence(int node_sequence){this.node_sequence=node_sequence;}
	public void setNode_class(String node_class){this.node_class=node_class;}
	public void setNode_method(String node_method){this.node_method=node_method;}
	public void setOut_query(String out_query){this.out_query=out_query;}
	public void setOut_buffer(String out_buffer){this.out_buffer=out_buffer;}
	public void setUndo_tag(String undo_tag){this.undo_tag=undo_tag;}
	public void setUnde_class(String unde_class){this.unde_class=unde_class;}
	public void setUndo_method(String undo_method){this.undo_method=undo_method;}
	public void setUndo_out_query(String undo_out_query){this.undo_out_query=undo_out_query;}
	public void setUndo_out_buffer(String undo_out_buffer){this.undo_out_buffer=undo_out_buffer;}
	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("bpmdefinition");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		return dataArray;
	}
	public BpmDefinitionDAO selByInfo(String selBy)
	{
		exec = new Dbexecute();
		commen = new commMethodMgr();
		BpmDefinitionDAO bpmDefinitionDao = new BpmDefinitionDAO();
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("bpmdefinition");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		Field[] fields = bpmDefinitionDao.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(bpmDefinitionDao, 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 bpmDefinitionDao;
	}
	
	public int selCount(String selBy)
	{
		exec = new Dbexecute();
		return 0;
	}
	public String insert()
	{
		String strQ = "";
		strQ = "insert into bpmdefinition values (" +
				"'"+commen.convetStrToDb(this.getTrade_type_code())+"',"+
				"'"+commen.convetStrToDb(this.getBpm_id())+"',"+
				"'"+commen.convetStrToDb(this.getNode_id())+"',"+
				"'"+commen.convetStrToDb(this.getNode_type())+"',"+
				this.getNode_sequence()+","+
				"'"+commen.convetStrToDb(this.getNode_class())+"',"+
				"'"+commen.convetStrToDb(this.getNode_method())+"',"+
				"'"+commen.convetStrToDb(this.getOut_query())+"',"+
				"'"+commen.convetStrToDb(this.getOut_buffer())+"',"+
				"'"+commen.convetStrToDb(this.getUndo_tag())+"',"+
				"'"+commen.convetStrToDb(this.getUnde_class())+"',"+
				"'"+commen.convetStrToDb(this.getUndo_method())+"',"+
				"'"+commen.convetStrToDb(this.getUndo_out_query())+"',"+
				"'"+commen.convetStrToDb(this.getUndo_out_buffer())+"',"+
				"'"+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);
	}
}