Mysql-Java 数据类型映射
| MySQL Type | Java Type |
| BIT(1) (new in MySQL-5.0) | java.lang.Boolean |
| BIT( > 1) (new in MySQL-5.0) | byte[] |
| 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 | See TINYINT, above as these are aliases for TINYINT(1), currently. |
| SMALLINT[(M)] [UNSIGNED] | java.lang.Integer (regardless of whether it is UNSIGNED or not) |
| MEDIUMINT[(M)] [UNSIGNED] | java.lang.Integer (regardless of whether it is UNSIGNED or not) |
| INT,INTEGER[(M)] [UNSIGNED] | java.lang.Integer, if UNSIGNED java.lang.Long |
| BIGINT[(M)] [UNSIGNED] | java.lang.Long, if UNSIGNED java.math.BigInteger |
| FLOAT[(M,D)] | java.lang.Float |
| DOUBLE[(M,B)] | java.lang.Double |
| DECIMAL[(M[,D])] | java.math.BigDecimal |
| DATE | java.sql.Date |
| DATETIME | java.sql.Timestamp |
| TIMESTAMP[(M)] | java.sql.Timestamp |
| TIME | java.sql.Time |
| YEAR[(2|4)] | If yearIsDateType configuration property is set to false, then the returned object type is java.sql.Short. If set to true (the default), then the returned object is of type java.sql.Date with the date set to January 1st, at midnight. |
| CHAR(M) | java.lang.String (unless the character set for the column is BINARY, then byte[] is returned. |
| VARCHAR(M) [BINARY] | java.lang.String (unless the character set for the column is BINARY, then byte[] is returned. |
| BINARY(M) | byte[] |
| VARBINARY(M) | byte[] |
| TINYBLOB | byte[] |
| TINYTEXT | java.lang.String |
| BLOB | byte[] |
| TEXT | java.lang.String |
| MEDIUMBLOB | byte[] |
| MEDIUMTEXT | java.lang.String |
| LONGBLOB | byte[] |
| LONGTEXT | java.lang.String |
| ENUM(‘value1′,’value2’,…) | java.lang.String |
| SET(‘value1′,’value2’,…) | java.lang.String |
欢迎大家阅读《mysql-java数据映射门类_mysql》,跪求各位点评，by 搞代码
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql-java数据映射门类_mysql
转载请注明原文链接：mysql-java数据映射门类_mysql
