MyBatis中的jdbcType

MyBatis中常用的jdbcType

BIT         FLOAT      CHAR           TIMESTAMP       OTHER       UNDEFINED

TINYINT     REAL       VARCHAR        BINARY          BLOB        NVARCHAR

SMALLINT    DOUBLE     LONGVARCHAR    VARBINARY       CLOB        NCHAR

INTEGER     NUMERIC    DATE           LONGVARBINARY   BOOLEAN     NCLOB

BIGINT      DECIMAL    TIME           NULL            CURSOR

Mybatis中javaType和jdbcType的对应关系

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

示例