Java和MySQL数据类型对应表

清疚 2022-06-15 11:24 215阅读 0赞

<table style="color:rgb(0,0,0); font-family:Helvetica,Arial,sans-serif; font-size:14px; line-height:25px">      
 <tbody> 
  <tr> 
   <td colspan="3">Table&nbsp;20.25.&nbsp;MySQL Types to Java Types for ResultSet.getObject()</td> 
  </tr> 
  <tr> 
   <td>MySQL Type Name</td> 
   <td>Return value ofGetColumnClassName</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>

对于boolean类型，在[MySQL][][数据库][MySQL]中，个人认为用int类型代替较好，对bit操作不是很方便，尤其是在具有web页面开发的项目中，表示0/1，对应[Java][]类型的Integer较好。

我的概念中,mysql中的text字段应该是没有长度限制的,但是今天事实告诉我,text类型的长度是有限制的。其中mysql的text类型有64K长度限制的

工作中由于邮件的长度超过了64k,Text已经不适用，我们换用了MEDIUMTEXT 他的长度为16777215 (2^24 - 1) 为256\*64K=16M

[MySQL]: http://lib.csdn.net/base/mysql
[Java]: http://lib.csdn.net/base/javase