Mybatis与Mysql常用数据类型映射表

àì夳堔傛蜴生んèń 2023-06-25 02:27 46阅读 0赞

<table> 
 <tbody> 
  <tr> 
   <td>MySQL&nbsp;&nbsp; &nbsp;</td> 
   <td>JDBCType&nbsp;&nbsp; &nbsp;</td> 
   <td>JavaType&nbsp;&nbsp; &nbsp;</td> 
   <td>备注</td> 
  </tr> 
  <tr> 
   <td>char</td> 
   <td>CHAR</td> 
   <td>String</td> 
   <td>定长字符</td> 
  </tr> 
  <tr> 
   <td>varchar</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
   <td>变长字符串</td> 
  </tr> 
  <tr> 
   <td>tinyint</td> 
   <td>TINYINT</td> 
   <td>byte</td> 
   <td>1字节</td> 
  </tr> 
  <tr> 
   <td>smallint</td> 
   <td>SMALLINT</td> 
   <td>short</td> 
   <td>2字节</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>INTEGER</td> 
   <td>int</td> 
   <td>4字节</td> 
  </tr> 
  <tr> 
   <td>float</td> 
   <td>FLOAT</td> 
   <td>float</td> 
   <td>4字节</td> 
  </tr> 
  <tr> 
   <td>bigint</td> 
   <td>BIGINT</td> 
   <td>long</td> 
   <td>8字节</td> 
  </tr> 
  <tr> 
   <td>double</td> 
   <td>DOUBLE</td> 
   <td>double</td> 
   <td>8字节</td> 
  </tr> 
  <tr> 
   <td>bit</td> 
   <td>BOOLEAN</td> 
   <td>boolean</td> 
   <td>布尔类型</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td>MySQL</td> 
   <td>JDBCType</td> 
   <td>JavaType</td> 
   <td>备注</td> 
  </tr> 
  <tr> 
   <td>date</td> 
   <td>Date</td> 
   <td>util.Date，sql.Date</td> 
   <td>YYYY-MM-DD</td> 
  </tr> 
  <tr> 
   <td>time</td> 
   <td>TIME</td> 
   <td>util.Date，sql.Date</td> 
   <td>HH:MM:SS</td> 
  </tr> 
  <tr> 
   <td>timestamp</td> 
   <td>TIMESTAMP</td> 
   <td>util.Date，sql.Date</td> 
   <td>YYYY-MM-DD&nbsp;HH:MM:SS</td> 
  </tr> 
  <tr> 
   <td>text</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
   <td>文本类型【2^16-1字节】</td> 
  </tr> 
  <tr> 
   <td>longtext</td> 
   <td>LONGVARCHAR</td> 
   <td>String</td> 
   <td>长文本类型【2^32-1字节</td> 
  </tr> 
 </tbody> 
</table>