oracle mybatis 一对多对多

古城微笑少年丶 2022-12-06 01:18 191阅读 0赞

<resultMap id="BaseResultMap" type="com.dzhjj.dzhjjapi.entity.oracleentity.TbSpecialT">
         <id column="tid" property="tid" jdbcType="VARCHAR"></id>
         <result column="t_name" property="t_name" jdbcType="VARCHAR"></result>
         <result column="t_banner" property="t_banner" jdbcType="VARCHAR"></result>
         <result column="tcreate_time" property="create_time" jdbcType="VARCHAR"></result>
         <result column="tupdate_time" property="update_time" jdbcType="VARCHAR"></result>
         <result column="type" property="type" jdbcType="VARCHAR"></result>
         <result column="t_url" property="t_url" jdbcType="VARCHAR"></result>
            
            <collection property="specialSList" resultMap="templateListResp"/>
        </resultMap>
    
        <resultMap id="templateListResp" type="com.dzhjj.dzhjjapi.entity.oracleentity.TbSpecialS">
            <id column="sid" property="sid" jdbcType="VARCHAR"></id>
            <result column="stid" property="tid" jdbcType="VARCHAR"></result>
            <result column="vidoe_url" property="vidoe_url" jdbcType="VARCHAR"></result>
            <result column="supdate_time" property="update_time" jdbcType="VARCHAR"></result>
            <collection property="specialAList" ofType="com.dzhjj.dzhjjapi.entity.oracleentity.TbSpecialA">
                <id column="aid" property="aid" jdbcType="VARCHAR"></id>
                <result column="asid" property="sid" jdbcType="VARCHAR"></result>
                <result column="prodoct_code" property="prodoct_code" jdbcType="VARCHAR"></result>
                <result column="prodoct_sort" property="prodoct_sort" jdbcType="VARCHAR"></result>
                <result column="prodoct_type" property="prodoct_type" jdbcType="VARCHAR"></result>
                <result column="new_issue" property="new_issue" jdbcType="VARCHAR"></result>
                <result column="income_range" property="income_range" jdbcType="VARCHAR"></result>
                <result column="prodoct_label" property="prodoct_label" jdbcType="VARCHAR"></result>
                <result column="jump_url" property="jump_url" jdbcType="VARCHAR"></result>
                <result column="btn_copy" property="btn_copy" jdbcType="VARCHAR"></result>
            </collection>
        </resultMap>
    
    
    
     <select id="selectSpecialByTid" parameterType="map" resultMap="BaseResultMap">
        SELECT
    	t.tid,
    	t.t_name,
    	t.t_banner,
    	t.create_time as tcreate_time,
    	t.update_time as tupdate_time,
    -- t.is_delete,
    	t.type,
    	t.t_url,
    	s.sid,
    	s.tid as stid,
    	s.vidoe_url,
    	s.img_url,
    -- s.create_time,
    	s.update_time as supdate_time,
    --s.is_delete,
    	a.aid,
    	a.sid asid,
    	a.prodoct_code,
    	a.prodoct_sort,
    	a.prodoct_type,
    	a.new_issue,
    	a.income_range,
    	a.prodoct_label,
    	a.jump_url,
    	a.btn_copy
    --	a.create_time,
    --a.update_time,
    --a.is_delete
    	from DZHMONITOR.TB_SPECIAL_A  a
    	left join DZHMONITOR.TB_SPECIAL_S  s
    	on a.SID = s.SID  
    	left join DZHMONITOR.TB_SPECIAL_T t
        on s.TID  = t.tid where a.IS_DELETE = '0' and s.IS_DELETE = '0' and t.IS_DELETE = '0' and t.tid = #{tid} order by a.prodoct_sort asc
      </select>