mybatis-210720-04---映射文件_select_resultMap_discriminator鉴别器

mybatis-210720-04—映射文件_select_resultMap_discriminator鉴别器

• EmployeeMapper.java
• EmployeeMapper.xml(笔记都在这儿)
• DepartmentMapper.java
• DepartmentMapper.xml
• MybatisTest.java

---

<!--
		鉴别器：
			mybatis可以使用discriminator判断某列的值，
			然后根据某列的值改变封装行为
				封装Employee：
					如果查出是女生，就把部门信息查询出来，否则不查询
					如果查出是男生，就把last_name这一列的值赋给email
-->

EmployeeMapper.java

package com.bgy.mybatis.dao;
import com.bgy.mybatis.bean.Employee;

public interface EmployeeMapper {
	
	public Employee getEmpByIdStep(Integer id);
}

---

EmployeeMapper.xml(笔记都在这儿)

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bgy.mybatis.dao.EmployeeMapper">
	
	<!--
		鉴别器：
			mybatis可以使用discriminator判断某列的值，
			然后根据某列的值改变封装行为
				封装Employee：
					如果查出是女生，就把部门信息查询出来，否则不查询
					如果查出是男生，就把last_name这一列的值赋给email
	-->
	<resultMap type="com.bgy.mybatis.bean.Employee" id="MyEmpDis">
		<id column="id" property="id"/>
		<result column="last_name" property="lastName"/>
		<result column="gender" property="gender"/>
		<result column="email" property="email"/>
		
		<!--
			javaType：列值对应的java类型
			column：指定判定的列明
		-->
		<discriminator javaType="String" column="gender">
			<!--
				0	女
				1	男
				resultMap：指定封装的结果类型
			-->
			
			<!-- 如果查出是女生，就把部门信息查询出来，否则不查询 -->
			<case value="0" resultType="com.bgy.mybatis.bean.Employee">
				<association property="dept" 
					select="com.bgy.mybatis.dao.DepartmentMapper.getDeptById"
					column="d_id">
				</association>
			</case>
			
			<!-- 如果查出是男生，就把last_name这一列的值赋给email -->
			<case value="1" resultType="com.bgy.mybatis.bean.Employee">
				<id column="id" property="id"/>
				<result column="last_name" property="lastName"/>
				<result column="gender" property="gender"/>
				<result column="last_name" property="email"/>
			</case>
		</discriminator>
	</resultMap>
	
	<select id="getEmpByIdStep" resultMap="MyEmpDis">
		select 
			* 
		from
			tbl_employee
		where 	
			id=#{id} 
	</select>
</mapper>

---

DepartmentMapper.java

package com.bgy.mybatis.dao;
import com.bgy.mybatis.bean.Department;

public interface DepartmentMapper {
	
	public Department getDeptById(Integer id);
}

---

DepartmentMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bgy.mybatis.dao.DepartmentMapper">

	<resultMap type="com.bgy.mybatis.bean.Department" id="MyDeptStep">
		<id column="id" property="id"/>
		<result column="dept_name" property="departmentName"/>
	</resultMap>
	
	<select id="getDeptById" resultMap="MyDeptStep">
		select 
			id,dept_name
		from 
			tbl_dept
		where
			id=#{id}
	</select>
		
	<!-- 不使用自定义结果映射 -->
	<!--
	<select id="getDeptById" resultType="com.bgy.mybatis.bean.Department">
		select 
			id,dept_name departmentName
		from 
			tbl_dept 
		where 
			id=#{id}
	</select>
	-->
</mapper>

---

MybatisTest.java

package com.bgy.mybatis.test;

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;

import com.bgy.mybatis.bean.Employee;
import com.bgy.mybatis.dao.EmployeeMapper;

class MybatisTest {
	
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	/**
	 * 测试discriminator鉴别器
	 * @throws IOException
	 */
	@Test
	public void test04() throws IOException{
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession sqlSession = sqlSessionFactory.openSession();
		
		try {
			EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
			Employee employee = mapper.getEmpByIdStep(8);
			
			System.out.println(employee);
		} finally {
			sqlSession.close();
		}
	}
}