one_mapper.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">
- <!--
- 一对多xml
- -->
- <mapper namespace="cn.et.mybatis.lesson03.oneToMany.DeptMapper">
- <!--
- 一对多可能会出现内存溢出的风险
- 设置属性fetchType="lazy"
- fetchType="lazy" 需要加载cglib架包
- 这样一样只有用到第二种sql语句的时候才去加载,不用就不加载
- -->
- <resultMap type="cn.et.mybatis.lesson03.oneToMany.Dept" id="myDept">
- <collection column="deptno" javaType="java.util.List" property="empList"
- select="cn.et.mybatis.lesson03.oneToMany.DeptMapper.queryEmp"
- fetchType="lazy"
- ></collection>
- </resultMap>
- <select id="queryDept" resultMap="myDept">
- select * from dept where deptno=#{0}
- </select>
- <select id="queryEmp" resultType="cn.et.mybatis.lesson03.oneToMany.Emp">
- select * from emp where deptno=#{0}
- </select>
- </mapper>