对集合类型属性的实体类的查询集的封装

对集合类型属性的实体类的查询集的封装

实体类

public class Student {
    private int id;
    private String name;
    private String sex;
    //学生和学科的一对多关系
    private List subjectList;

其映射.xml文件

<?xml version="1.0" encoding="UTF-8" ?>



    
      
          
        
        
        
           
          
         
              
            
            
            
        
    

    
    
    
        select st.id,st.name,st.sex,su.id as subject_id,su.name as subject_name,su.grade
        from t_studuent st
        inner join t_student_subject tss 
        on st.id=tss.student_id
        inner join t_subject su on tss.subject_id=su.id
        where st.name=#{name}
    

实例联系