MyBatis中ResultMap结果集映射

用于解决属性名和字段名不一致的情况：
resultMap 元素是 MyBatis 中最重要最强大的元素。

package com.kuang.pojo;

public class User {
  private int id;
  private String username;
  private String password;

  public User(int id, String username, String password) {
    this.id = id;
    this.username = username;
    this.password = password;
  }

    public int getId() {
        return id;
    }

    public String getUsername() {
        return username;
    }

    public String getPassword() {
        return password;
    }

    public void setId(int id) {
        this.id = id;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

<?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接口-->
<!--让这个配置文件和UserDao接口绑定-->
<mapper namespace="com.kuang.dao.UserMapper">
    <select id="getUserList" resultType="User" >
         select * from mybatis.user
    </select>

    <resultMap id="UserMap" type="User">
        <result column="id" property="id"/>
        <result column="name" property="username"/>
        <result column="pwd" property="password"/>
    </resultMap>

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