|
SQL Server 类型 |
JDBC 类型 (java.sql.Types) |
Java 语言类型 |
|
bigint |
BIGINT |
long |
|
timestamp binary |
BINARY |
byte[] |
|
bit |
BIT |
boolean |
|
char |
CHAR |
String |
|
decimal money smallmoney |
DECIMAL |
java.math.BigDecimal |
|
float |
DOUBLE |
double |
|
int |
INTEGER |
int |
|
image varbinary(max) |
LONGVARBINARY |
byte[] |
|
varchar(max) text |
LONGVARCHAR |
String |
|
nchar |
CHAR NCHAR (Java SE 6.0) |
String |
|
nvarchar |
VARCHAR NVARCHAR (Java SE 6.0) |
String |
|
nvarchar(max) ntext |
LONGVARCHAR LONGNVARCHAR (Java SE 6.0) |
String |
|
numeric |
NUMERIC |
java.math.BigDecimal |
|
real |
REAL |
float |
|
smallint |
SMALLINT |
short |
|
datetime smalldatetime |
TIMESTAMP |
java.sql.Timestamp |
|
varbinary udt |
VARBINARY |
byte[] |
|
varchar |
VARCHAR |
String |
|
tinyint |
TINYINT |
short |
|
uniqueidentifier |
CHAR |
String |
|
xml |
LONGVARCHAR SQLXML (Java SE 6.0) |
String SQLXML |