mybatis的resultType与resultMap

mybatis的resultType与resultMap

1.resultType

表示直接的返回类型

<select id="selectByKey" resultType="com.wdhis.plugs.model.People" >
    select 
    column_1,   //对应返回的实体类为column1则对应失败返回为null
    column2,//成功
    column_3,//null
    column4,//成功
    isMan column_5//null
    from A_EXAMPLE_TABLE
  </select>

2.resultMap

对外部resultMap的引用

<resultMap id="BaseResultMap" type="com.wdhis.plugs.model.People" >
    <id column="column_1" property="column1" jdbcType="DECIMAL" />
    <result column="column_2" property="column2" jdbcType="DECIMAL" />
    <result column="column_3" property="column3" jdbcType="DECIMAL" />
    <result column="column_4" property="column4" jdbcType="VARCHAR" />
    <result column="column_5" property="column5" jdbcType="VARCHAR" />
    //column="column_1" 对应数据库的字段
    //property="column1" 对应下面select 的别名
    //jdbcType="DECIMAL" 对应数据库的数据类型
</resultMap>

<select id="selectByKey" resultMap="BaseResultMap" >
    select 
    column1,   //column1 >> property="column1"
    column2,
    column3,
    column4,
    column5
    from A_EXAMPLE_TABLE
  </select>

3.定义实体类

class People{
private BigDecimal column1;
private BigDecimal column2;
private BigDecimal column3;
private String column4;
private String column5;
}

注:
数据库字段与返回实体类字段,不能完全对应的时候,需要用resultMap来对应.