本次测试使用oracle的自带scott 模式下的emp 和 dept 表
两种方法
1、嵌套结果集
2、嵌套子查询
2>Emp.java
两种方法
1、嵌套结果集
2、嵌套子查询
1、创建与emp 和 dept 表对应的java 类
1>Dept.java
package com.briup.collecation;
import java.util.List;
import org.apache.ibatis.type.Alias;
@Alias("dept")
public class Dept {
private int deptno;
private String dname;
private String loc;
private List<Emp> emps;
public Dept() {
super();
}
public Dept(int deptno, String dname, String loc, List<Emp> emps) {
super();
this.deptno = deptno;
this.dname = dname;
this.loc = loc;
this.emps = emps;
}
public int getDeptno() {
return deptno;
}
public void setDeptno(int deptno) {
this.deptno = deptno;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
public String getLoc() {
return loc;
}
public void setLoc(String loc) {
this.loc = loc;
}
public List<Emp> getEmps() {
return emps;
}
public void setEmps(List<Emp> emps) {
this.emps = emps;
}
@Override
public String toString() {
return "Dept [deptno=" + deptno + ", dname=" + dname + ", loc=" + loc + ", emps=" + emps + "]";
}
}
2>Emp.java
package com.briup.collecation;
import java.sql.Date;
import org.apache.ibatis.type.Alias;
@Alias("emp")
public class Emp {
private int empno;
private String ename;
private String job;
private int mgr;
private Date hiredate;
private double sal;
private double comm;
private Dept deptno;
public Emp() {
super();
}
pu