mysql与java属性对应表.doc

1、类型名称显示长度数据库类型JAVA 类型JDBC 类型索引 (int)描述VARCHARL+NVARCHARjava.lang.String12CHARNCHARjava.lang.String1BLOBL+NBLOBjava.lang.byte-4TEXT65535VARCHARjava.lang.String-1INTEGER4INTEGER UNSIGNEDjava.lang.Long4TINYINT3TINYINT UNSIGNEDjava.lang.Integer-6SMALLINT5SMALLINT UNSIGNEDjava.lang.Integer5MEDIUMINT8MEDIU

2、MINT UNSIGNEDjava.lang.Integer4BIT1BITjava.lang.Boolean-7BIGINT20BIGINT UNSIGNEDjava.math.BigInteger-5FLOAT4+8FLOATjava.lang.Float7DOUBLE22DOUBLEjava.lang.Double8DECIMAL11DECIMALjava.math.BigDecimal3BOOLEAN1同 TINYINTID11PK (INTEGER UNSIGNED)java.lang.Long4DATE10DATEjava.sql.Date91TIME8TIMEjava.sql.T

3、ime92DATETIME19DATETIMEjava.sql.Timestamp93TIMESTAMP19TIMESTAMPjava.sql.Timestamp93YEAR4YEARjava.sql.Date91以上就是 Java数据类型和 MySql数据类型对应表对于 bolb ，一般用于对图片的数据库存储，原理是把图片打成二进制，然后进行的一种存储方式，在 java 中对应 byte 数组。对于 boolen 类型，在 mysql 数据库中，个人认为用 int 类型代替较好，对 bit 操作不是很方便，尤其是在具有 web 页面开发的项目中，表示 0/1 ，对应 java 类型的 Int

4、eger 较好。BIT(1) (new in MySQL-5.0) BITjava.lang.BooleanBIT( 1) (new inBITbyteMySQL-5.0)java.lang.Boolean if the configuration propertyTINYINTTINYINTtinyInt1isBitis set to true (the default) and thestorage size is 1, orjava.lang.Integerif not.BOOL, BOOLEANTINYINTSee TINYINT, above as these are aliases

5、 for TINYINT(1),SMALLINT(M)SMALLINTUNSIGNEDUNSIGNEDMEDIUMINT(M)MEDIUMINTUNSIGNEDUNSIGNEDINT,INTEGER(M)INTEGERUNSIGNEDUNSIGNEDBIGINT(M) UNSIGNEDBIGINTUNSIGNEDFLOAT(M,D)FLOATDOUBLE(M,B)DOUBLEDECIMAL(M,D)DECIMALDATEDATEDATETIMEDATETIMETIMESTAMP(M)TIMESTAMPTIMETIMEYEAR(2|4)YEARCHAR(M)CHARVARCHAR(M) BINA

6、RYVARCHARBINARY(M)BINARYVARBINARY(M)VARBINARYTINYBLOBTINYBLOBTINYTEXTVARCHARBLOBBLOBTEXTVARCHARMEDIUMBLOBMEDIUMBLOBMEDIUMTEXT学习使人进步VARCHARcurrently.java.lang.Integer(regardless if UNSIGNED or not)java.lang.Integer,if UNSIGNEDjava.lang.Long(C/J 3.1 and earlier), orjava.lang.Integerfor C/J 5.0 and lat

7、erjava.lang.Integer, if UNSIGNEDjava.lang.Longjava.lang.Long, if UNSIGNEDjava.math.BigIntegerjava.lang.Floatjava.lang.Doublejava.math.BigDecimaljava.sql.Datejava.sql.Timestampjava.sql.Timestampjava.sql.TimeIf yearIsDateTypeconfiguration property is set tofalse, then the returned object type isjava.s

8、ql.Short.If set to true (the default) then an object of typejava.sql.Date(with the date set to January 1st, atmidnight).java.lang.String(unless the character set for thecolumn is BINARY, thenbyteis returned.java.lang.String(unless the character set for thecolumn is BINARY, thenbyteis returned.bytebytebytejava.lang.Stringbytejava.lang.Stringbytejava.lang.StringLON