JdbcType类型和Java类型的对应关系

向右看齐 2022-05-15 10:30 228阅读 0赞

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td> <p><strong>JDBC Type</strong> &nbsp;</p> </td> 
   <td><strong>Java Type &nbsp;</strong></td> 
  </tr> 
  <tr> 
   <td>CHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>VARCHAR</td> 
   <td>String &nbsp;</td> 
  </tr> 
  <tr> 
   <td>LONGVARCHAR</td> 
   <td>String &nbsp;</td> 
  </tr> 
  <tr> 
   <td>NUMERIC</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>DECIMAL</td> 
   <td>java.math.BigDecimal &nbsp;</td> 
  </tr> 
  <tr> 
   <td>BIT</td> 
   <td>boolean</td> 
  </tr> 
  <tr> 
   <td>BOOLEAN</td> 
   <td>boolean &nbsp;</td> 
  </tr> 
  <tr> 
   <td>TINYINT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</td> 
   <td>byte</td> 
  </tr> 
  <tr> 
   <td>SMALLINT</td> 
   <td>short</td> 
  </tr> 
  <tr> 
   <td>INTEGER</td> 
   <td>int&nbsp;</td> 
  </tr> 
  <tr> 
   <td>BIGINT</td> 
   <td>long</td> 
  </tr> 
  <tr> 
   <td>REAL</td> 
   <td>float</td> 
  </tr> 
  <tr> 
   <td>FLOAT</td> 
   <td>double</td> 
  </tr> 
  <tr> 
   <td>DOUBLE</td> 
   <td>double</td> 
  </tr> 
  <tr> 
   <td>BINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>LONGVARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>DATE</td> 
   <td>java.sql.Date</td> 
  </tr> 
  <tr> 
   <td>TIME</td> 
   <td>java.sql.Time</td> 
  </tr> 
  <tr> 
   <td>TIMESTAMP</td> 
   <td>java.sql.Timestamp</td> 
  </tr> 
  <tr> 
   <td>CLOB</td> 
   <td>Clob</td> 
  </tr> 
  <tr> 
   <td>BLOB</td> 
   <td>Blob</td> 
  </tr> 
  <tr> 
   <td>ARRAY</td> 
   <td>Array</td> 
  </tr> 
  <tr> 
   <td>DISTINCT</td> 
   <td>mapping of underlying type</td> 
  </tr> 
  <tr> 
   <td>STRUCT</td> 
   <td>Struct</td> 
  </tr> 
  <tr> 
   <td>REF&nbsp;</td> 
   <td>Ref</td> 
  </tr> 
  <tr> 
   <td>DATALINK</td> 
   <td>java.net.URL[color=red][/color]</td> 
  </tr> 
 </tbody> 
</table>