当前位置: 代码迷 >> 综合 >> java中常见数据库字段类型与java.sql.Types的对应关系
  详细解决方案

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

热度:88   发布时间:2024-01-18 22:45:42.0

在使用一些数据库操作封装的框架时候数据库类型的对应很长用比如:使用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                                     blobchar                                     charclob                                     clobdate                                     datenumber                                   decimallong                                     varbinarynclob,nvarchar2                          othersmallint                                 smallinttimestamp                                timstampraw                                      varbinaryvarchar2                                 varcharSql server与java.sql.Types的对应 Sql server                           java.sql.Typesbigint (2005,2008)                     biginttimstamp,binary                        binarybit                                    bitchar,nchar,unqualified                 chardatetime                               datemoney,smallmoney,decimal               decimalfloat (2005,2008)                      doublefloat(2000)                            floatint                                    integerimage                                  longvarbinarytext,ntext,xml                         longvarcharnumeric                                numericreal                                   realsmallint                               smallintdatetime,smalldatetime                 timestamptinyint                                tinyintvarbinary                              varbinaynvarchar,varchar                       varcharDB2与java.sql.Types的对应 bigint                                  bigintblob                                    blobcharacter,graphic                       charclob                                    clobdate                                    datedecimal                                 decimaldouble                                  doubleinteger                                 integerlongvargraphic                          longvarcharlongvarchar                             longvarcharreal                                    realsmallint                                smallinttime                                    timetimestamp                               timestampvargraphic                              varcharvarcharMySQL与java.sql.Types的对应 MySQL                                  java.sql.Typesbigint                                 biginttinyblob                               binarybit                                    bitenum,set,char                          chardate,year                              datedecimal,numeric                        decimaldouble,real                            doublemediumint,int                          integerblob,mediumblob                        bloblongblob                               blob
float                                  realsmallint                               smallinttime                                   timetimestamp,datetime                     timestamptinyint                                tinyintvarbinary,binary                       varbinayvarchar,tinytext,text                  varcharSybase与java.sql.Types的对应 Sybase                                    java.sql.Typesbinary                                    binarybit                                       bitchar,nchar,                               charmoney,smallmoney,decimal                  decimalfloat                                     doubleint                                       integerimage                                     longvarbinarytext                                      longvarcharnumeric                                   numericreal                                      realsmallint                                  smallintdatetime,smalldatetime                    timestamptinyint                                   tinyintvarbinar,timestamp                        varbinaynvarchar,varchar ,sysname                 varchar