bean对应mapper.xml字段

在bean中set的时候最好写上这个，避免报空指针。。。。。。。。。。。。。。。

public void setImgAddress(String imgAddress) {
this.imgAddress = imgAddress == null ? null : imgAddress.trim();
}

Bean-------xml(javaType)
Integer ----Integer
String ---Varchar
Double(double)----Double
Date-------TIMESTAMP
long-------Integer

==========================================================================================================

MyBatis 通过包含的jdbcType类型

BIT、FLOAT、CHAR 、TIMESTAMP 、 OTHER 、UNDEFINEDTINYINT 、REAL 、VARCHAR 、BINARY 、BLOB NVARCHAR、SMALLINT 、DOUBLE 、LONGVARCHAR 、VARBINARY 、CLOB、NCHAR、INTEGER、 NUMERIC、DATE 、LONGVARBINARY 、BOOLEAN 、NCLOB、BIGINT 、DECIMAL 、TIME 、NULL、CURSOR

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

3、Mybatis中javaType和jdbcType对应关系

   JDBCType            JavaType

    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]