Mybatis中jdbcType和javaType对应关系

1.表格对应

javaType	jdbcType
String	CHAR
String	VARCHAR
String	LONGVARCHAR
java.math.BigDecimal	NUMERIC
java.math.BigDecimal	DECIMAL
boolean	BIT
boolean	BOOLEAN
byte	TINYINT
short	SMALLINT
int	INTEGER
long	BIGINT
float	REAL
double	FLOAT
double	DOUBLE
double	DOUBLE
byte[]	BINARY
byte[]	VARBINARY
byte[]	LONGVARBINARY
java.sql.Date	DATE
java.sql.Date	TIMESTAMP
java.sql.time	TIME
java.sql.Timestamp	TIMESTAMP
Clob	CLOB
Blob	BLOB
Array	ARRAY
mapping of underlying type	DISTINCT
Struct	STRUCT
Ref	REF
java.net.URL	DATALINK