java.sql.Types中定义的JDBC类型的对应int值

JDBC类型的对应int值
getColumnType()的返回值
返回值对应的类型
getColumnType()的返回值
getColumnType(3)得到的就是第三字段的字段类型对应的下列中的int值。

返回值对应的类型
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;
————————————————
版权声明：本文为CSDN博主「自不量力的A同学」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/xixixixixixixi21/article/details/120827598