学步园

在使用一些数据库操作封装的框架时候数据库类型的对应很长用比如：使用spring的jdbctemplate时候如果用到type时候对应的字段类型就需要用到

int[] types = new int[] { Types.DECIMAL, Types.VARCHAR, Types.DECIMAL,
Types.DECIMAL, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR,
Types.VARCHAR, Types.VARCHAR, Types.DECIMAL, Types.DECIMAL };
jdbcOracleTemplate.update(sql, obj, 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                             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                               blob
   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