mybatis与mysql类型关系映射

秒速五厘米 2023-06-26 05:47 13阅读 0赞

<table> 
 <thead> 
  <tr> 
   <th>Java</th> 
   <th>MySQL</th> 
   <th>MySQL定义示例</th> 
   <th>Java包</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>Boolean</td> 
   <td>bit</td> 
   <td>bit(1)</td> 
   <td>java.lang.Boolean</td> 
  </tr> 
  <tr> 
   <td>BigDecimal</td> 
   <td>decimal</td> 
   <td>decimal(6,2)</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>Byte</td> 
   <td>tinyint</td> 
   <td>tinyint(2)</td> 
   <td>java.lang.Byte</td> 
  </tr> 
  <tr> 
   <td>Double</td> 
   <td>double</td> 
   <td>double(5,2)</td> 
   <td>java.lang.Double</td> 
  </tr> 
  <tr> 
   <td>Float</td> 
   <td>float</td> 
   <td>float(5,2)</td> 
   <td>java.lang.Float</td> 
  </tr> 
  <tr> 
   <td>Integer</td> 
   <td>int</td> 
   <td>int(6)</td> 
   <td>java.lang.Integer</td> 
  </tr> 
  <tr> 
   <td>Long</td> 
   <td>bigint</td> 
   <td>bigint(20)</td> 
   <td>java.lang.Long</td> 
  </tr> 
  <tr> 
   <td>Short</td> 
   <td>smallint</td> 
   <td>smallint(6)</td> 
   <td>java.lang.Short</td> 
  </tr> 
  <tr> 
   <td>String</td> 
   <td>char</td> 
   <td>char(1)</td> 
   <td>java.lang.String</td> 
  </tr> 
  <tr> 
   <td>String</td> 
   <td>varchar</td> 
   <td>varchar(50)</td> 
   <td>java.lang.String</td> 
  </tr> 
  <tr> 
   <td>String</td> 
   <td>enum</td> 
   <td>enum(‘1’,‘2’,‘3’)</td> 
   <td>java.lang.String</td> 
  </tr> 
  <tr> 
   <td>String</td> 
   <td>text</td> 
   <td>text</td> 
   <td>java.lang.String</td> 
  </tr> 
  <tr> 
   <td>Date</td> 
   <td>date</td> 
   <td>date</td> 
   <td>java.util.Date</td> 
  </tr> 
  <tr> 
   <td>Date</td> 
   <td>time</td> 
   <td>time</td> 
   <td>java.util.Date</td> 
  </tr> 
  <tr> 
   <td>Date</td> 
   <td>timestamp</td> 
   <td>timestamp</td> 
   <td>java.util.Date</td> 
  </tr> 
  <tr> 
   <td>Date</td> 
   <td>datetime</td> 
   <td>datetime</td> 
   <td>java.util.Date</td> 
  </tr> 
  <tr> 
   <td>Object</td> 
   <td>json</td> 
   <td>json</td> 
   <td>java.lang.Object</td> 
  </tr> 
  <tr> 
   <td>byte[]</td> 
   <td>blob</td> 
   <td>blob</td> 
   <td>[B</td> 
  </tr> 
 </tbody> 
</table>