官方文档链接： http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html Mysql官方文档上写 的 Mysql数据类型与Java数据类型的对应关系 。有疑问的细节，看官方文档~~ Table20.25.MySQLTypestoJavaTypesforResultSet.getObjec
官方文档链接：
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html
Mysql官方文档上写的Mysql数据类型与Java数据类型的对应关系。有疑问的细节，看官方文档~~
Table 20.25. MySQL Types to Java Types for ResultSet.getObject()
|
MySQL Type Name |
Return value ofGetColumnClassName 立即学习“Java免费学习笔记（深入）”； |
Returned 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, orjava.lang.Integer if not. |
|
BOOL, BOOLEAN |
TINYINT |
See TINYINT, above as these are aliases forTINYINT(1), currently. |
|
SMALLINT[(M)] [UNSIGNED] |
SMALLINT [UNSIGNED] |
java.lang.Integer (regardless ifUNSIGNED or not) |
|
MEDIUMINT[(M)] [UNSIGNED] |
MEDIUMINT [UNSIGNED] |
java.lang.Integer, if UNSIGNEDjava.lang.Long (C/J 3.1 and earlier), orjava.lang.Integer for C/J 5.0 and later |
|
INT,INTEGER[(M)] [UNSIGNED] |
INTEGER [UNSIGNED] |
java.lang.Integer, if UNSIGNEDjava.lang.Long |
|
BIGINT[(M)] [UNSIGNED] |
BIGINT [UNSIGNED] |
java.lang.Long, if UNSIGNEDjava.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 
瑞宝通JAVA版B2B电子商务系统
下载
瑞宝通B2B系统使用当前流行的JAVA语言开发，以MySQL为数据库，采用B/S J2EE架构。融入了模型化、模板、缓存、AJAX、SEO等前沿技术。与同类产品相比，系统功能更加强大、使用更加简单、运行更加稳 定、安全性更强，效率更高，用户体验更好。系统开源发布，便于二次开发、功能整合、个性修改。 由于使用了JAVA开发语言，无论是在Linux/Unix，还是在Windows服务器上，均能良好运行 |
|
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 isjava.sql.Short. If set to true (the default), then the returned object is of typejava.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 |
