in core/src/main/java/com/alibaba/druid/sql/ast/SQLDataTypeImpl.java [178:395]
public int jdbcType() {
long nameNash = nameHashCode64();
if (nameNash == FnvHash.Constants.TINYINT) {
return Types.TINYINT;
}
if (nameNash == FnvHash.Constants.SMALLINT) {
return Types.SMALLINT;
}
if (nameNash == FnvHash.Constants.INT || nameNash == FnvHash.Constants.INTEGER) {
return Types.INTEGER;
}
if (nameNash == FnvHash.Constants.BIGINT) {
return Types.BIGINT;
}
if (nameNash == FnvHash.Constants.DECIMAL) {
return Types.DECIMAL;
}
if (nameNash == FnvHash.Constants.FLOAT) {
return Types.FLOAT;
}
if (nameNash == FnvHash.Constants.REAL) {
return Types.REAL;
}
if (nameNash == FnvHash.Constants.DOUBLE) {
return Types.DOUBLE;
}
if (nameNash == FnvHash.Constants.NUMBER || nameNash == FnvHash.Constants.NUMERIC) {
return Types.NUMERIC;
}
if (nameNash == FnvHash.Constants.BOOLEAN) {
return Types.BOOLEAN;
}
if (nameNash == FnvHash.Constants.DATE || nameNash == FnvHash.Constants.NEWDATE) {
return Types.DATE;
}
if (nameNash == FnvHash.Constants.DATETIME || nameNash == FnvHash.Constants.TIMESTAMP) {
return Types.TIMESTAMP;
}
if (nameNash == FnvHash.Constants.TIME) {
return Types.TIME;
}
if (nameNash == FnvHash.Constants.BLOB) {
return Types.BLOB;
}
if (nameNash == FnvHash.Constants.ROWID) {
return Types.ROWID;
}
if (nameNash == FnvHash.Constants.REF) {
return Types.REF;
}
if (nameNash == FnvHash.Constants.TINYINT || nameNash == FnvHash.Constants.TINY) {
return Types.TINYINT;
}
if (nameNash == FnvHash.Constants.SMALLINT || nameNash == FnvHash.Constants.SHORT) {
return Types.SMALLINT;
}
if (nameNash == FnvHash.Constants.INT
|| nameNash == FnvHash.Constants.INT24
|| nameNash == FnvHash.Constants.INTEGER) {
return Types.INTEGER;
}
if (nameNash == FnvHash.Constants.NUMBER || nameNash == FnvHash.Constants.NUMERIC) {
return Types.NUMERIC;
}
if (nameNash == FnvHash.Constants.BOOLEAN) {
return Types.BOOLEAN;
}
if (nameNash == FnvHash.Constants.DATE
|| nameNash == FnvHash.Constants.YEAR
|| nameNash == FnvHash.Constants.NEWDATE) {
return Types.DATE;
}
if (nameNash == FnvHash.Constants.DATETIME || nameNash == FnvHash.Constants.TIMESTAMP) {
return Types.TIMESTAMP;
}
if (nameNash == FnvHash.Constants.TIME) {
return Types.TIME;
}
if (nameNash == FnvHash.Constants.TINYBLOB) {
return Types.VARBINARY;
}
if (nameNash == FnvHash.Constants.BLOB) {
return Types.BLOB;
}
if (nameNash == FnvHash.Constants.LONGBLOB) {
return Types.LONGVARBINARY;
}
if (nameNash == FnvHash.Constants.ROWID) {
return Types.ROWID;
}
if (nameNash == FnvHash.Constants.REF) {
return Types.REF;
}
if (nameNash == FnvHash.Constants.BINARY || nameNash == FnvHash.Constants.GEOMETRY) {
return Types.BINARY;
}
if (nameNash == FnvHash.Constants.SQLXML) {
return Types.SQLXML;
}
if (nameNash == FnvHash.Constants.BIT) {
return Types.BIT;
}
if (nameNash == FnvHash.Constants.NCHAR) {
return Types.NCHAR;
}
if (nameNash == FnvHash.Constants.CHAR
|| nameNash == FnvHash.Constants.ENUM
|| nameNash == FnvHash.Constants.SET
|| nameNash == FnvHash.Constants.JSON) {
return Types.CHAR;
}
if (nameNash == FnvHash.Constants.VARCHAR
|| nameNash == FnvHash.Constants.VARCHAR2
|| nameNash == FnvHash.Constants.STRING) {
return Types.VARCHAR;
}
if (nameNash == FnvHash.Constants.NVARCHAR || nameNash == FnvHash.Constants.NVARCHAR2) {
return Types.NVARCHAR;
}
if (nameNash == FnvHash.Constants.CLOB
|| nameNash == FnvHash.Constants.TEXT
|| nameNash == FnvHash.Constants.TINYTEXT
|| nameNash == FnvHash.Constants.MEDIUMTEXT
|| nameNash == FnvHash.Constants.LONGTEXT) {
return Types.CLOB;
}
if (nameNash == FnvHash.Constants.NCLOB) {
return Types.NCLOB;
}
if (nameNash == FnvHash.Constants.TINYBLOB) {
return Types.VARBINARY;
}
if (nameNash == FnvHash.Constants.LONGBLOB) {
return Types.LONGVARBINARY;
}
if (nameNash == FnvHash.Constants.BINARY || nameNash == FnvHash.Constants.GEOMETRY) {
return Types.BINARY;
}
if (nameNash == FnvHash.Constants.SQLXML) {
return Types.SQLXML;
}
//
if (nameNash == FnvHash.Constants.NCHAR) {
return Types.NCHAR;
}
if (nameNash == FnvHash.Constants.CHAR || nameNash == FnvHash.Constants.JSON) {
return Types.CHAR;
}
if (nameNash == FnvHash.Constants.VARCHAR
|| nameNash == FnvHash.Constants.VARCHAR2
|| nameNash == FnvHash.Constants.STRING) {
return Types.VARCHAR;
}
if (nameNash == FnvHash.Constants.NVARCHAR || nameNash == FnvHash.Constants.NVARCHAR2) {
return Types.NVARCHAR;
}
if (nameNash == FnvHash.Constants.CLOB
|| nameNash == FnvHash.Constants.TEXT
|| nameNash == FnvHash.Constants.TINYTEXT
|| nameNash == FnvHash.Constants.MEDIUMTEXT
|| nameNash == FnvHash.Constants.LONGTEXT) {
return Types.CLOB;
}
if (nameNash == FnvHash.Constants.NCLOB) {
return Types.NCLOB;
}
return 0;
}