resultMap解决库表列名与实体类属性名不对应情况

表user

列名

id

name

pwd

实体类User

属性名

id

name

password

Mapper.xml

<?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.shuo.dao.UserDao">

   <resultMap id="UserMap" type="com.shuo.pojo.User">
      <result column="id" property="id"></result>
      <result column="name" property="name"></result>
      <result column="pwd" property="password"></result>
   </resultMap>

   <select id="getUserList" resultMap="UserMap">
      select * from user
   </select>

</mapper>

相当于

<select id="getUserList" resultType="com.shuo.pojo.User">

select id as id,name as name,pwd as password from user

</select>