jdbc对SqlServer以及java数据类型映射表

分手后的思念是犯贱 2022-03-21 14:07 277阅读 0赞

## 简介 ##

Microsoft JDBC Driver for SQL Server 使用 JDBC 基本数据类型将 SQL Server 数据类型转换为 Java 编程语言能够理解的格式，反之亦然。 JDBC driver 提供对 JDBC 4.0 API，其中包括支持SQLXML数据类型和 National (Unicode) 数据类型，如NCHAR， NVARCHAR， LONGNVARCHAR，并NCLOB。

## 数据类型映射 ##

下表列出了基本 SQL Server、JDBC 和 Java 编程语言数据类型之间的默认映射：

<table> 
 <thead> 
  <tr> 
   <th>SQL Server 类型</th> 
   <th>JDBC 类型 (java.sql.Types)</th> 
   <th>Java 语言类型</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td></td> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>bigint</td> 
   <td>BIGINT</td> 
   <td>long</td> 
  </tr> 
  <tr> 
   <td>binary</td> 
   <td>BINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>bit</td> 
   <td>BIT</td> 
   <td>boolean</td> 
  </tr> 
  <tr> 
   <td>char</td> 
   <td>CHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>date</td> 
   <td>DATE</td> 
   <td>java.sql.Date</td> 
  </tr> 
  <tr> 
   <td>datetime</td> 
   <td>TIMESTAMP</td> 
   <td>java.sql.Timestamp</td> 
  </tr> 
  <tr> 
   <td>datetime2</td> 
   <td>TIMESTAMP</td> 
   <td>java.sql.Timestamp</td> 
  </tr> 
  <tr> 
   <td>datetimeoffset (2)</td> 
   <td>microsoft.sql.Types.DATETIMEOFFSET</td> 
   <td>microsoft.sql.DateTimeOffset</td> 
  </tr> 
  <tr> 
   <td>decimal</td> 
   <td>DECIMAL</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>float</td> 
   <td>DOUBLE</td> 
   <td>double</td> 
  </tr> 
  <tr> 
   <td>image</td> 
   <td>LONGVARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>INTEGER</td> 
   <td>int</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>DECIMAL</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>nchar</td> 
   <td>CHAR NCHAR (Java SE 6.0)</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>ntext</td> 
   <td>LONGVARCHAR LONGNVARCHAR (Java SE 6.0)</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>numeric</td> 
   <td>NUMERIC</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>nvarchar</td> 
   <td>VARCHAR NVARCHAR (Java SE 6.0)</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>nvarchar(max)</td> 
   <td>VARCHAR NVARCHAR (Java SE 6.0)</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>real</td> 
   <td>REAL</td> 
   <td>float</td> 
  </tr> 
  <tr> 
   <td>smalldatetime</td> 
   <td>TIMESTAMP</td> 
   <td>java.sql.Timestamp</td> 
  </tr> 
  <tr> 
   <td>smallint</td> 
   <td>SMALLINT</td> 
   <td>short</td> 
  </tr> 
  <tr> 
   <td>smallmoney</td> 
   <td>DECIMAL</td> 
   <td>java.math.BigDecimal</td> 
  </tr> 
  <tr> 
   <td>text</td> 
   <td>LONGVARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>time</td> 
   <td>TIME (1)</td> 
   <td>java.sql.Time (1)</td> 
  </tr> 
  <tr> 
   <td>timestamp</td> 
   <td>BINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>tinyint</td> 
   <td>TINYINT</td> 
   <td>short</td> 
  </tr> 
  <tr> 
   <td>udt</td> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>uniqueidentifier</td> 
   <td>CHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>varbinary</td> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>varbinary(max)</td> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>varchar</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>varchar(max)</td> 
   <td>VARCHAR</td> 
   <td>String</td> 
  </tr> 
  <tr> 
   <td>xml</td> 
   <td>LONGVARCHAR LONGNVARCHAR (Java SE 6.0)</td> 
   <td>String SQLXML</td> 
  </tr> 
  <tr> 
   <td>sqlvariant</td> 
   <td>SQLVARIANT</td> 
   <td>Object</td> 
  </tr> 
  <tr> 
   <td>geometry</td> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
  <tr> 
   <td>geography</td> 
   <td>VARBINARY</td> 
   <td>byte[]</td> 
  </tr> 
 </tbody> 
</table>

## 引用 ##

> https://docs.microsoft.com/zh-cn/sql/connect/jdbc/using-basic-data-types?view=sql-server-2017  
> https://docs.microsoft.com/zh-cn/sql/connect/jdbc/understanding-data-type-differences?view=sql-server-2017  
> https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-data-type-conversions?view=sql-server-2017