參考地址：https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-type-conversions.html

Table?5.1?Connection Properties - Miscellaneous

?　　

?

Table?5.2?MySQL Types to Java Types for ResultSet.getObject()

MySQL Type NameReturn value of?GetColumnClassNameReturned as Java Class

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 of whether it is?UNSIGNED?or not)
MEDIUMINT[(M)] [UNSIGNED]	MEDIUMINT [UNSIGNED]	java.lang.Integer?(regardless of whether it is?UNSIGNED?or not)
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 totrue?(the default), then the returned object is 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

?

轉載于:https://www.cnblogs.com/luyang08/p/7273549.html

總結

以上是生活随笔為你收集整理的jdbc mysql数据类型对比 （版本： 5.1）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。