JDBC查询结果集字段类型整理

来源：互联网发布：恐怖电影软件编辑：程序博客网时间：2024/05/21 22:46

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;

0 0