本文小编为大家详细介绍“java中常见数据库字段类型有哪些”,内容详细,步骤清晰,细节处理妥当,希望这篇“java中常见数据库字段类型有哪些”文章能帮助大家解决疑惑,下面跟着小编的思路慢慢深入,一起来学习新知识吧。

常见数据库字段类型与java.sql.Types的对应Oracle与java.sql.Types的对应Oraclejava.sql.Typesblobblobcharcharclobclobdatedatenumberdecimallongvarbinarynclob,nvarchar2othersmallintsmallinttimestamptimstamprawvarbinaryvarchar2varcharSqlserver与java.sql.Types的对应Sqlserverjava.sql.Typesbigint(2005,2008)biginttimstamp,binarybinarybitbitchar,nchar,unqualifiedchardatetimedatemoney,smallmoney,decimaldecimalfloat(2005,2008)doublefloat(2000)floatintintegerimagelongvarbinarytext,ntext,xmllongvarcharnumericnumericrealrealsmallintsmallintdatetime,smalldatetimetimestamptinyinttinyintvarbinaryvarbinaynvarchar,varcharvarcharDB2与java.sql.Types的对应bigintbigintblobblobcharacter,graphiccharclobclobdatedatedecimaldecimaldoubledoubleintegerintegerlongvargraphiclongvarcharlongvarcharrealrealsmallintsmallinttimetimetimestamptimestampvargraphicvarcharvarcharMySQL与java.sql.Types的对应MySQLjava.sql.Typesbigintbiginttinyblobbinarybitbitenum,set,charchardate,yeardatedecimal,numericdecimaldouble,realdoublemediumint,intintegerblob,mediumblobbloblongblobfloatrealsmallintsmallinttimetimetimestamp,datetimetimestamptinyinttinyintvarbinary,binaryvarbinayvarchar,tinytext,textvarcharSybase与java.sql.Types的对应Sybasejava.sql.Typesbinarybinarybitbitchar,nchar,charmoney,smallmoney,decimaldecimalfloatdoubleintintegerimagelongvarbinarytextlongvarcharnumericnumericrealrealsmallintsmallintdatetime,smalldatetimetimestamptinyinttinyintvarbinar,timestampvarbinaynvarchar,varchar,sysnamevarchar

读到这里,这篇“java中常见数据库字段类型有哪些”文章已经介绍完毕,想要掌握这篇文章的知识点还需要大家自己动手实践使用过才能领会,如果想了解更多相关内容的文章,欢迎关注亿速云行业资讯频道。