jrutility.java

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

package com.jr81.source.common;

public class JrUtility {
	public static int JavaTypeToDataType(int value){
		int Result=TcuDataType.String;
		if (value == 0) { //NULL to Unknown
		    Result = TcuDataType.Unknown;  //0
		    return Result;
		  } else if (value == 12) { // Varchar to String
		    Result = TcuDataType.String;  //1
		    return Result;
		  } else if (value == -7) { // Bit to Boolean
		    Result = TcuDataType.Boolean; //5
		    return Result;
		  } else if (value == -6) { // TINYINT to Smallint
		    Result = TcuDataType.Integer; //2
		    return Result;
		  } else if (value == 5) { // SMALLINT to Smallint
		    Result = TcuDataType.Integer; //2
		    return Result;
		  } else if (value == 4) { // INTEGER to INTEGER
		    Result = TcuDataType.Integer; //3
		    return Result;
		  } else if (value == -5) { // BIGINT to ftLargeint
		    Result = TcuDataType.Integer; //24
		    return Result;
		  } else if (value == 6) { // FLOAT to ftFloat
		    Result = TcuDataType.Float; //6
		    return Result;
		  } else if (value == 7) { // REAL to ftFloat
		    Result = TcuDataType.Float; //6
		    return Result;
		  } else if (value == 8) { // DOUBLE to ftFloat
		    Result = TcuDataType.Float; //6
		    return Result;
		  } else if (value == 2) { // NUMERIC to ftFloat
		    Result = TcuDataType.Float; //6
		    return Result;
		  } else if (value == 3) { // DECIMAL to ftFloat
		    Result = TcuDataType.Float; //6
		    return Result;
		  } else if (value == 1) { // CHAR to TcuDataType.String
		    Result = TcuDataType.String; //1
		    return Result;
		  } else if (value == -1) { // LONGVARCHAR to ftMemo
		    Result = TcuDataType.Text; //16
		    return Result;
		  } else if (value == 91) { // DATE to ftDate
		    //Result = ftDate; //9
		    Result = TcuDataType.DateTime; //11
		    return Result;
		  } else if (value == 92) { // TIME to ftTime
		    Result = TcuDataType.DateTime; //10
		    return Result;
		  } else if (value == 93) { // TIMESTAMP to ftTimeStamp
		    Result = TcuDataType.DateTime; //36
		    return Result;
		  } else if (value == -2) { // BINARY to ftBlob
		    Result = TcuDataType.ByteArray; //15
		    return Result;
		  } else if (value == -3) { // VARBINARY to ftBlob
		    Result = TcuDataType.ByteArray; //15
		    return Result;
		  } else if (value == -4) { // LONGVARBINARY to ftBlob
		    Result = TcuDataType.ByteArray; //15
		    return Result;
		  } else if (value == 1111) { // OTHER to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 2000) { // JAVA_OBJECT to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 2001) { // DISTINCT to ftAutoInc
		    Result = TcuDataType.AutoInc; //14
		    return Result;
		  } else if (value == 2002) { // STRUCT to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 2003) { // ARRAY to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 2004) { // BLOB to ftBlob
		    Result = TcuDataType.ByteArray; //15
		    return Result;
		  } else if (value == 2005) { // CLOB to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 2006) { // REF to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 70) { // DATALINK to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else if (value == 16) { // BOOLEAN to TcuDataType.Unknown
		    Result = TcuDataType.Unknown; //0
		    return Result;
		  } else {
		    Result = TcuDataType.String; //1
		    return Result;
		  }
	};
}