mybatis解决数据库字段名与实体类的属性名不一致的问题

数据库字段：

表映射的实体类：

public class User {
    private int id;
    private String name, password;
	
	.......

}

方法一：起别名

<mapper namespace="com.wen.dao.UserMapper">

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

 </mapper>

方法二：使用resultMap映射（推荐）

<mapper namespace="com.wen.dao.UserMapper">

<!--    结果集映射-->
    <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" parameterType="int" resultMap="UserMap">
        select * from mybatis.user where id=#{id}
    </select>

 </mapper>