云飞九天

鉴别器

<!--鉴别器-->

<discrimimator>相当于if判断

<resultMap id="findas" type="com.qf.bean.Student">
      <id column="userid" property="userid"></id>
      <result column="username" property="username"></result>
      <result column="sex" property="sex"></result>
      <!--鉴别器-->
      <discriminator javaType="string" column="sex">
          <case value="男" resultMap="boyh"></case>
          <case value="女" resultMap="girlh"></case>
      </discriminator>
  </resultMap>

     <resultMap id="boyh" type="com.qf.bean.BoyHealth" extends="findas">
          <collection property="boyhealths"  select="findboyid" column="userid" ></collection>
     </resultMap>
     <resultMap id="girlh" type="com.qf.bean.GirlHealth"  extends="findas">
         <collection property="girlHealths" select="findgirkid" column="userid"></collection>
     </resultMap>

    <select id="findboyid" resultType="com.qf.bean.Boy">
        select * from boy where bid=#{id}
    </select>
    <select id="findgirkid" resultType="com.qf.bean.Gril">
        select * from girl where gid=#{id}
    </select>

    <select id="findallstudent" resultMap="findas">
        select * from student
    </select>

 

posted on 2018-11-12 19:49  云飞九天  阅读(294)  评论(0编辑  收藏  举报

导航