hibernate mysql 多表查询_MVC+spring+hibernate使用注解实现多表联查时sql语句怎么写？...

员工表@Entity

@Table(name = "EMP")

public class Emp {

@Id

@Column(name = "EMPNO")

@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "emp_num")

@SequenceGenerator(name = "emp_num", sequenceName = "emp_num_id", allocationSize = 1, initialValue = 1)

private Integer empNo;

@Column(name = "EMPNAME")

private String empName;

@ManyToOne()

@JoinColumn(name = "DEPTNO")

private Dept dept;

}

部门表@Entity

@Table(name = "DEPT")

public class Dept {

@Id

@Column(name = "DEPTNO")

@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="dept_num")

@SequenceGenerator(name="dept_num",sequenceName="dept_num_no",allocationSize=1,initialValue=1)

private Integer deptNo;

@Column(name = "DEPTNAME")

private String deptName;

public Integer getDeptNo() {

return deptNo;

}

}

查询@Test

public void test(){

SessionFactory sf=new AnnotationConfiguration().configure().buildSessionFactory();

Session session = sf.openSession();

Emp emp=(Emp)session.load(Emp.class, 1);

System.out.println(emp.getEmpName()+"\t"+emp.getDept().getDeptName());

}