mysql decimal(10,2)对应java类型

下面我给出MYSQL类型与JAVA类型对应表,希望能够帮到您:

类型名称显示长度数据库类型JAVA类型JDBC类型索引(int)VARCHARL+NVARCHARjava.lang.String12CHARNCHARjava.lang.String1BLOBL+NBLOBjava.lang.byte[]-4TEXT65535VARCHARjava.lang.String-1     INTEGER4INTEGER UNSIGNEDjava.lang.Long4TINYINT3TINYINT UNSIGNEDjava.lang.Integer-6SMALLINT5SMALLINT UNSIGNEDjava.lang.Integer5MEDIUMINT8MEDIUMINT UNSIGNEDjava.lang.Integer4BIT1BITjava.lang.Boolean-7BIGINT20BIGINT UNSIGNEDjava.math.BigInteger-5FLOAT4+8FLOATjava.lang.Float7DOUBLE22DOUBLEjava.lang.Double8DECIMAL11DECIMALjava.math.BigDecimal3BOOLEAN1同TINYINT       ID11PK (INTEGER UNSIGNED)java.lang.Long4     DATE10DATEjava.sql.Date91TIME8TIMEjava.sql.Time92DATETIME19DATETIMEjava.sql.Timestamp93TIMESTAMP19TIMESTAMPjava.sql.Timestamp93YEAR4YEARjava.sql.Date91

文章出处

转载于:https://www.cnblogs.com/yanduanduan/p/7606453.html

相关资源：垃圾分类数据集及代码