java mysql 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

image                                    longvarbinary

text                                      longvarchar

numeric                                   numeric

real                                     real

smallint                              smallint

datetime,smalldatetime     timestamp

tinyint                                 tinyint

varbinar,timestamp            varbinay

nvarchar,varchar ,sysname   varchar