Java&MySQL Type Mapping

秒速五厘米 2022-01-14 11:29 176阅读 0赞

[2019独角兽企业重金招聘Python工程师标准>>> ][2019_Python_] ![hot3.png][]

<table> 
 <tbody> 
 <tr> 
 <td> MySQL Type Name </td> 
 <td> Return value of GetColumnClassName </td> 
 <td> Returned as Java Class </td> 
 </tr> 
 <tr> 
 <td> BIT(1)&nbsp;(new in MySQL-5.0) </td> 
 <td> BIT </td> 
 <td> java.lang.Boolean </td> 
 </tr> 
 <tr> 
 <td> BIT( &gt; 1)&nbsp;(new in MySQL-5.0) </td> 
 <td> BIT </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> TINYINT </td> 
 <td> TINYINT </td> 
 <td> java.lang.Boolean&nbsp;if the configuration property&nbsp;tinyInt1isBit&nbsp;is set to&nbsp;true&nbsp;(the default) and the storage size is 1, orjava.lang.Integer&nbsp;if not. </td> 
 </tr> 
 <tr> 
 <td> BOOL,&nbsp;BOOLEAN </td> 
 <td> TINYINT </td> 
 <td> See&nbsp;TINYINT, above as these are aliases forTINYINT(1), currently. </td> 
 </tr> 
 <tr> 
 <td> SMALLINT[(M)] [UNSIGNED] </td> 
 <td> SMALLINT [UNSIGNED] </td> 
 <td> java.lang.Integer&nbsp;(regardless ifUNSIGNED&nbsp;or not) </td> 
 </tr> 
 <tr> 
 <td> MEDIUMINT[(M)] [UNSIGNED] </td> 
 <td> MEDIUMINT [UNSIGNED] </td> 
 <td> java.lang.Integer,&nbsp;if&nbsp;UNSIGNEDjava.lang.Long&nbsp;(C/J 3.1 and earlier), orjava.lang.Integer&nbsp;for C/J 5.0 and later </td> 
 </tr> 
 <tr> 
 <td> INT,INTEGER[(M)] [UNSIGNED] </td> 
 <td> INTEGER [UNSIGNED] </td> 
 <td> java.lang.Integer, if&nbsp;UNSIGNEDjava.lang.Long </td> 
 </tr> 
 <tr> 
 <td> BIGINT[(M)] [UNSIGNED] </td> 
 <td> BIGINT [UNSIGNED] </td> 
 <td> java.lang.Long, if UNSIGNEDjava.math.BigInteger </td> 
 </tr> 
 <tr> 
 <td> FLOAT[(M,D)] </td> 
 <td> FLOAT </td> 
 <td> java.lang.Float </td> 
 </tr> 
 <tr> 
 <td> DOUBLE[(M,B)] </td> 
 <td> DOUBLE </td> 
 <td> java.lang.Double </td> 
 </tr> 
 <tr> 
 <td> DECIMAL[(M[,D])] </td> 
 <td> DECIMAL </td> 
 <td> java.math.BigDecimal </td> 
 </tr> 
 <tr> 
 <td> DATE </td> 
 <td> DATE </td> 
 <td> java.sql.Date </td> 
 </tr> 
 <tr> 
 <td> DATETIME </td> 
 <td> DATETIME </td> 
 <td> java.sql.Timestamp </td> 
 </tr> 
 <tr> 
 <td> TIMESTAMP[(M)] </td> 
 <td> TIMESTAMP </td> 
 <td> java.sql.Timestamp </td> 
 </tr> 
 <tr> 
 <td> TIME </td> 
 <td> TIME </td> 
 <td> java.sql.Time </td> 
 </tr> 
 <tr> 
 <td> YEAR[(2|4)] </td> 
 <td> YEAR </td> 
 <td> If&nbsp;yearIsDateType&nbsp;configuration property is set to&nbsp;false, then the returned object type isjava.sql.Short. If set to&nbsp;true&nbsp;(the default), then the returned object is of typejava.sql.Date&nbsp;with the date set to January 1st, at midnight. </td> 
 </tr> 
 <tr> 
 <td> CHAR(M) </td> 
 <td> CHAR </td> 
 <td> java.lang.String&nbsp;(unless the character set for the column is&nbsp;BINARY, then&nbsp;byte[]&nbsp;is returned. </td> 
 </tr> 
 <tr> 
 <td> VARCHAR(M) [BINARY] </td> 
 <td> VARCHAR </td> 
 <td> java.lang.String&nbsp;(unless the character set for the column is&nbsp;BINARY, then&nbsp;byte[]&nbsp;is returned. </td> 
 </tr> 
 <tr> 
 <td> BINARY(M) </td> 
 <td> BINARY </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> VARBINARY(M) </td> 
 <td> VARBINARY </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> TINYBLOB </td> 
 <td> TINYBLOB </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> TINYTEXT </td> 
 <td> VARCHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 <tr> 
 <td> BLOB </td> 
 <td> BLOB </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> TEXT </td> 
 <td> VARCHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 <tr> 
 <td> MEDIUMBLOB </td> 
 <td> MEDIUMBLOB </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> MEDIUMTEXT </td> 
 <td> VARCHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 <tr> 
 <td> LONGBLOB </td> 
 <td> LONGBLOB </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> LONGTEXT </td> 
 <td> VARCHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 <tr> 
 <td> ENUM('value1','value2',...) </td> 
 <td> CHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 <tr> 
 <td> SET('value1','value2',...) </td> 
 <td> CHAR </td> 
 <td> java.lang.String </td> 
 </tr> 
 </tbody> 
</table>

转载于:https://my.oschina.net/secyaher/blog/274494

[2019_Python_]: https://my.oschina.net/u/2663968/blog/3061697
[hot3.png]: /images/20220114/a92d89826a424eba80aadaf9df79f074.png