Mybatis jdbcType 和javaType对比 实际可以看JDBCTYPE这枚举类
1 JDBC Type Java Type 2 CHAR String 3 VARCHAR String 4 LONGVARCHAR String 5 NUMERIC java.math.BigDecimal 6 DECIMAL java.math.BigDecimal 7 BIT boolean 8 BOOLEAN boolean 9 TINYINT byte 10 SMALLINT short 11 INTEGER INTEGER 12 BIGINT long 13 REAL float 14 FLOAT double 15 DOUBLE double 16 BINARY byte[] 17 VARBINARY byte[] 18 LONGVARBINARY byte[] 19 DATE java.sql.Date 20 TIME java.sql.Time 21 TIMESTAMP java.sql.Timestamp 22 CLOB Clob 23 BLOB Blob 24 ARRAY Array 25 DISTINCT mapping of underlying type 26 STRUCT Struct 27 REF Ref 28 DATALINK java.net.URL
jdbcType在type包里边
1 public enum JdbcType { 2 ARRAY(2003), 3 BIT(-7), 4 TINYINT(-6), 5 SMALLINT(5), 6 INTEGER(4), 7 BIGINT(-5), 8 FLOAT(6), 9 REAL(7), 10 DOUBLE(8), 11 NUMERIC(2), 12 DECIMAL(3), 13 CHAR(1), 14 VARCHAR(12), 15 LONGVARCHAR(-1), 16 DATE(91), 17 TIME(92), 18 TIMESTAMP(93), 19 BINARY(-2), 20 VARBINARY(-3), 21 LONGVARBINARY(-4), 22 NULL(0), 23 OTHER(1111), 24 BLOB(2004), 25 CLOB(2005), 26 BOOLEAN(16), 27 CURSOR(-10), 28 UNDEFINED(-2147482648), 29 NVARCHAR(-9), 30 NCHAR(-15), 31 NCLOB(2011), 32 STRUCT(2002), 33 JAVA_OBJECT(2000), 34 DISTINCT(2001), 35 REF(2006), 36 DATALINK(70), 37 ROWID(-8), 38 LONGNVARCHAR(-16), 39 SQLXML(2009), 40 DATETIMEOFFSET(-155), 41 TIME_WITH_TIMEZONE(2013), 42 TIMESTAMP_WITH_TIMEZONE(2014);