Mybatis中jdbcType和javaType的对应关系

Mybatis中jdbcType和javaType的对应关系

1 JDBC Type Java Type

2 CHAR String

3 VARCHAR String

4 LONGVARCHAR String

5 NUMERIC java.math.BigDecimal

6 DECIMAL java.math.BigDecimal

7 BIT boolean

8 BOOLEAN boolean

9 TINYINT byte

10 SMALLINT short

11 INTEGER int

12 BIGINT long

13 REAL float

14 FLOAT double

15 DOUBLE double

16 BINARY byte[]

17 VARBINARY byte[]

18 LONGVARBINARY byte[]

19 DATE java.sql.Date

20 TIME java.sql.Time

21 TIMESTAMP java.sql.Timestamp

22 CLOB Clob

23 BLOB Blob

24 ARRAY Array

25 DISTINCT mapping of underlying type

26 STRUCT Struct

27 REF Ref

28 DATALINK java.net.URL[color=red][/color]

Mybatis JdbcType与Oracle、MySql数据类型对应列表

Mybatis JdbcType Oracle MySql

JdbcType ARRAY

JdbcType BIGINT BIGINT

JdbcType BINARY

JdbcType BIT BIT

JdbcType BLOB BLOB BLOB

JdbcType BOOLEAN

JdbcType CHAR CHAR CHAR

JdbcType CLOB CLOB CLOB

JdbcType CURSOR

JdbcType DATE DATE DATE

JdbcType DECIMAL DECIMAL DECIMAL

JdbcType DOUBLE NUMBER DOUBLE

JdbcType FLOAT FLOAT FLOAT

JdbcType INTEGER INTEGER INTEGER

JdbcType LONGVARBINARY

JdbcType LONGVARCHAR LONG VARCHAR

JdbcType NCHAR NCHAR

JdbcType NCLOB NCLOB

JdbcType NULL

JdbcType NUMERIC NUMERIC/NUMBER NUMERIC/

JdbcType NVARCHAR

JdbcType OTHER

JdbcType REAL REAL REAL

JdbcType SMALLINT SMALLINT SMALLINT

JdbcType STRUCT

JdbcType TIME TIME

JdbcType TIMESTAMP TIMESTAMP TIMESTAMP/DATETIME

JdbcType TINYINT TINYINT

JdbcType UNDEFINED

JdbcType VARBINARY

JdbcType VARCHAR VARCHAR VARCHAR