MyBatis常用的jdbcType数据类型

BIT     FLOAT   CHAR      TIMESTAMP    OTHER    UNDEFINEDTINYINT   REAL    VARCHAR    BINARY     BLOB    NVARCHARSMALLINT  DOUBLE   LONGVARCHAR  VARBINARY    CLOB    NCHARINTEGER   NUMERIC  DATE      LONGVARBINARY  BOOLEAN   NCLOBBIGINT   DECIMAL  TIME      NULL      CURSOR

<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> 

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]