java中常见数据库字段类型与java.sql.Types的对应

常见数据库字段类型与java.sql.Types的对应

Oracle与java.sql.Types的对应

Oracle java.sql.Types

blob blob

char char

clob clob

date date

number decimal

long varbinary

nclob,nvarchar2 other

smallint smallint

timestamp timstamp

raw varbinary

varchar2 varchar

Sql server与java.sql.Types的对应

Sql server java.sql.Types

bigint (2005,2008) bigint

timstamp,binary binary

bit bit

char,nchar,unqualified char

datetime date

money,smallmoney,decimal decimal

float (2005,2008) double

float(2000) float

int integer

image longvarbinary

text,ntext,xml longvarchar

numeric numeric

real real

smallint smallint

datetime,smalldatetime timestamp

tinyint tinyint

varbinary varbinay

nvarchar,varchar varchar

DB2与java.sql.Types的对应

bigint bigint

blob blob

character,graphic char

clob clob

date date

decimal decimal

double double

integer integer

longvargraphic longvarchar

longvarchar

real real

smallint smallint

time time

timestamp timestamp

vargraphic varchar

varchar

MySQL与java.sql.Types的对应

MySQL java.sql.Types

bigint bigint

tinyblob binary

bit bit

enum,set,char char

date,year date

decimal,numeric decimal

double,real double

mediumint,int integer

blob,mediumblob blob

longblob

float real

smallint smallint

time time

timestamp,datetime timestamp

tinyint tinyint

varbinary,binary varbinay

varchar,tinytext,text varchar

Sybase与java.sql.Types的对应

Sybase java.sql.Types

binary binary

bit bit

char,nchar, char

money,smallmoney,decimal decimal

float double

int integer

text longvarchar

numeric numeric

real real

smallint smallint

datetime,smalldatetime timestamp

tinyint tinyint

varbinar,timestamp varbinay

nvarchar,varchar ,sysname varchar