java.sql.Types类型类 public static final int
BIT = -7;
TINYINT = -6;
SMALLINT = 5;
INTEGER = 4;
BIGINT = -5;
FLOAT = 6;
REAL = 7;
DOUBLE = 8;
NUMERIC = 2;
DECIMAL = 3;
CHAR = 1;
VARCHAR = 12;
LONGVARCHAR = -1;
DATE = 91;
TIME = 92;
TIMESTAMP = 93;
BINARY = -2;
VARBINARY = -3;
LONGVARBINARY = -4;
NULL = 0;
OTHER = 1111;
JAVA_OBJECT = 2000;
DISTINCT = 2001;
STRUCT = 2002;
ARRAY = 2003;
BLOB = 2004;
CLOB = 2005;
REF = 2006;
DATALINK = 70;
BOOLEAN = 16;
ROWID = -8;
NCHAR = -15;
NVARCHAR = -9;
LONGNVARCHAR = -16;
NCLOB = 2011;
SQLXML = 2009;
简单类型分类整理:
整数类型:
TINYINT = -6;
SMALLINT = 5;
INTEGER = 4;
BIGINT = -5;
小数类型
FLOAT = 6;
DOUBLE = 8;
NUMERIC = 2;
DECIMAL = 3;
日期、时间类型
DATE = 91;
TIME = 92;
TIMESTAMP = 93;
字符类型
CHAR = 1;
VARCHAR = 12;
LONGVARCHAR = -1;
NCHAR = -15;
NVARCHAR = -9;
LONGNVARCHAR = -16;
大字段类型
BLOB = 2004;
CLOB = 2005;
NCLOB = 2011;
二进制类型
BINARY = -2;
VARBINARY = -3;
LONGVARBINARY = -4;
其他类型
BIT = -7;
REAL = 7;
NULL = 0;
OTHER = 1111;
JAVA_OBJECT = 2000;
DISTINCT = 2001;
STRUCT = 2002;
ARRAY = 2003;
REF = 2006;
DATALINK = 70;
BOOLEAN = 16;
ROWID = -8;
SQLXML = 2009;
BIT = -7;
TINYINT = -6;
SMALLINT = 5;
INTEGER = 4;
BIGINT = -5;
FLOAT = 6;
REAL = 7;
DOUBLE = 8;
NUMERIC = 2;
DECIMAL = 3;
CHAR = 1;
VARCHAR = 12;
LONGVARCHAR = -1;
DATE = 91;
TIME = 92;
TIMESTAMP = 93;
BINARY = -2;
VARBINARY = -3;
LONGVARBINARY = -4;
NULL = 0;
OTHER = 1111;
JAVA_OBJECT = 2000;
DISTINCT = 2001;
STRUCT = 2002;
ARRAY = 2003;
BLOB = 2004;
CLOB = 2005;
REF = 2006;
DATALINK = 70;
BOOLEAN = 16;
ROWID = -8;
NCHAR = -15;
NVARCHAR = -9;
LONGNVARCHAR = -16;
NCLOB = 2011;
SQLXML = 2009;
简单类型分类整理:
整数类型:
TINYINT = -6;
SMALLINT = 5;
INTEGER = 4;
BIGINT = -5;
小数类型
FLOAT = 6;
DOUBLE = 8;
NUMERIC = 2;
DECIMAL = 3;
日期、时间类型
DATE = 91;
TIME = 92;
TIMESTAMP = 93;
字符类型
CHAR = 1;
VARCHAR = 12;
LONGVARCHAR = -1;
NCHAR = -15;
NVARCHAR = -9;
LONGNVARCHAR = -16;
大字段类型
BLOB = 2004;
CLOB = 2005;
NCLOB = 2011;
二进制类型
BINARY = -2;
VARBINARY = -3;
LONGVARBINARY = -4;
其他类型
BIT = -7;
REAL = 7;
NULL = 0;
OTHER = 1111;
JAVA_OBJECT = 2000;
DISTINCT = 2001;
STRUCT = 2002;
ARRAY = 2003;
REF = 2006;
DATALINK = 70;
BOOLEAN = 16;
ROWID = -8;
SQLXML = 2009;