mysql与oracle数据类型对应关系_Mybatis JdbcType与Oracle、MySql 数据类型对应关系

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对应和CRUD例子

一、 Mybatis JDBCType与JavaType数据类型对应列表

JDBC TypeJava Type

CHARString

VARCHARString

LONGVARCHARString

NUMERICjava.math.BigDecimal

DECIMALjava.math.BigDecimal

BITboolean

BOOLEANboolean

TINYINTbyte

SMALLINTshort

INTEGERint

BIGINTlong

REALfloat

FLOATdouble

DOUBLEdouble

BINARYbyte[]

VARBINARYbyte[]

LONGVARBINARY byte[]

DATEjava.sql.Date

TIMEjava.sql.Time

TIMESTAMPjava.sql.Timestamp

CLOBClob

BLOBBlob

ARRAYArray

DISTINCTmapping of underlying type

STRUCTStruct

REF Ref

DATALINKjava.net.URL[color=red][/color]

----------------------------------------------------------------------------

二、 Mybatis JdbcType与Oracle、MySql