FieldType (com.centit.support:centit-database 5.4.240119 API)

java.lang.Object
- com.centit.support.database.utils.FieldType

public abstract class FieldType
extends Object

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`BOOLEAN`
`static String`	`BYTE_ARRAY`
`static String`	`BYTE_STREAM`
`static String`	`DATE`
`static String`	`DATETIME`
`static String`	`DOUBLE`
`static String`	`ENUM_NAME`
`static String`	`FILE`
`static String`	`FILE_ID`
`static String`	`FLOAT`
`static String`	`IDENTITY` 这个是 Sql Server 和 MySql 特有的自增id类型，起始值和增加幅度（这个一旦确定不好修改，默认1，1); 并且这个字段必须是主键；目前还没有实现
`static String`	`INTEGER`
`static String`	`JSON_OBJECT`
`static String`	`LONG`
`static String`	`MONEY` 要考虑定点数，用于存储金钱
`static String`	`OBJECT_LIST`
`static String`	`STRING`
`static String`	`TEXT`
`static String`	`TEXT_STREAM`
`static String`	`TIMESTAMP`
`static String`	`VOID`

Constructor Summary

Constructors
Constructor and Description

FieldType()

Constructors
Constructor and Description
`FieldType()`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static Map<String,String>`	`getAllTypeMap()`
`static String`	`humpNameToColumn(String humpName, boolean upCase)`
`static String`	`mapClassName(String columnName)`
`static String`	`mapPropName(String columnName)`
`static String`	`mapToDatabaseType(String ft, DBType dt)`
`static String`	`mapToDB2ColumnType(String ft)` 转换到Oracle的字段
`static String`	`mapToFieldType(Class<?> javaType)`
`static String`	`mapToFieldType(int dbType)`
`static String`	`mapToFieldType(String columnType)`
`static String`	`mapToFieldType(String columnType, int scale)`
`static String`	`mapToGBaseColumnType(String ft)`
`static String`	`mapToH2ColumnType(String ft)`
`static String`	`mapToHumpName(String columnName, boolean firstUpCase, boolean ignoreSingleCharPrefix)`
`static Class<?>`	`mapToJavaType(int dbType)` map java.sql.Type to javaType
`static Class<?>`	`mapToJavaType(String columnType)`
`static Class<?>`	`mapToJavaType(String columnType, int scale)`
`static String`	`mapToMySqlColumnType(String ft)` 转换到Oracle的字段
`static String`	`mapToOracleColumnType(String ft)` 转换到Oracle的字段
`static String`	`mapToPostgreSqlColumnType(String ft)`
`static String`	`mapToSqlServerColumnType(String ft)` 转换到Oracle的字段
`static String`	`trimType(String st)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail
- VOID
```
public static final String VOID
```
  See Also:
  
  Constant Field Values
- IDENTITY
```
public static final String IDENTITY
```
  这个是 Sql Server 和 MySql 特有的自增id类型，起始值和增加幅度（这个一旦确定不好修改，默认1，1); 并且这个字段必须是主键；目前还没有实现
  
  See Also:
  
  Constant Field Values
- STRING
```
public static final String STRING
```
  See Also:
  
  Constant Field Values
- INTEGER
```
public static final String INTEGER
```
  See Also:
  
  Constant Field Values
- FLOAT
```
public static final String FLOAT
```
  See Also:
  
  Constant Field Values
- MONEY
```
public static final String MONEY
```
  要考虑定点数，用于存储金钱
  
  See Also:
  
  Constant Field Values
- DOUBLE
```
public static final String DOUBLE
```
  See Also:
  
  Constant Field Values
- LONG
```
public static final String LONG
```
  See Also:
  
  Constant Field Values
- BOOLEAN
```
public static final String BOOLEAN
```
  See Also:
  
  Constant Field Values
- DATE
```
public static final String DATE
```
  See Also:
  
  Constant Field Values
- DATETIME
```
public static final String DATETIME
```
  See Also:
  
  Constant Field Values
- TIMESTAMP
```
public static final String TIMESTAMP
```
  See Also:
  
  Constant Field Values
- FILE_ID
```
public static final String FILE_ID
```
  See Also:
  
  Constant Field Values
- ENUM_NAME
```
public static final String ENUM_NAME
```
  See Also:
  
  Constant Field Values
- TEXT
```
public static final String TEXT
```
  See Also:
  
  Constant Field Values
