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                               varcharSql 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                 varcharDB2与java.sql.Types的对应 bigint                                       bigint   blob                                      blob   character,graphic                 char   clob                                      clob   date                                     date   decimal                                decimal   double                                 double    integer                               integer    longvargraphic                   longvarchar    longvarcharreal                                        real smallint                                 smallint time                                      time timestamp                            timestamp vargraphic                            varchar varcharMySQL与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                               realsmallint                           smallint   time                             time   timestamp,datetime     timestamp   tinyint                           tinyint   varbinary,binary           varbinay   varchar,tinytext,text     varcharSybase与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                                      longvarcharnumeric                                   numeric    real                                     real    smallint                              smallint    datetime,smalldatetime     timestamp    tinyint                                 tinyint    varbinar,timestamp            varbinay    nvarchar,varchar ,sysname   varchar