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

例如 我的数据库中字段名为pwd，属性名为password

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

使用resultMap

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fu.dao.UserMapper">

<resultMap id="UserMap" type="User">
<!--    <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>

</mapper>

测试

package com.fu.dao;

import com.fu.pojo.User;
import com.fu.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;


public class UserDaoTest {
    @Test
    public void getUserLike() {
        //第一步 获取sqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //第二步 执行sql
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.getUserById(2);

        System.out.println(user);

        //关闭sqlSession
        sqlSession.close();

    }
}