association分步查询
1.实际的开发中,对于每个实体类都应该有具体的增删改查方法,也就是DAO层, 因此对于查询部门信息并且将对应的所有的员工信息也查询出来的需求,就可以通过分步的方式完成查询。
2.先通过部门的id查询部门信息
3.再通过部门id作为员工的外键查询对应的部门信息.
代码如下:
Emp实体类
public class Emp {
private int empno;
private String ename;
private String job;
private String mge;
private Double salary;
private int dept;
private Dept dept1;
public Dept getDept1() {
return dept1;
}
public void setDept1(Dept dept1) {
this.dept1 = dept1;
}
@Override
public String toString() {
return "Emp{" +
"empno=" + empno +
", ename='" + ename + '\'' +
", job='" + job + '\'' +
", mge='" + mge + '\'' +
", salary=" + salary +
", dept1=" + dept1 +
'}';
}
public Emp() {
}
public Emp(int empno, String ename, String job, String mge, Double salary, int dept) {
this.empno = empno;
this.ename = ename;
this.job = job;
this.mge = mge;
this.salary = salary;
this.dept = dept;
}
public