数据库学习——sqlserver数据库类型对应Java中的数据类型

女爷i 2022-05-10 05:08 354阅读 0赞

转自：[https://www.cnblogs.com/cunkouzh/p/5504052.html][https_www.cnblogs.com_cunkouzh_p_5504052.html]

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

<table> 
 <tbody> 
 <tr> 
 <th>SQL Server 类型</th> 
 <th>JDBC 类型 (java.sql.Types)</th> 
 <th>Java 语言类型</th> 
 </tr> 
 <tr> 
 <td> bigint </td> 
 <td> BIGINT </td> 
 <td> long </td> 
 </tr> 
 <tr> 
 <td> timestamp 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> decimal money smallmoney </td> 
 <td> DECIMAL </td> 
 <td> java.math.BigDecimal </td> 
 </tr> 
 <tr> 
 <td> float </td> 
 <td> DOUBLE </td> 
 <td> double </td> 
 </tr> 
 <tr> 
 <td> int </td> 
 <td> INTEGER </td> 
 <td> int </td> 
 </tr> 
 <tr> 
 <td> image varbinary(max) </td> 
 <td> LONGVARBINARY </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> varchar(max) text </td> 
 <td> LONGVARCHAR </td> 
 <td> String </td> 
 </tr> 
 <tr> 
 <td> nchar </td> 
 <td> CHAR NCHAR (Java SE 6.0) </td> 
 <td> String </td> 
 </tr> 
 <tr> 
 <td> nvarchar </td> 
 <td> VARCHAR NVARCHAR (Java SE 6.0) </td> 
 <td> String </td> 
 </tr> 
 <tr> 
 <td> nvarchar(max) 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> real </td> 
 <td> REAL </td> 
 <td> float </td> 
 </tr> 
 <tr> 
 <td> smallint </td> 
 <td> SMALLINT </td> 
 <td> short </td> 
 </tr> 
 <tr> 
 <td> datetime smalldatetime </td> 
 <td> TIMESTAMP </td> 
 <td> java.sql.Timestamp </td> 
 </tr> 
 <tr> 
 <td> varbinary udt </td> 
 <td> VARBINARY </td> 
 <td> byte[] </td> 
 </tr> 
 <tr> 
 <td> varchar </td> 
 <td> VARCHAR </td> 
 <td> String </td> 
 </tr> 
 <tr> 
 <td> tinyint </td> 
 <td> TINYINT </td> 
 <td> short </td> 
 </tr> 
 <tr> 
 <td> uniqueidentifier </td> 
 <td> CHAR </td> 
 <td> String </td> 
 </tr> 
 <tr> 
 <td> xml </td> 
 <td> LONGVARCHAR SQLXML (Java SE 6.0) </td> 
 <td> String SQLXML </td> 
 </tr> 
 <tr> 
 <td> time </td> 
 <td> TIME (1) </td> 
 <td> java.sql.Time (1) </td> 
 </tr> 
 <tr> 
 <td> date </td> 
 <td> DATE </td> 
 <td> java.sql.Date </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> 
 </tbody> 
</table>

[https_www.cnblogs.com_cunkouzh_p_5504052.html]: https://www.cnblogs.com/cunkouzh/p/5504052.html