Mybatis xml一对多的写法

返回类

List<StudentCourses> queryStudentCourses();

package xxx.StudentCourses

@Data
public class StudentCourses {
    private String name;
    private List<String> courses;
}

<resultMap id="resultMap" type="xxx.StudentCourses">
    <result column="name" property="name" />
    <collection property="courses" ofType="string">
        <result column="course" />
    </collection>
</resultMap>

<select id="queryStudentCourses" resultMap="">
    SELECT s.name, sc.course FROM student_course sc
    JOIN student s ON(s.id = sc.student_id)
</select>