mysql與java屬性對應(yīng)表.doc

1、類型名稱顯示長度數(shù)據(jù)庫類型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數(shù)據(jù)類型和 MySql數(shù)據(jù)類型對應(yīng)表對于 bolb ，一般用于對圖片的數(shù)據(jù)庫存儲，原理是把圖片打成二進(jìn)制，然后進(jìn)行的一種存儲方式，在 java 中對應(yīng) byte 數(shù)組。對于 boolen 類型，在 mysql 數(shù)據(jù)庫中，個人認(rèn)為用 int 類型代替較好，對 bit 操作不是很方便，尤其是在具有 web 頁面開發(fā)的項目中，表示 0/1 ，對應(yīng) 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學(xué)習(xí)使人進(jìn)步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