I suggest you create a new entity: employees, as "person with function at company" and have a set of these in your company object rather than a set of persons.
Assuming a person can only have 1 function at a company:
Employee.java
Code:
package test.passero;
public class Employee {
private Long id;
private Person person;
private Function function;
public Employee() {}
public Employee(Person person, Function function) {
this.person = person;
this.function = function;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Person getPerson() {
return person;
}
public void setPerson(Person person) {
this.person = person;
}
public Function getFunction() {
return function;
}
public void setFunction(Function function) {
this.function = function;
}
}
Employee.hbm.xml
Code:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="test.passero">
<class name="Employee" table="passero_employee">
<id name="id">
<generator class="native"/>
</id>
<many-to-one name="person" column="person_id" not-null="true"/>
<many-to-one name="function" column="function_id" not-null="true"/>
</class>
</hibernate-mapping>
Company.java
Code:
package test.passero;
import java.util.Set;
public class Company {
private Long id;
private String name;
private Set<Employee> employees;
public Company() {}
public Company(String name) {
this.name = name;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Set<Employee> getEmployees() {
return employees;
}
public void setEmployees(Set<Employee> employees) {
this.employees = employees;
}
}
Company.hbm.xml
Code:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="test.passero">
<class name="Company" table="passero_company">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<set name="employees" cascade="all, delete-orphan">
<key column="company_id"/>
<one-to-many class="Employee"/>
</set>
</class>
</hibernate-mapping>
TestPassero.java
Code:
package test.passero;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Set;
import junit.framework.TestCase;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
public class TestPassero extends TestCase {
public void testPassero() {
createCompanies();
Session s = HibernateUtil.getSession();
s.beginTransaction();
Company redHat = (Company)s.createCriteria(Company.class)
.add(Restrictions.eq("name", "Red Hat"))
.uniqueResult();
assertNotNull(redHat);
assertNotNull(redHat.getEmployees());
assertEquals(2, redHat.getEmployees().size());
for (Iterator<Employee> iterator = redHat.getEmployees().iterator(); iterator.hasNext();) {
Employee employee = (Employee) iterator.next();
assertNotNull(employee.getFunction());
assertNotNull(employee.getPerson());
assertNotNull(employee.getPerson().getName());
if (employee.getPerson().getName().startsWith("mike")) {
assertEquals("developer", employee.getFunction().getDescription());
} else if (employee.getPerson().getName().startsWith("passero")) {
assertEquals("consultant", employee.getFunction().getDescription());
} else {
fail("unexpected employee name: "+employee.getPerson().getName());
}
}
s.getTransaction().commit();
s.close();
}
private void createCompanies() {
Session s = HibernateUtil.getSession();
s.beginTransaction();
Function director = new Function("director");
s.save(director);
Function consultant = new Function("consultant");
s.save(consultant);
Function developer = new Function("developer");
s.save(developer);
Person mike = new Person("mike");
s.save(mike);
Person passero= new Person("passero");
s.save(passero);
Company microsoft = new Company("Microsoft");
Employee mikeConsultantAtMicrosoft = new Employee(mike, consultant);
Employee passeroDirectorAtMicrosoft = new Employee(passero, director);
Set<Employee> microsoftEmployees = new HashSet<Employee>();
microsoftEmployees.add(mikeConsultantAtMicrosoft);
microsoftEmployees.add(passeroDirectorAtMicrosoft);
microsoft.setEmployees(microsoftEmployees);
s.save(microsoft);
Company redHat = new Company("Red Hat");
Employee mikeDeveloperAtRedHat = new Employee(mike, developer);
Employee passeroConsultantAtRedHat= new Employee(passero, consultant);
Set<Employee> redHatEmployees = new HashSet<Employee>();
redHatEmployees.add(mikeDeveloperAtRedHat);
redHatEmployees.add(passeroConsultantAtRedHat);
redHat.setEmployees(redHatEmployees);
s.save(redHat);
s.getTransaction().commit();
s.close();
}
}
Login
FAQ
Search
