javafieldtypes.java

J2EE eclipse 下开发数据库一个插件

package com.tanghan.db.util;

import java.sql.Types;
import com.tanghan.db.Field;
//import com.cmn.porpoise.wsad.plugin.wizard.element.*;
//import com.cmn.porpoise.util.DealString;

public class JavaFieldTypes {
	
	private JavaFieldTypes(){}

	
	public final static String BIT 		=  "boolean";
	public final static String TINYINT 	=  "short";
	public final static String SMALLINT	=   "short";
	public final static String INTEGER 	=   "int";
	public final static String BIGINT 		=  "long";
	public final static String LONG 		=  "long";
	public final static String FLOAT 		=  "double";
	public final static String REAL 		=  "float";
	public final static String DOUBLE 		=  "double";
	public final static String NUMERIC 	=   "java.math.BigDecimal";
	public final static String DECIMAL		=  "java.math.BigDecimal";
	public final static String CHAR		=  "String";
	public final static String VARCHAR 	=  "String";
	public final static String LONGVARCHAR 	=  "String";
	public final static String DATE 		=  "java.util.Date";
	public final static String TIME 		=  "java.util.Date";
	public final static String TIMESTAMP 	=  "java.util.Date";
	/**得到JDBC处理时的Set方法*/
/*	
	public static String getJDBCSetMethod(String rsmtName,PPClassSet classSet,PPFieldSet fieldSet,int order,boolean isCon,String conName){
		String javaType = DealString.trim(rsmtName) + ".";
		String param = classSet.getClassImplName()+"."+fieldSet.getGetMethodName()+"()";
		//是否为常量
		if(isCon)
			param = conName;
		switch(fieldSet.getField().getFieldType()){
			case Types.BIT:
				javaType += "setBoolean("+order+","+param+")"; 
				break;
			case Types.TINYINT:
				javaType += "setShort("+order+","+param+")"; 
				break;
			case Types.TIMESTAMP:
				javaType += "setTimestamp("+order+", new java.sql.Timestamp("+param+".getTime()))"; 
				break;
			case Types.TIME:
				javaType += "setTime("+order+", new java.sql.Time("+param+".getTime()))"; 
				break;
			case Types.DATE:
				javaType += "setDate("+order+", new java.sql.Date("+param+".getTime()))"; 
				break;
			case Types.LONGVARCHAR:
				javaType += "setString("+order+","+param+")"; 
				break;
			case Types.VARCHAR:
				javaType += "setString("+order+","+param+")"; 
				break;
			case Types.CHAR:
				javaType += "setString("+order+","+param+")"; 
				break;
			case Types.DECIMAL:
				javaType += "setBigDecimal("+order+","+param+")"; 
				break;
			case Types.NUMERIC:
				if(fieldSet.getField().getScale()>0)
					javaType += "setDouble("+order+","+param+")"; 
				else
					javaType += "setLong("+order+","+param+")"; 
				break;
			case Types.DOUBLE:
				javaType += "setDouble("+order+","+param+")"; 
				break;
			case Types.REAL:
				javaType += "setFloat("+order+","+param+")"; 
				break;
			case Types.FLOAT:
				javaType += "setFloat("+order+","+param+")"; 
				break;
			case Types.BIGINT:
				javaType += "setLong("+order+","+param+")"; 
				break;
			case Types.INTEGER:
				javaType += "setInt("+order+","+param+")"; 
				break;
			case Types.SMALLINT:
				javaType += "setShort("+order+","+param+")"; 
				break;
			default:
				javaType += "setString("+order+","+param+")"; 
				break;
		}
	
		return javaType;
	}
	*/
	
