resultMap结果集映射

需要解决的问题

实体属性名与数据库字段名不一致  比如密码,数据库用age  实体属性是ageee

解决办法1:修改sql语句  用as来变换

    <select id="getUserId" resultType="User" parameterType="int" >
        select id,name,age as ageee  from mybatis.user where id =#{id}
    </select>

解决办法2:结果集映射(映射前后不同的就行)

    <resultMap id="UserMap" type="User">
        <result column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="age" property="ageee"/>
    </resultMap>


    <select id="getUserId" resultMap="UserMap" parameterType="int" >
        select * from mybatis.user where id =#{id}
        
    </select>