Java數據類型和MySql數據類型對應一覽 [轉]。本站提示廣大學習愛好者:(Java數據類型和MySql數據類型對應一覽 [轉])文章只能為提供參考,不一定能成為您想要的結果。以下是Java數據類型和MySql數據類型對應一覽 [轉]正文
以上就是Java數據類型和MySQL數據類型對應表。
關於bolb,普通用於對圖片的數據庫存儲,原理是把圖片打成二進制,然後停止的一種存儲方式,在java中對應byte[]數組。
關於boolen類型,在mysql數據庫中,團體以為用int類型替代較好,對bit操作不是很方便,尤其是在具有web頁面開發的項目中,表示0/1,對應java類型的Integer較好。
BIT(1) (new in MySQL-5.0) BIT
java.lang.Boolean
BIT( > 1) (new in MySQL-5.0)
BIT
byte[]
TINYINT
TINYINT
java.lang.Boolean
if the configuration property tinyInt1isBit
is set to true
(the default) and the storage size is 1, or java.lang.Integer
if not.
BOOL, BOOLEAN
TINYINT
See TINYINT, above as these are aliases for TINYINT(1), currently.
SMALLINT[(M)] [UNSIGNED]
SMALLINT [UNSIGNED]
java.lang.Integer
(regardless if UNSIGNED or not)
MEDIUMINT[(M)] [UNSIGNED]
MEDIUMINT [UNSIGNED]
java.lang.Integer,
if UNSIGNED java.lang.Long
(C/J 3.1 and earlier), or java.lang.Integer
for C/J 5.0 and later
INT,INTEGER[(M)] [UNSIGNED]
INTEGER [UNSIGNED]
java.lang.Integer
, if UNSIGNED java.lang.Long
BIGINT[(M)] [UNSIGNED]
BIGINT [UNSIGNED]
java.lang.Long
, if UNSIGNED java.math.BigInteger
FLOAT[(M,D)]
FLOAT
java.lang.Float
DOUBLE[(M,B)]
DOUBLE
java.lang.Double
DECIMAL[(M[,D])]
DECIMAL
java.math.BigDecimal
DATE
DATE
java.sql.Date
DATETIME
DATETIME
java.sql.Timestamp
TIMESTAMP[(M)]
TIMESTAMP
java.sql.Timestamp
TIME
TIME
java.sql.Time
YEAR[(2|4)]
YEAR
If yearIsDateType
configuration property is set to false, then the returned object type is java.sql.Short
. If set to true (the default) then an object of type java.sql.Date
(with the date set to January 1st, at midnight).
CHAR(M)
CHAR
java.lang.String
(unless the character set for the column is BINARY, then byte[]
is returned.
VARCHAR(M) [BINARY]
VARCHAR
java.lang.String
(unless the character set for the column is BINARY, then byte[]
is returned.
BINARY(M)
BINARY
byte[]
VARBINARY(M)
VARBINARY
byte[]
TINYBLOB
TINYBLOB
byte[]
TINYTEXT
VARCHAR
java.lang.String
BLOB
BLOB
byte[]
TEXT
VARCHAR
java.lang.String
MEDIUMBLOB
MEDIUMBLOB
byte[]
MEDIUMTEXT
VARCHAR
java.lang.String
LONGBLOB
LONGBLOB
byte[]
LONGTEXT
VARCHAR
java.lang.String
ENUM('value1','value2',...)
CHAR
java.lang.String
SET('value1','value2',...)
CHAR
java.lang.String