tcusqlparts.java

为公司做的质量考核接口源码,用spring,hibernate,XML实现,对XML接口编程很有帮助

/**
 * 
 */
package com.jr81.source.sql;

import java.io.InputStream;

import com.jr81.source.common.TcuDataType;
import com.jr81.source.stream.TcuBaseClassSTR;
import com.jr81.source.stream.TcuListClassSTR;



/**
 * @author Sanlen
 *
 */
public class TcuSQLParts extends TcuListClassSTR {

	/**
	 * @param packname
	 */
	public TcuSQLParts() {
		super("SQLItems");
		// TODO 自动生成构造函数存根
	}
	
	public TcuBaseClassSTR ItemFromStream(InputStream value) throws Exception{
		TcuSQLPart Item=new TcuSQLPart();
		Item.LoadFromStream(value);
		return Item;	
	}	
	
	public TcuSQLPart ItemByID(int index){
		TcuSQLPart Item=(TcuSQLPart) GetItem(index);
		return Item;
	}
	
	public void Add(String FieldName,byte[] FieldValue,int DataType,int Operator,int JoinType){
		TcuSQLPart Item=new TcuSQLPart();
		Item.setFieldName(FieldName);
		Item.setFieldValue(FieldValue);
		Item.setDataType(Integer.valueOf(DataType));
		Item.setJoinType(Integer.valueOf(JoinType));
		Item.setOperator(Integer.valueOf(Operator));
		AddItem(Item);
	}

	///添加Byte数组类型--------------------------------------------------------------------
	public void Add(String FieldName,byte[] FieldValue){
		Add(FieldName,FieldValue,TcuDataType.ByteArray,TcuOperator.Equals,TcuJoinType.And);
	}
	
	public void Add(String FieldName,byte[] FieldValue,int DataType){
		Add(FieldName,FieldValue,DataType,TcuOperator.Equals,TcuJoinType.And);
	}
	
	public void Add(String FieldName,byte[] FieldValue,int DataType,int Operator){
		Add(FieldName,FieldValue,DataType,Operator,TcuJoinType.And);
	}
		
	//public void Add(String FieldName,byte[] FieldValue,int DataType,int Operator,int JoinType){
	//	Add(FieldName,FieldValue,TcuDataType.ByteArray,Operator,JoinType);
	//}
	
	///添加String类型-----------------------------------------------------------------
	public void Add(String FieldValue){
		Add("ProcParam",FieldValue.getBytes(),TcuDataType.String,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,String FieldValue){
		Add(FieldName,FieldValue.getBytes(),TcuDataType.String,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,String FieldValue,int Operator){
		Add(FieldName,FieldValue.getBytes(),TcuDataType.String,Operator);
	}
	
	public void Add(String FieldName,String FieldValue,int Operator,int JoinType){
		Add(FieldName,FieldValue.getBytes(),TcuDataType.String,Operator,JoinType);
	}
	
	//Add int type item--------------------------------------------------------------
	public void Add(int FieldValue){
		Add("ProcParam",String.valueOf(FieldValue).getBytes(),TcuDataType.Integer,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,int FieldValue){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Integer,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,int FieldValue,int Operator){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Integer,Operator);
	}
	
	public void Add(String FieldName,int FieldValue,int Operator,int JoinType){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Integer,Operator,JoinType);
	}
	//Add float type item---------------------------------------------------------------
	public void Add(float FieldValue){
		Add("ProcParam",String.valueOf(FieldValue).getBytes(),TcuDataType.Float,TcuOperator.Equals);
	}
		
	public void Add(String FieldName,float FieldValue){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Float,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,float FieldValue,int Operator){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Float,Operator);
	}
	
	public void Add(String FieldName,float FieldValue,int Operator,int JoinType){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Float,Operator,JoinType);
	}
	
	//Add boolean type item---------------------------------------------------------------
	public void Add(boolean FieldValue){
		Add("ProcParam",String.valueOf(FieldValue).getBytes(),TcuDataType.Boolean,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,boolean FieldValue){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Boolean,TcuOperator.Equals);
	}
	
	public void Add(String FieldName,boolean FieldValue,int Operator){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Boolean,Operator);
	}
	
	public void Add(String FieldName,boolean FieldValue,int Operator,int JoinType){
		Add(FieldName,String.valueOf(FieldValue).getBytes(),TcuDataType.Boolean,Operator,JoinType);
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根

	}

}