类型名称显示长度数据库类型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