resultMap 结果集映射（one to many/many to one）

1.userInfo-mapping.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="oneToMany">
    <!-- 一对多 -->
    <!-- resultMap 结果集映射 -->
    <!-- type 是数据表类型   id 是结果集映射名称
        关联查询两张表有相同的列名必须给于别名     
                如果数据库表的列名和实体类的字段名一致可以用autoMapping自动映射 
    -->
    <resultMap type="com.mybatis.pojo.UserInfo" id="userinfo" >
        <!-- 
            结果列名  填充到userinfo对应的字段上 
            column    结果集列名
            javaType  实体类的字段类型
            property  实体类字段名
         -->
        <result column="id" javaType="string" property="id" />
        <result column="name" javaType="string" property="name"/>
        <result column="password" javaType="string" property="password"/>
        <!-- collection 一对多

                property  是一的一方的orders字段名  (private List<Orders> orders)
                javaType  是一的一方的orders字段的类型 java.util.List
                select   要执行的sql语句的映射名   会自动填充到List<Orders> orders中
                column   要传人的关联的列名
                autoMapping 类型的自动映射
         -->
        <collection property="orders" javaType="list" select="queryOrdersById" column="id" >
            <!-- 
            结果列名  填充到orders对应的字段中间的泛型类( private List<Orders> orders)
            column    结果集列名
            javaType  实体类的字段类型
            property  实体类字段名
         -->
            <result column="id" javaType="string" property="id"/>
            <result column="u_id" javaType="string" property="u_id"/>
            <result column="o_count" javaType="string" property="o_count"/>
            <result column="name" javaType="string" property="name"/>
        </collection>

    </resultMap>

    <!-- 查询userinfo 使用userinfo 结果集    传人要查询的id -->
    <select id="queryUserinfoById" resultMap="userinfo" parameterType="int">
        select * from  userinfo where id =#{id} 
    </select>

    <!-- 查询orders 使用实体类包名+类名 （com.mybatis.pojo.Orders）   传人的关联的列名的类型 -->
    <select id="queryOrdersById" resultType="com.mybatis.pojo.Orders" parameterType="String" >
        select * from orders where u_id =#{id}
    </select>

</mapper>

2.orders-mapping.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="manyToOne">
    <!-- 多对一 -->
    <!-- resultMap结果集映射 -->
    <resultMap type="com.mybatis.pojo.Orders" id="orders">
        <result column="id" javaType="string" property="id"/>
        <result column="u_id" javaType="string" property="u_id"/>
        <result column="o_count" javaType="string" property="o_count"/>
        <result column="name" javaType="string" property="name"/>
        <!-- 查询出userinfo 信息填充至userinfo 字段中  javaType="com.mybatis.pojo.UserInfo" 使用id列做关联 -->
        <association property="userinfo"  javaType="com.mybatis.pojo.UserInfo" select="queryUserinfoById" column="u_id">
            <result column="id" javaType="string" property="id" />
            <result column="name" javaType="string" property="name"/>
            <result column="password" javaType="string" property="password"/>
        </association>
    </resultMap>
    <select id="queryUserinfoById" resultType="com.mybatis.pojo.UserInfo" parameterType="string">
        select * from  userinfo where id =#{id} 
    </select>
    <!-- 引用resultMap orders -->
    <select id="queryOrdersById" resultMap="orders" parameterType="int" >
        select * from orders where id =#{id}
    </select>
</mapper>

3.userinfo.java

package com.mybatis.pojo;

import java.util.List;

public class UserInfo {
    private String id      ;
    private String name     ;
    private String  password ;
    private List<Orders> orders;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
}

4.orders.java

package com.mybatis.pojo;

public class Orders {
    private String id     ;
    private String u_id   ;
    private String   o_count;
    private String name;
    private UserInfo userinfo;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getU_id() {
        return u_id;
    }
    public void setU_id(String u_id) {
        this.u_id = u_id;
    }
    public String getO_count() {
        return o_count;
    }
    public void setO_count(String o_count) {
        this.o_count = o_count;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
}