Mysql转Java类型

能在MySQL和Java之间转换的类型

以下MySQL数据类型	总能转换为以下Java类型
CHAR, VARCHAR, BLOB, TEXT, ENUM, and SET	java.lang.String, java.io.InputStream, java.io.Reader, java.sql.Blob, java.sql.Clob
FLOAT, REAL, DOUBLE PRECISION, NUMERIC, DECIMAL, TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT	java.lang.String, java.lang.Short, java.lang.Integer, java.lang.Long, java.lang.Double, java.math.BigDecimal
DATE, TIME, DATETIME, TIMESTAMP	java.lang.String, java.sql.Date, java.sql.Timestamp

MySQL类型、列的类型名称、列的类名称

MySQL类型名称	列的类型名称	列的类名称
BIT(1)	BIT	java.lang.Boolean
BIT( > 1)	BIT	byte[]
TINYINT(1) SIGNED, BOOLEAN	If tinyInt1isBit=true and transformedBitIsBoolean=false : BIT, If tinyInt1isBit=true and transformedBitIsBoolean=true : BOOLEAN, If tinyInt1isBit=false: TINYINT	If tinyInt1isBit=true and transformedBitIsBoolean=false : java.lang.Boolean, If tinyInt1isBit=true and transformedBitIsBoolean=true : java.lang.Boolean, If 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)](MySQL 8.0.17版本开始弃用，建议使用DECIMAL)	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
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