mybatis递归

最新推荐文章于 2023-09-22 20:28:52 发布

权在我手

最新推荐文章于 2023-09-22 20:28:52 发布

阅读量96

点赞数

文章标签： java mybatis

本文链接：https://blog.csdn.net/weixin_44727617/article/details/117963876

版权

public class IndustrialInfo {

    private String bigType;
    private List<Map> child;
    private String bigName;

    public String getBigType() {
        return bigType;
    }

    public void setBigType(String bigType) {
        this.bigType = bigType;
    }

    public List<Map> getChild() {
        return child;
    }

    public void setChild(List<Map> child) {
        this.child = child;
    }

    public String getBigName() {
        return bigName;
    }

    public void setBigName(String bigName) {
        this.bigName = bigName;
    }
}

<resultMap id="MenuResultMap" type="com.handsmap.CS.CS_ForeignScreen.domain.IndustrialInfo">
       <result column="bigName" jdbcType="VARCHAR" property="bigName" />
       <result column="bigType" jdbcType="VARCHAR" property="bigType" />
       <collection property="child" javaType="java.util.ArrayList" ofType="map" column="{bigType=bigType}" select="selectSmallResource" ></collection>
       <!--        第一个bigType对应传进来的参数#{bigType}-->
</resultMap>

<select id="selectIndustrialResource" parameterType="map"  resultMap="MenuResultMap">
     SELECT a.bigType,b.name as bigName,c.name as smallName FROM tb_industrial_resources_info a
     LEFT JOIN tb_dic_big_resource_type b on a.bigType=b.id
     LEFT JOIN tb_dic_small_resource_type c on a.smallType=c.id
     GROUP BY a.bigType
</select>

<select id="selectSmallResource" resultType="java.util.Map">
     SELECT b.name as smallName,count(*) as number FROM tb_industrial_resources_info a
     LEFT JOIN tb_dic_small_resource_type b on a.smallType=b.id
     where a.bigType=#{bigType}
     GROUP BY a.smallType
</select>