MySQL 与 JDBC 类型映射

太过爱你忘了你带给我的痛 2022-05-17 02:06 159阅读 0赞

转自：[https://blog.csdn.net/sxe18652071425/article/details/78960017][https_blog.csdn.net_sxe18652071425_article_details_78960017]

<table> 
 <thead> 
  <tr> 
   <th>MySQL数据类型</th> 
   <th>JAVA数据类型</th> 
   <th>JDBC TYPE</th> 
   <th>普通变量类型</th> 
   <th>主键类型</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>BIGINT</td> 
   <td>Long</td> 
   <td>BIGINT</td> 
   <td>支持</td> 
   <td>支持</td> 
  </tr> 
  <tr> 
   <td>TINYINT</td> 
   <td>Byte</td> 
   <td>TINYINT</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>SMALLINT</td> 
   <td>Short</td> 
   <td>SMALLINT</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>MEDIUMINT</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
   <td>支持</td> 
   <td>支持</td> 
  </tr> 
  <tr> 
   <td>INTEGER</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
   <td>支持</td> 
   <td>支持</td> 
  </tr> 
  <tr> 
   <td>INT</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
   <td>支持</td> 
   <td>支持</td> 
  </tr> 
  <tr> 
   <td>FLOAT</td> 
   <td>Float</td> 
   <td>REAL</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>DOUBLE</td> 
   <td>Double</td> 
   <td>DOUBLE</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>DECIMAL</td> 
   <td>BigDecimal</td> 
   <td>DECIMAL</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>NUMERIC</td> 
   <td>BigDecimal</td> 
   <td>DECIMAL</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>CHAR</td> 
   <td>String</td> 
   <td>CHAR</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>VARCHAR</td> 
   <td>String</td> 
   <td>VARCHAR</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>TINYBLOB</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>BINARY</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>TINYTEXT</td> 
   <td>String</td> 
   <td>VARCHAR</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>BLOB</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>BINARY</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>TEXT</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>MEDIUMBLOB</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>LONGVARBINARY</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>MEDIUMTEXT</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>LONGBLOB</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>LONGVARBINARY</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>LONGTEXT</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>DATE</td> 
   <td>Date</td> 
   <td>DATE</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>TIME</td> 
   <td>Date</td> 
   <td>TIME</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>YEAR</td> 
   <td>Date</td> 
   <td>DATE</td> 
   <td>不支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>DATETIME</td> 
   <td>Date</td> 
   <td>TIMESTAMP</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
  <tr> 
   <td>TIMESTAMP</td> 
   <td>Date</td> 
   <td>TIMESTAMP</td> 
   <td>支持</td> 
   <td>不支持</td> 
  </tr> 
 </tbody> 
</table>

[https_blog.csdn.net_sxe18652071425_article_details_78960017]: https://blog.csdn.net/sxe18652071425/article/details/78960017