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

2017-01-05 11:12:52来源:oschina作者:无知的小孩人点击

public final static int BIT = -7; public final static int TINYINT = -6; public final static int SMALLINT = 5; public final static int INTEGER = 4; public final static int BIGINT = -5; public final static int FLOAT = 6; public final static int REAL = 7; public final static int DOUBLE = 8; public final static int NUMERIC = 2; public final static int DECIMAL = 3; public final static int CHAR = 1; public final static int VARCHAR = 12; public final static int LONGVARCHAR = -1; public final static int DATE = 91; public final static int TIME = 92; public final static int TIMESTAMP = 93; public final static int BINARY = -2; public final static int VARBINARY = -3; public final static int LONGVARBINARY = -4; public final static int NULL = 0; public final static int OTHER = 1111; public final static int JAVA_OBJECT = 2000; public final static int DISTINCT = 2001; public final static int STRUCT = 2002; public final static int ARRAY = 2003; public final static int BLOB = 2004; public final static int CLOB = 2005; public final static int REF = 2006; public final static int DATALINK = 70; public final static int BOOLEAN = 16; public final static int ROWID = -8; public static final int NCHAR = -15; public static final int NVARCHAR = -9; public static final int LONGNVARCHAR = -16; public static final int NCLOB = 2011; public static final int SQLXML = 2009;

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.Typesbigint (2005,2008) biginttimstamp,binary binarybit bitchar,nchar,unqualified chardatetime datemoney,smallmoney,decimal decimalfloat (2005,2008) doublefloat(2000) floatint integerimage longvarbinarytext,ntext,xml longvarchar numeric numericreal realsmallint smallintdatetime,smalldatetime timestamptinyint tinyintvarbinary varbinaynvarchar,varchar varcharDB2与java.sql.Types的对应bigint bigintblob blobcharacter,graphic charclob clobdate datedecimal decimaldouble doubleinteger integerlongvargraphic longvarcharlongvarcharreal real smallint smallint time time timestamp timestamp vargraphic varchar varcharMySQL与java.sql.Types的对应MySQL java.sql.Typesbigint biginttinyblob binarybit bitenum,set,char chardate,year datedecimal,numeric decimaldouble,real doublemediumint,int integerblob,mediumblob bloblongblobfloat realsmallint smallinttime timetimestamp,datetime timestamptinyint tinyintvarbinary,binary varbinayvarchar,tinytext,text varchar Sybase与java.sql.Types的对应Sybase java.sql.Typesbinary binarybit bitchar,nchar, charmoney,smallmoney,decimal decimalfloat doubleint integerimage longvarbinarytext longvarchar numeric numericreal realsmallint smallintdatetime,smalldatetime timestamptinyint tinyintvarbinar,timestamp varbinaynvarchar,varchar ,sysname varchar

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台