MyBatis实现多表联合查询resultType的返回值

< select id = "queryCarIdList" resultType = "long" >

        select id from t_car_car

</ select >

   < select id = "queryDept" resultType = "string" >

        SELECT deptname FROM t_car_run where deptid = #{deptid} GROUP BY deptname

    </ select >

< select id = "queryNumber" resultType = "io.renren.modules.generator.entity.TCarRunEntity" >

        select number from t_car_car where id = #{carid}

</ select >

< select id = "queryCar" resultType = "io.renren.modules.generator.entity.TCarCarEntity" >

        select * from t_car_car

</ select >

< select id = "queryDriver" resultType = "java.util.Map" >

        select driverid from t_car_cardriver where carid = #{id}

</ select >

// TCarCarDriver

private Long carid;

private Long driverid;

< select id = "queryDriver" resultType = "TCarCarDriver" >

        select driverid from t_car_cardriver where carid = #{id}

</ select >

< resultMap id = "chainVo" type = "com.suncnpap.intelligentqa.vo.ChainVo" >

    < id column = "cid" property = "id" />

    < result column = "access_key" property = "accessKey" />

    < result column = "secret_key" property = "secretKey" />

    < result column = "outer_chain_name" property = "outerChainName" />

    < result column = "outer_chain_document" property = "outerChainDocument" />

    < collection property = "intentionVos" ofType = "com.suncnpap.intelligentqa.vo.ChainIntentionVo"

                resultMap = "intentionVos" />

</ resultMap >

< resultMap id = "intentionVos" type = "com.suncnpap.intelligentqa.vo.ChainIntentionVo" >

    < id column = "iid" property = "id" />

    < result column = "intention_name" property = "intentionName" />

    < collection property = "questionVoList" ofType = "com.suncnpap.intelligentqa.vo.MultiQuestionVo" >

        < id column = "qid" property = "id" />

        < result column = "question" property = "question" />

    </ collection >

    < collection property = "wordVos" ofType = "com.suncnpap.intelligentqa.vo.ChainIntentionWordVo" >

        < id column = "wid" property = "id" />

        < result column = "word_slot" property = "wordSlot" />

        < result column = "word_slot_miss_question" property = "wordSlotMissQuestion" />

        < result column = "entity_type_ids" property = "entityTypeIds" />

    </ collection >

</ resultMap >

< select id = "detail" resultMap = "chainVo" >

    select tc.id   as tid,

            tci.id  as iid,

            tciw.id as wid,

            tmq.id  as qid,

            access_key,

            secret_key,

            outer_chain_name,

            outer_chain_document,

            intention_name,

            question,

            word_slot,

            word_slot_miss_question,

            entity_type_ids

    from t_chain tc

              left join t_chain_intention tci on tc.id = tci.chain_id

              left join t_chain_intention_word tciw on tci.id = tciw.intention_id

              left join t_multi_question tmq on tci.id = tmq.parent_id

    where tc.id = #{id}

      and tc.deleted = 0

</ select >