| 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
微信扫一扫 
支付宝扫一扫