Correspondence between Javatype and Jdbctype in MyBatis

MyBatis by the included Jdbctype type

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

javatype and Jdbctype correspondence and crud examples in Mybatis

<resultmap type= "Java.util.Map" id= "RESULTJCM" > <result property= "fld_number" column= "Fld_number" javaType= "Double" jdbctype= "NUMERIC"/> <result property= "Fld_varchar" column= "Fld_varchar" javatype= "string" jdbctype= " VARCHAR "/> <result property=" fld_date "column=" Fld_date "javatype=" Java.sql.Date "jdbctype=" DATE "/> <res Ult property= "Fld_integer" column= "Fld_integer" javatype= "int" jdbctype= "INTEGER"/> <result property= "FLD_ Double "column=" fld_double "javatype=" Double "jdbctype=" double "/> <result property=" Fld_long "column=" Fld_long "Javatype=" Long "jdbctype=" INTEGER "/> <result property=" Fld_char "column=" Fld_char "javatype=" string "Jdbctype = "CHAR"/> <result property= "Fld_blob" column= "Fld_blob" javatype= "[B" jdbctype= "BLOB"/> <result Proper Ty= "Fld_clob" column= "Fld_clob" javatype= "string" jdbctype= "CLOB"/> <result property= "fld_float" column= "FLD_ Float "javatype=" float "jdbctype=" float"/> <result property=" Fld_timestamp "column=" Fld_timestamp "javatype=" Java.sql.Timestamp "jdbctype=" TIMESTAMP   "/> </resultMap>

　　

correspondence between Javatype and jdbctype in Mybatis

2. JDBC type Java Type
4. CHAR String
6. VARCHAR String
8. LongVarChar String
10. NUMERIC Java.math.BigDecimal
12. DECIMAL Java.math.BigDecimal
14. BIT Boolean
16. Boolean Boolean
18. TINYINT byte
20. SMALLINT Short
22. INTEGER int
24. BIGINT Long
26. REAL float
28. FLOAT Double
30. Double Double
32. BINARY byte[]
34. VARBINARY byte[]
36. LongVarBinary byte[]
38. DATE java.sql.Date
40. Time Java.sql.Time
42. TIMESTAMP Java.sql.Timestamp
44. CLOB CLOB
46. Blob blob
48. Array array
50. DISTINCT mapping of underlying type
52. struct struct
54. Ref ref
56. DATALINK Java.net.url[color=red][/color]

Correspondence between Javatype and Jdbctype in MyBatis