# Parameter Map和Result Map支持的数据类型
对于Parameter Map和Result Map,命名SQL支持的Java类型如下表所示:
Java Type | SDO property mapping | ResultClass/ParameterClass | Type Alias | Jdbc Type |
---|---|---|---|---|
boolean | YES | NO | boolean | BIT |
java.lang.Boolean | YES | YES | boolean | BIT |
byte | YES | NO | byte | TINYINT |
java.lang.Byte | YES | YES | byte | TINYINT |
short | YES | NO | short | SMALLINT |
java.lang.Short | YES | YES | short | SMALLINT |
int | YES | NO | int/integer | INTEGER |
java.lang.Integer | YES | YES | int/integer | INTEGER |
long | YES | NO | long | BIGINT |
java.lang.Long | YES | YES | long | BIGINT |
float | YES | NO | float | FLOAT |
java.lang.Float | YES | YES | float | FLOAT |
double | YES | NO | double | DOUBLE |
java.lang.Double | YES | YES | double | DOUBLE |
java.lang.String | YES | YES | string | VARCHAR |
java.util.Date | YES | YES | date | DATE |
java.math.BigDecimal | YES | YES | decimal | NUMERIC |
java.sql.Date | YES | YES | N/A | DATE |
java.sql.Time | YES | YES | N/A | TIME |
java.sql.Timestamp | YES | YES | N/A | TIMESTAMP |