package com.model;import java.util.Date;public class Student {  private Integer sno;  private String sname;  private String ssex;  private Integer sclass;  private StudentMajor studentmajor;  public Student() {    super();  }  public Student(Integer sno, String sname, String ssex, Integer sclass, StudentMajor studentmajor) {    super();    this.sno = sno;    this.sname = sname;    this.ssex = ssex;    this.sclass = sclass;    this.studentmajor = studentmajor;  }  public StudentMajor getStudentmajor() {    return studentmajor;  }  public void setStudentmajor(StudentMajor studentmajor) {    this.studentmajor = studentmajor;  }  public Integer getSno() {    return sno;  }  public void setSno(Integer sno) {    this.sno = sno;  }  public String getSname() {    return sname;  }  public void setSname(String sname) {    this.sname = sname;  }  public String getSsex() {    return ssex;  }  public void setSsex(String ssex) {    this.ssex = ssex;  }  @Override  public String toString() {    return "Student [sno=" + sno + ", sname=" + sname + ", ssex=" + ssex + ", sclass=" + sclass + ", studentmajor="        + studentmajor + "]";  }  public Integer getSclass() {    return sclass;  }  public void setSclass(Integer sclass) {    this.sclass = sclass;  }}

package com.model;import java.util.List;public class StudentMajor {  private Integer id;  private String mcode;  private String mname;  private List<Student> students;  public StudentMajor() {    super();  }  public StudentMajor(Integer id, String mcode, String mname, List<Student> students) {    super();    this.id = id;    this.mcode = mcode;    this.mname = mname;    this.students = students;  }  @Override  public String toString() {    return "StudentMajor [id=" + id + ", mcode=" + mcode + ", mname=" + mname + ", students=" + students + "]";  }  public Integer getId() {    return id;  }  public void setId(Integer id) {    this.id = id;  }  public String getMcode() {    return mcode;  }  public void setMcode(String mcode) {    this.mcode = mcode;  }  public String getMname() {    return mname;  }  public void setMname(String mname) {    this.mname = mname;  }  public List<Student> getStudents() {    return students;  }  public void setStudents(List<Student> students) {    this.students = students;  }}

package com.dao;import java.util.List;import java.util.Map;import com.model.Student;public interface StudentMapper {  /**   * 全表查詢   */  public List<Student> selectall();　　/**   * 根據(jù)專業(yè)查人員,給一對(duì)多用   */  public List<Student> selectz(Integer major);}

package com.dao;import java.util.List;import com.model.StudentMajor;public interface StudentMajorMapper {  /**   * 全表查詢   * @return   */  public List<StudentMajor> selectAll();  /**   * 根據(jù)主鍵查數(shù)據(jù),給多對(duì)一用   * @param id   * @return   */  public StudentMajor select(Integer id);}

<?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"> <mapper namespace="com.dao.StudentMapper">  <!-- 多對(duì)一查詢 -->  <resultMap type="Student" id="slist">    <!-- 跟一對(duì)一一樣用association標(biāo)簽,實(shí)體類定義的成員,要跟數(shù)據(jù)庫(kù)字段名對(duì)應(yīng)上 -->    <association property="studentmajor" column="major"     select="com.dao.StudentMajorMapper.select"/> <!-- 用接口里定義的方法，根據(jù)student表中的major字段查出對(duì)應(yīng)數(shù)據(jù) -->  </resultMap>  <!-- 查全部 -->  <select id="selectall" resultMap="slist" >    select * from student  </select>  <!-- 根據(jù)專業(yè)查人員 -->  <select id="selectz" parameterType="Integer" resultType="student">    select * from student s where s.major=#{major}  </select> </mapper>

<?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"> <mapper namespace="com.dao.StudentMajorMapper">   <!-- 一對(duì)多查詢關(guān)聯(lián) -->   <resultMap type="StudentMajor" id="slist">     <!-- 實(shí)體類屬性對(duì)應(yīng)數(shù)據(jù)庫(kù)的主鍵字段，不然主鍵會(huì)查不到 -->     <id property="id" column="id"/>     <!-- 用collection標(biāo)簽 ,也是實(shí)體類屬性要對(duì)應(yīng)數(shù)據(jù)庫(kù)字段-->     <collection property="students" column="id"     select="com.dao.StudentMapper.selectz">     </collection>     </resultMap>   <!-- 全表查詢 -->   <select id="selectAll" resultMap="slist">     select * from studentmajor   </select>   <!-- 根據(jù)主鍵查 -->   <select id="select" parameterType="Integer" resultType="StudentMajor">     select * from studentmajor where id=#{id}   </select> </mapper>

package com.util;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.junit.After;import org.junit.Before;import org.junit.Test;import com.dao.StudentMajorMapper;import com.dao.StudentMapper;import com.model.Student;import com.model.StudentMajor;public class JJJtest {  private SqlSession ss;  private StudentMapper sm;  private StudentMajorMapper smm;  @Before  public void setUp() throws Exception {    ss=SqlSessionUtil.getSqlSession();    sm=ss.getMapper(StudentMapper.class);    smm=ss.getMapper(StudentMajorMapper.class);  }  @After  public void tearDown() throws Exception {    ss.commit();    ss.close();  }  //一對(duì)多查詢  public void test() {    List<StudentMajor> list=smm.selectAll();    for(StudentMajor a:list){      System.out.println(a);    }  }  //根據(jù)專業(yè)查人員，給一對(duì)多用  public void selectz(){    List<Student> l=sm.selectz(3);    for(Student a:l){      System.out.println(a);    }  }  //多對(duì)一查詢  @Test  public void selectall() {    List<Student> st=sm.selectall();    for(Student tt:st){      System.out.println(tt);    }  }  //根據(jù)主鍵查詢，給多對(duì)一用  public void select(){    StudentMajor a=smm.select(1);    System.out.println(a);  }}