mybatis中collection标签的使用

看图说话

解释：

当一个查询里有对象的时候，实体映射可以用Collection标签，属性值
property实体类里的对象名，column数据库字段，ofType指实体类中select 标签返回类型，一般为map.
javaType指实体类中的对象类型，select查询语句，查询的是文本中select标签,一般为java.util.List

 <resultMap id="FollwerResultMap" type="com.reada.pojo.ReadaUser" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="createtime" property="createtime" jdbcType="TIMESTAMP" />
  
    **<collection property="**fllower**" column="id" ofType="map" javaType="java.util.List"
                select="**getFllowerByID**">**
      <id column="id" jdbcType="INTEGER" property="id" />
      <result column="user_id" jdbcType="INTEGER" property="userId" />
      <result column="user_name" jdbcType="VARCHAR" property="userName" />
      <result column="fllownum" jdbcType="INTEGER" property="fllownum" />
      <result column="funnum" jdbcType="INTEGER" property="funnum" />
      <result column="stat" jdbcType="INTEGER" property="stat" />
      <result column="rpnum" jdbcType="INTEGER" property="rpnum" />
      <result column="other" jdbcType="VARCHAR" property="other" />
      <result column="pronum" jdbcType="INTEGER" property="pronum" />
    </collection>
  </resultMap>
  =========================================================
  <select id="getFllowerByID" parameterType="Integer" resultType="map">
    SELECT
    pr.id,pr.user_id,pr.user_name,pr.fllownum,pr.funnum,pr.stat,pr.rpnum,pr.other,pr.pronum
    FROM
    RDA_UC_FLLOWER pr
    WHERE
    pr.user_id=#{id}

  </select>

实体类如下，自己分析
package com.reada.pojo;

import java.util.Date;
import java.util.List;

public class ReadaUser {
    private Integer id;

    private String username;

    private String realName;

    private String nick;

    private String gender;

    private String area;

    private String phone;

    private Date birthday;

    private String password;

    private String photo;

    private Date createtime;

    private Date updatetime;

    private String signature;

    private Date lastlogin;

    private Integer rank;

    //用户关注对象
    public List<Fllower> fllower;

    public List<Fllower> getFllower() {
        return fllower;
    }

    public void setFllower(List<Fllower> fllower) {
        this.fllower = fllower;
    }

   
}

写的少，请建议请留言，尊重原创，转载加链接