Mybatis中解决属性名和字段名不一致问题

1、问题

    private int id;
    private String name;
    private String password;

测试：

User{id=1, name='zrk', password='null'}

解决办法：

1. 起别名

    <select id="getUserById" parameterType="int" resultType="com.vekzjj.pojo.User">
        select id,name,pwd as password from mybatis.user where id = #{id}
    </select>

User{id=1, name='zrk', password='123'}

2、resultMap

结果集映射

数据库：id name pwd
实体类：id name password

<!--    结果集映射-->
    <resultMap id="UserMap" type="User">
<!--    column:数据库中的字段 property实体类中的属性 -->
        <result column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="pwd" property="password"/>
    </resultMap>


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

User{id=1, name='zrk', password='123'}