数据库类型对应的java数据类型总结

待我称王封你为后i 2024-04-19 11:17 72阅读 0赞

1.  数据库类型和mapper中jdbc对应的类型

<table> 
 <thead> 
  <tr> 
   <th>数据库类型</th> 
   <th>java数据类型</th> 
   <th>jdbc Type类型</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>bigint</td> 
   <td>Long</td> 
   <td>BIGINT</td> 
  </tr> 
  <tr> 
   <td>tinyint</td> 
   <td>Byte</td> 
   <td>TINYINT</td> 
  </tr> 
  <tr> 
   <td>smallint</td> 
   <td>Short</td> 
   <td>SMALLINT</td> 
  </tr> 
  <tr> 
   <td>mediumint</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
  </tr> 
  <tr> 
   <td>integer</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>Integer</td> 
   <td>INTEGER</td> 
  </tr> 
  <tr> 
   <td>float</td> 
   <td>Float</td> 
   <td>REAL</td> 
  </tr> 
  <tr> 
   <td>double</td> 
   <td>Double</td> 
   <td>DOUBLE</td> 
  </tr> 
  <tr> 
   <td>decimal</td> 
   <td>BigDecimal</td> 
   <td>DECIMAL</td> 
  </tr> 
  <tr> 
   <td>numeric</td> 
   <td>BigDecimal</td> 
   <td>DECIMAL</td> 
  </tr> 
  <tr> 
   <td>char</td> 
   <td>String</td> 
   <td>CHAR</td> 
  </tr> 
  <tr> 
   <td>varchar</td> 
   <td>String</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>tinyblob</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>BINARY</td> 
  </tr> 
  <tr> 
   <td>tinytext</td> 
   <td>String</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>blob</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>BINARY</td> 
  </tr> 
  <tr> 
   <td>text</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
  </tr> 
  <tr> 
   <td>mediumblob</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>LONGVARBINARY</td> 
  </tr> 
  <tr> 
   <td>mediumtext</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
  </tr> 
  <tr> 
   <td>longblob</td> 
   <td>DataTypeWithBLOBs.byte[]</td> 
   <td>LONGVARBINARY</td> 
  </tr> 
  <tr> 
   <td>longtext</td> 
   <td>DataTypeWithBLOBs.String</td> 
   <td>LONGVARCHAR</td> 
  </tr> 
  <tr> 
   <td>date</td> 
   <td>Date</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>time</td> 
   <td>Date</td> 
   <td>TIME</td> 
  </tr> 
  <tr> 
   <td>year</td> 
   <td>Date</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>datetime</td> 
   <td>Date</td> 
   <td>TIMESTAMP</td> 
  </tr> 
  <tr> 
   <td>timestamp</td> 
   <td>Date</td> 
   <td>TIMESTAMP</td> 
  </tr> 
 </tbody> 
</table>