mybatis常用jdbcType数据类型

MyBatis通过包含的jdbcType类型

BITFLOATCHARTIMESTAMPOTHERUNDEFINED

TINYINTREALVARCHARBINARYBLOBNVARCHAR

SMALLINTDOUBLELONGVARCHARVARBINARYCLOBNCHAR

INTEGERNUMERICDATELONGVARBINARYBOOLEANNCLOB

BIGINTDECIMALTIMENULLCURSOR

Mybatis中javaType和jdbcType对应和CRUD例子

<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"/>
   <result 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 property="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>

Mybatis中javaType和jdbcType对应关系

JDBC Type           Java Type  
 CHAR                String  
 VARCHAR             String  
 LONGVARCHAR         String  
 NUMERIC             java.math.BigDecimal  
 DECIMAL             java.math.BigDecimal  
 BIT             　　 boolean  
 BOOLEAN             boolean  
 TINYINT             byte  
 SMALLINT            short  
 INTEGER             int  
 BIGINT              long  
 REAL                float  
 FLOAT               double  
 DOUBLE              double  
 BINARY              byte[]  
 VARBINARY           byte[]  
 LONGVARBINARY       byte[]  
 DATE                java.sql.Date  
 TIME                java.sql.Time  
 TIMESTAMP           java.sql.Timestamp  
 CLOB                Clob  
 BLOB                Blob  
 ARRAY               Array  
 DISTINCT            mapping of underlying type  
 STRUCT              Struct  
 REF                 Ref  
 DATALINK            java.net.URL[color=red][/color]