- BYTE_ARRAY
```
public static final String BYTE_ARRAY
```
  See Also:
  
  Constant Field Values
- BYTE_STREAM
```
public static final String BYTE_STREAM
```
  See Also:
  
  Constant Field Values
- TEXT_STREAM
```
public static final String TEXT_STREAM
```
  See Also:
  
  Constant Field Values
- FILE
```
public static final String FILE
```
  See Also:
  
  Constant Field Values
- JSON_OBJECT
```
public static final String JSON_OBJECT
```
  See Also:
  
  Constant Field Values
- OBJECT_LIST
```
public static final String OBJECT_LIST
```
  See Also:
  
  Constant Field Values

Constructor Detail
- FieldType
```
public FieldType()
```

Method Detail

trimType
```
public static String trimType(String st)
```
Parameters:

st - java类名称

Returns:

java类短名

mapClassName
```
public static String mapClassName(String columnName)
```
Parameters:

columnName - 数据库中的名称（代码）

Returns:

大驼峰名称

mapToHumpName

public static String mapToHumpName(String columnName,
                                   boolean firstUpCase,
                                   boolean ignoreSingleCharPrefix)

Parameters:: columnName - 字段名字符串，; firstUpCase - 驼峰属性名; ignoreSingleCharPrefix - 单字母_ 前缀忽略
Returns:: 返回驼峰字母

humpNameToColumn

public static String humpNameToColumn(String humpName,
                                      boolean upCase)

mapPropName
```
public static String mapPropName(String columnName)
```
Parameters:

columnName - 数据库中的名称（代码）

Returns:

小驼峰名称

mapToOracleColumnType
```
public static String mapToOracleColumnType(String ft)
```
转换到Oracle的字段

Parameters:

ft - String

Returns:

String

mapToGBaseColumnType

public static String mapToGBaseColumnType(String ft)

mapToSqlServerColumnType
```
public static String mapToSqlServerColumnType(String ft)
```
转换到Oracle的字段

Parameters:

ft - String

Returns:

String

mapToDB2ColumnType
```
public static String mapToDB2ColumnType(String ft)
```
转换到Oracle的字段

Parameters:

ft - String

Returns:

String

mapToMySqlColumnType
```
public static String mapToMySqlColumnType(String ft)
```
转换到Oracle的字段

Parameters:

ft - String

Returns:

String

mapToH2ColumnType

public static String mapToH2ColumnType(String ft)

mapToPostgreSqlColumnType

public static String mapToPostgreSqlColumnType(String ft)

mapToDatabaseType

public static String mapToDatabaseType(String ft,
                                       DBType dt)

Parameters:: dt - 数据库类别; ft - 字段 java 类别
Returns:: String

getAllTypeMap

public static Map<String,String> getAllTypeMap()

mapToJavaType

public static Class<?> mapToJavaType(String columnType,
                                     int scale)

mapToJavaType

public static Class<?> mapToJavaType(String columnType)

mapToJavaType
```
public static Class<?> mapToJavaType(int dbType)
```
map java.sql.Type to javaType

Parameters:

dbType - java.sql.Type

Returns:

java type

See Also:

Types

mapToFieldType

public static String mapToFieldType(int dbType)

mapToFieldType

public static String mapToFieldType(String columnType,
                                    int scale)

mapToFieldType

public static String mapToFieldType(String columnType)

mapToFieldType

public static String mapToFieldType(Class<?> javaType)

Class FieldType

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

VOID

IDENTITY

STRING

INTEGER

FLOAT

MONEY

DOUBLE

LONG

BOOLEAN

DATE

DATETIME

TIMESTAMP

FILE_ID

ENUM_NAME

TEXT

BYTE_ARRAY

BYTE_STREAM

TEXT_STREAM

FILE

JSON_OBJECT

OBJECT_LIST

Constructor Detail

FieldType

Method Detail

trimType

mapClassName

mapToHumpName

humpNameToColumn

mapPropName

mapToOracleColumnType

mapToGBaseColumnType

mapToSqlServerColumnType

mapToDB2ColumnType

mapToMySqlColumnType

mapToH2ColumnType

mapToPostgreSqlColumnType

mapToDatabaseType

getAllTypeMap

mapToJavaType

mapToJavaType

mapToJavaType

mapToFieldType

mapToFieldType

mapToFieldType

mapToFieldType