📄 javafieldtypes.java
字号:
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; } }
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -