mybatis四、解决实体类与数据库字段值不匹配的问题

@Data
public class User {
    private int id;
    private String name;
    private String password;
}

数据库中的字段
password --> pwd
resultMap结果集映射

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!--namespace绑定一个对象的Dao（Mapper）接口-->
<mapper namespace="com.xpu.mapper.UserMapper">
    <resultMap id="UserMap" type="com.xpu.pojo.User">
        <!--column数据库中的字段，property实体类中的属性-->
        <result property="password" column="pwd"/>
        <result column="name"   property="name"/>
        <result column="id" property="id"/>
    </resultMap>
    <select id="getUserById" parameterType="int" resultMap="UserMap">
        <!--select id,name,pwd as password from mybatis.user where id = #{id}-->
        select * from mybatis.user where id =#{id}
    </select>
</mapper>