MySQL Type Name | Return value of GetColumnTypeName | Return value of GetColumnClassName |
---|---|---|
BIT(1) | BIT | java.lang.Boolean |
BIT( > 1) | BIT | byte[] |
TINYINT(1) SIGNED, BOOLEAN | 如果tinyInt1isBit=true 和transformedBitIsBoolean=false : BIT 如果 tinyInt1isBit=true 和transformedBitIsBoolean=true : BOOLEAN 如果 tinyInt1isBit=false : TINYINT | 如果tinyInt1isBit=true 和transformedBitIsBoolean=false : java.lang.Boolean 如果 tinyInt1isBit=true 和transformedBitIsBoolean=true : java.lang.Boolean 如果 tinyInt1isBit=false : java.lang.Integer |
TINYINT( > 1) SIGNED | TINYINT | java.lang.Integer |
TINYINT( any ) UNSIGNED | TINYINT UNSIGNED | java.lang.Integer |
SMALLINT[(M)] [UNSIGNED] | SMALLINT [UNSIGNED] | java.lang.Integer (不管它是否UNSIGNED ) |
MEDIUMINT[(M)] [UNSIGNED] | MEDIUMINT [UNSIGNED] | java.lang.Integer (不管它是否UNSIGNED ) |
INT,INTEGER[(M)] | INTEGER | java.lang.Integer |
INT,INTEGER[(M)] UNSIGNED | INTEGER UNSIGNED | java.lang.Long |
BIGINT[(M)] | BIGINT | java.lang.Long |
BIGINT[(M)] UNSIGNED | BIGINT UNSIGNED | java.math.BigInteger |
FLOAT[(M,D)] | FLOAT | java.lang.Float |
DOUBLE[(M,B)] [UNSIGNED] | DOUBLE | java.lang.Double (不管它是否UNSIGNED ) |
DECIMAL[(M[,D])] [UNSIGNED] | DECIMAL | java.math.BigDecimal (不管它是否UNSIGNED ) |
DATE | DATE | java.sql.Date |
DATETIME | DATETIME | java.time.LocalDateTime |
TIMESTAMP[(M)] | TIMESTAMP | java.sql.Timestamp |
TIME | TIME | java.sql.Time |
YEAR[(2|4)] | YEAR | 如果yearIsDateType 为false , 则返回对象类型是java.sql.Short 。如果为 true (默认), 则返回对象类型是java.sql.Date 。 |
CHAR(M) | CHAR | java.lang.String |
VARCHAR(M) | VARCHAR | java.lang.String |
BINARY(M) , CHAR(M) BINARY | BINARY | byte[] |
VARBINARY(M) , VARCHAR(M) BINARY | VARBINARY | byte[] |
BLOB | BLOB | byte[] |
TINYBLOB | TINYBLOB | byte[] |
MEDIUMBLOB | MEDIUMBLOB | byte[] |
LONGBLOB | LONGBLOB | byte[] |
TEXT | TEXT | java.lang.String |
TINYTEXT | TINYTEXT | java.lang.String |
MEDIUMTEXT | MEDIUMTEXT | java.lang.String |
LONGTEXT | LONGTEXT | java.lang.String |
JSON | JSON | java.lang.String |
GEOMETRY | GEOMETRY | byte[] |
ENUM('value1','value2',...) | CHAR | java.lang.String |
SET('value1','value2',...) | CHAR | java.lang.String |
原创文章,作者:huoxiaoqiang,如若转载,请注明出处:https://www.huoxiaoqiang.com/basic/mysql/17131.html