Mybatis中jdbcTyped与javaType的对应关系、及oracle、mysql的对应

Mybatis中jdbcTyped与javaType的对应关系、及oracle、mysql的对应

2018年07月26日 15:49:12 net亮 阅读数：74

1. 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数据类型对应列表

1. Mybatis JdbcType Oracle MySql

2. JdbcType ARRAY

3. JdbcType BIGINT BIGINT

4. JdbcType BINARY

5. JdbcType BIT BIT

6. JdbcType BLOB BLOB BLOB

7. JdbcType BOOLEAN

8. JdbcType CHAR CHAR CHAR

9. JdbcType CLOB CLOB CLOB

10. JdbcType CURSOR

11. JdbcType DATE DATE DATE

12. JdbcType DECIMAL DECIMAL DECIMAL

13. JdbcType DOUBLE NUMBER DOUBLE

14. JdbcType FLOAT FLOAT FLOAT

15. JdbcType INTEGER INTEGER INTEGER

16. JdbcType LONGVARBINARY

17. JdbcType LONGVARCHAR LONG VARCHAR

18. JdbcType NCHAR NCHAR

19. JdbcType NCLOB NCLOB

20. JdbcType NULL

21. JdbcType NUMERIC NUMERIC/NUMBER NUMERIC/

22. JdbcType NVARCHAR

23. JdbcType OTHER

24. JdbcType REAL REAL REAL

25. JdbcType SMALLINT SMALLINT SMALLINT

26. JdbcType STRUCT

27. JdbcType TIME TIME

28. JdbcType TIMESTAMP TIMESTAMP TIMESTAMP/DATETIME

29. JdbcType TINYINT TINYINT

30. JdbcType UNDEFINED

31. JdbcType VARBINARY

32. JdbcType VARCHAR VARCHAR VARCHAR