懒加载

打开懒加载和激进的懒加载

  <setting name="aggressiveLazyLoading" value="true"/>
     <setting name="lazyLoadingEnabled" value="true"/>

fetchType="eager/lazy"覆盖lazyLoadingEnabled的设置

    <select id="get" parameterType="int" resultType="Job">
        SELECT *
        FROM job
                 LEFT JOIN person_job pj on job.id = pj.job_id
        WHERE person_id = #{id};
    </select>



 <select id="get" parameterType="int" resultType="IdCard">
        SELECT * FROM id_card
        Where person_id=#{id};
    </select>




   <select id="get" parameterType="int" resultType="BankCard">
        SELECT * FROM bank_card
        WHERE person_id=#{id};
    </select>



  <resultMap id="rmGet" type="Person" >
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <association property="idCard"
                     column="id"
                     select="idcard.get"
                     javaType="IdCard"/>
        <collection property="bankCards"
                    column="id"
                    fetchType="eager"
                    select="bankcard.get"
                ofType="BankCard"/>
        <collection property="jobs"
                    column="id"
                    select="job.get"
                    ofType="Job"/>
    </resultMap>
    <select id="get" parameterType="int" resultMap="rmGet" >
        SELECT * FROM person WHERE  id=#{id}
    </select>