hibernate、java、数据库对应类型

╰+哭是因爲堅強的太久メ 2023-10-09 09:56 3阅读 0赞

转自：[https://www.cnblogs.com/caoyc/p/5596549.html][https_www.cnblogs.com_caoyc_p_5596549.html]

<table> 
 <tbody> 
  <tr> 
   <td><strong><small>ava数据类型</small></strong></td> 
   <td><strong><small>Hibernate数据类型</small></strong></td> 
   <td><strong><small>标准SQL数据类型<br>(PS:对于不同的DB可能有所差异)</small></strong></td> 
  </tr> 
  <tr> 
   <td>byte、java.lang.Byte</td> 
   <td>byte</td> 
   <td>TINYINT</td> 
  </tr> 
  <tr> 
   <td>short、java.lang.Short</td> 
   <td>short</td> 
   <td>SMALLINT</td> 
  </tr> 
  <tr> 
   <td>int、java.lang.Integer</td> 
   <td>integer</td> 
   <td>INGEGER</td> 
  </tr> 
  <tr> 
   <td>long、java.lang.Long</td> 
   <td>long</td> 
   <td>BIGINT</td> 
  </tr> 
  <tr> 
   <td>float、java.lang.Float</td> 
   <td>float</td> 
   <td>FLOAT</td> 
  </tr> 
  <tr> 
   <td>double、java.lang.Double</td> 
   <td>double</td> 
   <td>DOUBLE</td> 
  </tr> 
  <tr> 
   <td>java.math.BigDecimal</td> 
   <td>big_decimal</td> 
   <td>NUMERIC</td> 
  </tr> 
  <tr> 
   <td>char、java.lang.Character</td> 
   <td>character</td> 
   <td>CHAR(1)</td> 
  </tr> 
  <tr> 
   <td>boolean、java.lang.Boolean</td> 
   <td>boolean</td> 
   <td>BIT</td> 
  </tr> 
  <tr> 
   <td>java.lang.String</td> 
   <td>string</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>boolean、java.lang.Boolean</td> 
   <td>yes_no</td> 
   <td>CHAR(1)('Y'或'N')</td> 
  </tr> 
  <tr> 
   <td>boolean、java.lang.Boolean</td> 
   <td>true_false</td> 
   <td>CHAR(1)('Y'或'N')</td> 
  </tr> 
  <tr> 
   <td>java.util.Date、java.sql.Date</td> 
   <td>date</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>java.util.Date、java.sql.Time</td> 
   <td>time</td> 
   <td>TIME</td> 
  </tr> 
  <tr> 
   <td>java.util.Date、java.sql.Timestamp</td> 
   <td>timestamp</td> 
   <td>TIMESTAMP</td> 
  </tr> 
  <tr> 
   <td>java.util.Calendar</td> 
   <td>calendar</td> 
   <td>TIMESTAMP</td> 
  </tr> 
  <tr> 
   <td>java.util.Calendar</td> 
   <td>calendar_date</td> 
   <td>DATE</td> 
  </tr> 
  <tr> 
   <td>byte[]</td> 
   <td>binary</td> 
   <td>VARBINARY、BLOB</td> 
  </tr> 
  <tr> 
   <td>java.lang.String</td> 
   <td>text</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>java.io.Serializable</td> 
   <td>serializable</td> 
   <td>VARBINARY、BLOB</td> 
  </tr> 
  <tr> 
   <td>java.sql.Clob</td> 
   <td>clob</td> 
   <td>CLOB</td> 
  </tr> 
  <tr> 
   <td>java.sql.Blob</td> 
   <td>blob</td> 
   <td>BLOB</td> 
  </tr> 
  <tr> 
   <td>java.lang.Class</td> 
   <td>class</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>java.util.Locale</td> 
   <td>locale</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>java.util.TimeZone</td> 
   <td>timezone</td> 
   <td>VARCHAR</td> 
  </tr> 
  <tr> 
   <td>java.util.Currency</td> 
   <td>currency</td> 
   <td>VARCHAR</td> 
  </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/sharpest/p/11219610.html

[https_www.cnblogs.com_caoyc_p_5596549.html]: https://www.cnblogs.com/caoyc/p/5596549.html