	/**得到JDBC处理时的Get方法*/
	/*
	public static String getJDBCGetMethod(String rsmtName,PPClassSet classSet,PPFieldSet fieldSet){
		String javaType = classSet.getClassImplName()+"."+fieldSet.getSetMethodName()+"(";
		String param = DealString.trim(rsmtName) + ".";
		switch(fieldSet.getField().getFieldType()){
			case Types.BIT:
				javaType += param+"getBoolean(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.TINYINT:
				javaType += param+"getShort(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.TIMESTAMP:
				javaType += "new java.util.Date("+ param+"getTimestamp(\""+fieldSet.getField().getFieldName()+"\").getTime()))"; 
				break;
			case Types.TIME:
				javaType += "new java.util.Date("+ param+"getTime(\""+fieldSet.getField().getFieldName()+"\").getTime()))"; 
				break;
			case Types.DATE:
				javaType += "new java.util.Date("+ param+"getDate(\""+fieldSet.getField().getFieldName()+"\").getTime()))"; 
				break;
			case Types.LONGVARCHAR:
				javaType += "DealString.trim(" +param+"getString(\""+fieldSet.getField().getFieldName()+"\")))"; 
				break;
			case Types.VARCHAR:
				javaType += "DealString.trim(" +param+"getString(\""+fieldSet.getField().getFieldName()+"\")))"; 
				break;
			case Types.CHAR:
				javaType += "DealString.trim(" +param+"getString(\""+fieldSet.getField().getFieldName()+"\")))"; 
				break;
			case Types.DECIMAL:
				javaType += param+"getBigDecimal(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.NUMERIC:
				if(fieldSet.getField().getScale()>0)
					javaType += param+"getDouble(\""+fieldSet.getField().getFieldName()+"\"))"; 
				else
					javaType += param+"getLong(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.DOUBLE:
				javaType += param+"getDouble(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.REAL:
				javaType += param+"getFloat(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.FLOAT:
				javaType += param+"getFloat(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.BIGINT:
				javaType += param+"getLong(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.INTEGER:
				javaType += param+"getInt(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			case Types.SMALLINT:
				javaType += param+"getShort(\""+fieldSet.getField().getFieldName()+"\"))"; 
				break;
			default:
				javaType += "DealString.trim(" +param+"getString(\""+fieldSet.getField().getFieldName()+"\")))"; 
				break;
		}
	
		return javaType;
	}
	
	*/
	
	/**生成默认值*/
	/*
	public static String getJavaDefaultValue(String fieldName,Field field){
		String javaType = " " + fieldName + " = ";
		switch(field.getFieldType()){
			case Types.BIT:
				javaType += "false"; 
				break;
			case Types.TINYINT:
				javaType += "0"; 
				break;
			case Types.TIMESTAMP:
				javaType += "new java.util.Date()"; 
				break;
			case Types.TIME:
				javaType += "new java.util.Date()"; 
				break;
			case Types.DATE:
				javaType += "new java.util.Date()"; 
				break;
			case Types.LONGVARCHAR:
				javaType += "\"\""; 
				break;
			case Types.VARCHAR:
				javaType += "\"\""; 
				break;
			case Types.CHAR:
				javaType += "\"\""; 
				break;
			case Types.DECIMAL:
				javaType += "new java.math.BigDecimal(0.0)"; 
				break;
			case Types.NUMERIC:
				if(field.getScale()>0)
					javaType += " 0.0"; 
				else
					javaType += "0"; 
				break;
			case Types.DOUBLE:
				javaType += "0"; 
				break;
			case Types.REAL:
				javaType += "0"; 
				break;
			case Types.FLOAT:
				javaType += "0"; 
				break;
			case Types.BIGINT:
				javaType += "0"; 
				break;
			case Types.INTEGER:
				javaType += "0"; 
				break;
			case Types.SMALLINT:
				javaType += "0"; 
				break;
			default:
				javaType = "\"\"";
				break;
		}
	
		return javaType;
	}
	/*
	/**得到相对应的Java类型*/
	public static String getJavaType(Field field){
		String javaType = "String";
		switch(field.getFieldType()){
			case Types.BIT:
				javaType = BIT; 
				break;
			case Types.TINYINT:
				javaType = TINYINT; 
				break;
			case Types.TIMESTAMP:
				javaType = TIMESTAMP; 
				break;
			case Types.TIME:
				javaType = TIME; 
				break;
			case Types.DATE:
				javaType = DATE; 
				break;
			case Types.LONGVARCHAR:
				javaType = LONGVARCHAR; 
				break;
			case Types.VARCHAR:
				javaType = VARCHAR; 
				break;
			case Types.CHAR:
				javaType = CHAR; 
				break;
			case Types.DECIMAL:
				javaType = DECIMAL; 
				break;
			case Types.NUMERIC:
				if(field.getScale()>0)
					javaType = FLOAT; 
				else
					javaType = LONG; 
				break;
			case Types.DOUBLE:
				javaType = DOUBLE; 
				break;
			case Types.REAL:
				javaType = REAL; 
				break;
			case Types.FLOAT:
				javaType = FLOAT; 
				break;
			case Types.BIGINT:
				javaType = BIGINT; 
				break;
			case Types.INTEGER:
				javaType = INTEGER; 
				break;
			case Types.SMALLINT:
				javaType = SMALLINT; 
				break;
			default:
				javaType = "String";
				break;
		}
	
		return javaType;
	}
	
}