JAVA数据类型与MySQL数据类型对照

 MySQL数据类型：Java数据类型：VARCHARStringCHARStringBLOBbyte[]VARCHARStringINTEGER UNSIGNEDLongTINYINT UNSIGNEDIntegerSMALLINT UNSIGNEDIntegerMEDIUMINT UNSIGNEDIntegerBITBooleanBIGINT UNSIGNEDBigIntegerFLOATFloatDOUBLEDoubleDECIMALBigDecimalPK (INTEGER UNSIGNED)LongDATEDateTIMETimeDATETIMETimestampTIMESTAMPTimestampYEARDate