MyBatis配置Mapping，JavaType和JDBCType的对应关系

宁可枝头抱香死，何曾吹落北风中。这篇文章主要讲述MyBatis配置Mapping，JavaType和JDBCType的对应关系相关的知识，希望能为你提供帮助。
Mybatis中javaType和jdbcType对应关系：
JDBC TypeJava Type
CHARString
VARCHARString
LONGVARCHAR String
NUMERICjava.math.BigDecimal
DECIMAL java.math.BigDecimal
BIT boolean
BOOLEANboolean
TINYINT byte
SMALLINTshort
INTEGER int
BIGINTlong
REAL float
FLOATdouble
DOUBLEdouble
BINARY byte[]
VARBINARY byte[]
LONGVARBINARYbyte[]
DATE java.sql.Date
TIME java.sql.Time
TIMESTAMPjava.sql.Timestamp
CLOB Clob
BLOB Blob
ARRAYArray
DISTINCTmapping of underlying type
STRUCT Struct
REF Ref
DATALINKjava.net.URL[color=red][/color]
样例：

1 < resultMap type="java.util.Map" id="resultData"> 2< result property="FLD_NUMBER" column="FLD_NUMBER"javaType="double" jdbcType="NUMERIC"/> 3< result property="FLD_VARCHAR" column="FLD_VARCHAR" javaType="string" jdbcType="VARCHAR"/> 4< result property="FLD_DATE" column="FLD_DATE" javaType="java.sql.Date" jdbcType="DATE"/> 5< result property="FLD_INTEGER" column="FLD_INTEGER"javaType="int" jdbcType="INTEGER"/> 6< result property="FLD_DOUBLE" column="FLD_DOUBLE"javaType="double" jdbcType="DOUBLE"/> 7< result property="FLD_LONG" column="FLD_LONG"javaType="long" jdbcType="INTEGER"/> 8< result property="FLD_CHAR" column="FLD_CHAR"javaType="string" jdbcType="CHAR"/> 9< result property="FLD_BLOB" column="FLD_BLOB"javaType="Blob" jdbcType="BLOB" /> 10< result property="FLD_CLOB" column="FLD_CLOB"javaType="string" jdbcType="CLOB"/> 11< result property="FLD_FLOAT" column="FLD_FLOAT"javaType="float" jdbcType="FLOAT"/> 12< result property="FLD_TIMESTAMP" column="FLD_TIMESTAMP"javaType="java.sql.Timestamp" jdbcType="TIMESTAMP"/> 13< /resultMap>