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

SQL Server TypesJDBC 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