java类型和mysql类型对应表
类型名称显示长度数据库类型JAVA类型JDBC类型索引(int)描述??????VARCHARL+NVARCHARjava.lang.String12?CHARNCHARjava.lang.String1?BLOBL+NBLOBjava.lang.byte[]-4?TEXT65535VARCHARjava.lang.String-1???????INTEGER4INTEGER UNSIGNEDjava.lang.Long4?TINYINT3TINYINT UNSIGNEDjava.lang.Integer-6?SMALLINT5SMALLINT UNSIGNEDjava.lang.Integer5?MEDIUMINT8MEDIUMINT UNSIGNEDjava.lang.Integer4?BIT1BITjava.lang.Boolean-7?BIGINT20BIGINT UNSIGNEDjava.math.BigInteger-5?FLOAT4+8FLOATjava.lang.Float7?DOUBLE22DOUBLEjava.lang.Double8?DECIMAL11DECIMALjava.math.BigDecimal3?BOOLEAN1同TINYINT?????????ID11PK (INTEGER UNSIGNED)java.lang.Long4???????DATE10DATEjava.sql.Date91?TIME8TIMEjava.sql.Time92?DATETIME19DATETIMEjava.sql.Timestamp93?TIMESTAMP19TIMESTAMPjava.sql.Timestamp93?YEAR4YEARjava.sql.Date91
