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());
	
}

vgf

学习下

代码不全

HibernateCallback callback = new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException {

String queryStr="from A a,B b where a.id=b.id";
Query query=session.createQuery(queryStr);
List result=query.list();
HashMap map = new HashMap();
map.put("total", new Integer(total));
map.put("result", result);
return map;
              }
}

service层获取map

Map map=(Map)controlImgr.getResult(参数);
List list=(List)map.get("result");
for(int i=0;i<list.size();i++){
Object[]object=(Object)list.get(i);
A a=(A)object[0];
B b=(B)object[1];
}