MyBatis的分步查询

// 分步查询的优点:
    可以实现延迟加载，但是必须在核心配置文件中设置全局配置信息: lazyLoadingEnabled:延迟加载的全局开关。当开启时，所有关联对象都会延迟加载
aggressiveLazyLoading:当开启时，任何方法的调用都会加载该对象的所有属性。 否则，每个属性会按需加载
此时就可以实现按需加载，获取的数据是什么，就只会执行相应的sql。此时可通过association和collection中的fetchType属性设置当前的分步查询是否使用延迟加载，fetchType="lazy(延迟加 载)|eager(立即加载)" 
<settings>
  <!--开启延迟加载-->
  <setting name="lazyLoadingEnabled" value="true"/>
  <setting name="aggressiveLazyLoading" value="false"/>
</settings>

代码示例

//测试实体类
public class ClazzTest {
    private Integer id;	//班级id
    private String clazzName;//班级名称
    private List<Student> studentList;//班级学生信息
}
@Test
public void testCRUD() throws IOException {

  SqlSession sqlSession = getSqlSession();
  StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);

  //一对多查询,分布查询
  //第一步：根据班级id查询班级信息
  ClazzTest clazzById = mapper.getClazzById(1);
  //当只获取班级信息，则只执行第一步查询
  System.out.println("班级信息："+clazzById.getClazzName());
  //当获取班级下的学生信息时，才进行第二步查询
  List<Student> studentList = clazzById.getStudentList();
  studentList.forEach(System.out::println);
}
/**
     * 分步查询第一步，根据id查询班级信息
     *
     * @param id 班级id
     */
ClazzTest getClazzById(@Param("id") Integer id);
	<!--结果集-->
    <resultMap id="clazzToStudentTwo" type="ClazzTest">
        <id property="id" column="id"/>
        <result property="clazzName" column="clazzName"/>
        <collection property="studentList"
                    select="com.xyz.mybatis.mapper.StudentMapper.getStudentByClazzId"
                    column="id"
                    fetchType="lazy">
        </collection>
    </resultMap>
    <!--分布查询：第一步-->
    <select id="getClazzById" resultMap="clazzToStudentTwo">
        SELECT * FROM demo1.clazz c
        WHERE id = #{id}
    </select>
/**
     * 分步查询第二步,根据班级id查询班级的学生
     *
     * @param clazzId 班级id
     */
List<Student> getStudentByClazzId(@Param("clazzId") Integer clazzId);
    <!--分布查询：第二步-->
    <select id="getStudentByClazzId" resultType="Student">
        SELECT * FROM demo1.student
        WHERE clazzId = #{clazzId}
    </select>

运行结果

[12:49:23.028] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getClazzById] [==>  Preparing: SELECT * FROM demo1.clazz c WHERE id = ?]
[12:49:23.063] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getClazzById] [==> Parameters: 1(Integer)]
[12:49:23.159] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getClazzById] [<==      Total: 1]
班级信息：高三1班
[12:49:23.160] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getStudentByClazzId] [==>  Preparing: SELECT * FROM demo1.student WHERE clazzId = ?]
[12:49:23.161] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getStudentByClazzId] [==> Parameters: 1(Integer)]
[12:49:23.164] [DEBUG] [main] [com.xyz.mybatis.mapper.StudentMapper.getStudentByClazzId] [<==      Total: 5]
Student{id=1, name='唐子尘', age=24, address='中国', clazzId=1, clazz=null}
Student{id=8, name='唐三', age=20, address='斗罗大陆', clazzId=1, clazz=null}
Student{id=20, name='韩立', age=23, address='地球', clazzId=1, clazz=null}
Student{id=25, name='王宝乐', age=18, address='地球', clazzId=1, clazz=null}
Student{id=28, name='周元', age=23, address='地球', clazzId=1, clazz=null}