鉴别器:
根据某列的值改变某列值得封装行为
形如:如果查出的是xx,则不查询
如果查出的是xx,则赋值给xx
<!--=====鉴别器的使用=======-->
<resultMap id="myDisc" type="com.yiki.Entity.Person">
<id column="pId" property="pId"/>
<result column="pname" property="pName"/>
<result column="email" property="email"/>
<!--鉴别器:【column】指定判断哪一列-->
<discriminator javaType="string" column="email">
<!--情况1 如果值为0-->
<case value="0" resultType="com.yiki.Entity.Person">
<association property="dept"
select="com.yiki.Dao.DepartmentMapper.getDeptByIdSept"
column="d_id">
</association>
</case>
<!--情况2 如果值为1-->
<case value="1" resultType="com.yiki.Entity.Person">
<id column="pId" property="pId"/>
<result column="pname" property="pName"/>
<result column="email" property="email"/>
</case>
</discriminator>
</resultMap>
<select id="getPersonAndEmpByIdDisc" resultMap="myDisc">
select * from Person where pid=#{id}
</select>
测试
@Test//测试鉴别器
public void test6() throws IOException {
start();
Person person = mapper.getPersonAndEmpByIdDisc(1);
System.out.println(person.getDept());
Person person2 = mapper.getPersonAndEmpByIdDisc(3);
System.out.println(person2);
sqlSession.close();
}