Mybatis和数据库字段不匹配解决

<?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">
<!--namespace=绑定要给对应的Dao/mapper接口-->
<mapper namespace="com.gao.dao.UserMapper">

<!--    <select id="getUserById" parameterType="int" resultType="com.gao.pojo.User">-->
<!--        select * from mybatis.user where id = #{id};-->
<!--    </select>-->

    <!--解决实体类属性和数据库字段名冲突问题-->
        <!-- 1.resultMap去解决-->
            <!--结果集映射-->
            <resultMap id="UserMap" type="User">
            <!--只映射属性名和字段名不一样的-->
                <result column="pwd" property="password"></result>
            </resultMap>
            <select id="getUserById" resultMap="UserMap">
                select * from mybatis.user where id = #{id};
            </select>
</mapper>