java-jdbc-mysql类型对应

MySQL数据类型	JAVA数据类型	JDBC TYPE
BIGINT	Long	BIGINT
TINYINT	Byte	TINYINT
SMALLINT	Short	SMALLINT
MEDIUMINT	Integer	INTEGER
INTEGER	Integer	INTEGER
INT	Integer	INTEGER
FLOAT	Float	REAL
DOUBLE	Double	DOUBLE
DECIMAL	BigDecimal	DECIMAL
NUMERIC	BigDecimal	DECIMAL
CHAR	String	CHAR
VARCHAR	String	VARCHAR
TINYBLOB	DataTypeWithBLOBs.byte[]	BINARY
TINYTEXT	String	VARCHAR
BLOB	DataTypeWithBLOBs.byte[]	BINARY
TEXT	DataTypeWithBLOBs.String	LONGVARCHAR
MEDIUMBLOB	DataTypeWithBLOBs.byte[]	LONGVARBINARY
MEDIUMTEXT	DataTypeWithBLOBs.String	LONGVARCHAR
LONGBLOB	DataTypeWithBLOBs.byte[]	LONGVARBINARY
LONGTEXT	DataTypeWithBLOBs.String	LONGVARCHAR
DATE	Date	DATE
TIME	Date	TIME
YEAR	Date	DATE
DATETIME	Date	TIMESTAMP
TIMESTAMP	Date	TIMESTAMP