mybatis与java以及与数据库类型的对应

Mybatis设置的jdbcType	java中的类	MySQL数据库数据类型	Oracle数据库
CHAR	String	CHAR	CHAR
VARCHAR	String	VARCHAR	VARCHAR
LONGVARCHAR	String	VARCHAR	LONG
NUMERIC	java.math.BigDecimal	NUMERIC	NUMERIC/NUMBER
DECIMAL	java.math.BigDecimal	DECIMAL	DECIMAL
BIT	boolean		BIT
BOOLEAN	boolean
TINYINT	byte	TINYINT
SMALLINT	short	SMALLINT	SMALLINT
INTEGER	int	INTEGER	INTEGER
BIGINT	long	BIGINT
REAL	float	REAL	REAL
FLOAT	double	FLOAT	FLOAT
DOUBLE	double	DOUBLE	NUMBER
BINARY	byte[]
VARBINARY	byte[]
LONGVARBINARY	byte[]
DATE	java.sql.Date	DATE	DATE
TIME	java.sql.Time		TIME
TIMESTAMP	java.sql.Timestamp	TIMESTAMP/DATETIME	TIMESTAMP
CLOB	Clob	CLOB	CLOB
BLOB	Blob	BLOB	BLOB
ARRAY	Array
DISTINCT	mapping of underlying type
STRUCT	Struct
REF	Ref
DATALINK	java.net.URL
NCHAR	java.net.URL		NCHAR
NCLOB	java.net.URL		NCLOB
NULL	NuLL