在使用一些数据库操作封装的框架时候数据库类型的对应很长用比如:使用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