mybatis中对resultMap 做嵌套查询 多参数查询

<resultMap id="Organ" type="com.pskj.GSLZ.pojo.zfzb.Organ" >
        <result column="OR_ID" property="OR_ID" jdbcType="VARCHAR"></result>
        <result column="OR_NAME" property="OR_NAME" jdbcType="VARCHAR"></result>
        <result column="PARENT_ID" property="PARENT_ID" jdbcType="VARCHAR"></result>
        <association column="OR_ID" property="count" javaType="Integer" select="count"/>
        <collection column="OR_ID"  property="subOrgan" ofType="Organ" javaType="java.util.ArrayList" select="selectChildren"></collection>
    </resultMap>

    <!--查询一级组织架构-->
    <select id="checkList" parameterType="pd" resultMap="Organ" useCache="false">
        SELECT *
        FROM sys_organ t
        WHERE t.OR_ID = #{OR_ID} AND t.OR_STATE = ‘2‘
    </select>

    <!--查询下级组织架构-->
    <select id="selectChildren" parameterType="pd" resultMap="Organ"  useCache="false">
        SELECT *
        FROM sys_organ t WHERE t.PARENT_ID = #{OR_ID} AND t.OR_STATE = ‘2‘
    </select>

    <!--统计各支队故障数量-->
    <select id="count" parameterType="pd" resultType="Integer" useCache="false">
        SELECT IFNULL(sum(num),0) count from zfzb_subcheck zsk LEFT JOIN zfzb_equip_check zec on zec.EC_ID=zsk.EC_ID
        <where>
            zec.STATE=‘1‘
            <!--查询下级组织所有id,这是写的一个MySQL查询函数-->
            and ORGAN_ID in(SELECT OR_ID from sys_organ where OR_STATE=‘2‘ and FIND_IN_SET(OR_ID,findOrgan(#{OR_ID})))
        </where>
    </select>

上面是一个简单的示例，还有的时候我们需要传进来的参数，可以 先把这个参数隐射成结果集

<resultMap type="PersonalTrends" id="PersonalTrendsResult">
        <result property="id" column="id"/>
        <result property="userId" column="user_id"/>
        <result property="userName" column="user_name"/>
        <result property="buidingId" column="buiding_id"/>
        <result property="buidingName" column="buiding_name"/>
        <result property="trends" column="trends"/>
        <result property="likeNum" column="like_num"/>
        <result property="creatTime" column="creat_time"/>
        <result property="updateTime" column="update_time"/>
        <result property="phone" column="phone"/>
        <association property="isLike" javaType="Integer" column="{tid = id,ph = phone}" select="getIsLikeBy"></association>
    </resultMap>

<!-- photo 是mapper 传进来的参数 把 这个字段 变成返回值-->

<sql id="selectPersonalTrendsVo">
        select id, user_id, user_name, buiding_id, buiding_name, trends,like_num, creat_time, update_time ,${phone} phone from personal_trends
    </sql>

<!-- 这是主要查询方法-->

<select id="selectPersonalTrendsByBid" parameterType="java.util.Map"
            resultMap="PersonalTrendsResult">
        <include refid="selectPersonalTrendsVo"/>
        where buiding_id = #{buidingId}
        and user_id = #{userId}
        order by creat_time desc
        limit 20
    </select>

<!-- 这是resultMap 中 isLike 的查询-->

<select id="getIsLikeBy" parameterType="java.util.Map" resultType="java.lang.Integer">
        select count(id) from likes_record where trends_id = #{tid} and customer_phone = #{ph} and likes = "1"
    </select>