Hibernate连表查询

1.整体架构

 

 

2.所需要的jar包

 

 

3.hibernate.cfg.xml文件

 

<?xml version='1.0' encoding='utf-8'?>


<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">


<hibernate-configuration>


    <session-factory>


        <!-- Database connection settings -->
        <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
        <property name="connection.username">jack</property>
        <property name="connection.password">8888</property>


      <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>

<mapping resource="com/entity/Emp.hbm.xml"/>
<mapping resource="com/entity/Dept.hbm.xml"/>
    </session-factory>

 

</hibernate-configuration>

 

4.实体类Emp和Dept

 

Emp实体类

package com.entity;


import java.util.Date;


import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;


@Entity
@Table(name="emp")
public class Emp {


private Integer empid;
private String ename;
private String job;
private Date hiredate;
private Double sal;
private Double comm;
private Integer deptid;


public Emp() {
super();
}


public Emp(String ename, Date hiredate, Double sal) {
super();
this.ename = ename;
this.hiredate = hiredate;
this.sal = sal;
}


public Emp(String ename, String job, Date hiredate, Double sal, Double comm, Integer deptid) {
super();
this.ename = ename;
this.job = job;
this.hiredate = hiredate;
this.sal = sal;
this.comm = comm;
this.deptid = deptid;
}


public Emp(Integer empid, String ename, String job, Date hiredate,