SQL Server数据类型对应的JDBC数据类型（java.sql.Types）和Java数据类型



SQL Server数据类型对应的JDBC数据类型（java.sql.Types）和Java数据类型  来源：http://blog.csdn.net/boyhxy/article/details/3984753

SQL Server Types JDBC Types (java.sql.Types) Java Language Types
bigint BIGINT long
timestamp
binary
uniqueidentifier		 BINARY byte[]
bit BIT boolean
charnchar CHAR String
N/A DATE java.sql.Date
decimal
money
smallmoney		 DECIMAL java.math.BigDecimal
N/A DOUBLE double
float FLOAT double
int INTEGER int
image LONGVARBINARY byte[]
text
ntext		 LONGVARCHAR String
N/A NULL N/A
numeric NUMERIC java.math.BigDecimal
N/A OTHER N/A
real REAL float
smallint
tinyint		 SMALLINT short
N/A TIME N/A
datetime
smalldatetime		 TIMESTAMP java.sql.Timestamp
N/A TINYINT byte[]
varbinary VARBINARY byte[]
varchar
nvarchar		 VARCHAR String