Mybatis中jdbcType和javaType以及数据库类型的对应关系

jdbcType	javaType	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	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[color=red][/color]
NCLOB			NCLOB

转载于:https://www.cnblogs.com/guoyinghome/p/10904052.html