mybatis 使用association 进行嵌套查询

<!--单个参数传递-->

<resultMap id = "userMap" type = "com.common.dto.StudentVO">  <result id column = 'id' jdbcType = 'BIGINT' property = 'id'>
  <result column = 'name' jdbcType = 'VARCHAR' property = 'name'>
  <result  column = 'class' jdbcType = 'VARCHAR' property = 'score'>
 

<!-- property scoreList 为StudentVo里的属性，为score表的实体类-->

<association column = 'score_id'  property= 'scoreList'  property = 'scoreList'>

</resultMap>

<!--多个参数传递-->

<resultMap id = "scoreMap" type = "com.common.dto.StuedentVO">

  <result id column = 'id' jdbcType = 'BIGINT' property = 'id'>
  <result column = 'score' jdbcType = 'VARCHAR' property = 'score'>
  <result  column = 'subject' jdbcType = 'VARCHAR' property = 'subject'>

 <result  column = 'class_name'  jdbcType = 'VARCHAR' property = 'className'> 

<result  column = 'stu_age'  jdbcType = 'VARCHAR' property = 'queryList'>

<association column = '{stu_age=stu_age，class_name=class_name}'  property= 'scoreList'  property = 'scoreList'>

</resultMap>

<select id = 'queryList' parameterType = 'String' resultMap='userMap'>

select  score,subject from score where id=#{value}

</select>

<select id = 'scoreList' parameterType = 'String' resultMap='userMap'>

select  score,subject from score where stu_age = #{stu_age} and class_name= #{class_name}

</select>