thank you very much for your answer! here is the detail of my stuff.
tables:
Person: PersonID(PK), surname ,firstname,tel,email
PersonProject:PPID(PK), PersonID(FK), ProjectID(FK), roleName
Project:ProjectID(PK), name description
Java classes:
class Person {
private Long id;
private String surname;
private String firstname;
private String email;
private String telNr;
private Set persProj = new HashSet();
getter und setters
.....}
public class PersonProject {
private Long id;
private Long personID;
private Long projectID;
private String roleName;
public PersonProject(){};
getter and setters
.....}
public class Project {
private Long id;
private String name;
private String description;
private Set subProjects = new HashSet();
private Project superProject;
private Set persProj = new HashSet();
public Project(){};
getter and setters
.....}
hbm.xmls:
Person:
<class name="mapping.Person" table="TMP_PERSON">
<id name="id" column="PERSONID">
<generator class="sequence"/>
</id>
<property name="telNr" column="TEL"/>
<property name="surname" column="SURNAME"/>
<property name="firstname" column="FIRSTNAME"/>
<property name="email" column="EMAIL"/>
<set name="persProj" inverse="true" cascade="all">
<key column="PERSONID"/>
<one-to-many class="mapping.PersonProject"/>
</set>
PersonProject:
class name="mapping.PersonProject" table="TMP_PERS_PROJ">
<id name="id" column="PERSPROJID">
<generator class="sequence"/>
</id>
<property name="roleName" column="ROLENAME"/>
<many-to-one name="projectID" column="PROJECTID" class="mapping.Project"/>
<many-to-one name="personID" column="PERSONID" class="mapping.Person"/>
Project:
<class name="mapping.Project" table="TMP_PROJECT">
<id name="id" column="PROJECTID">
<generator class="sequence"/>
</id>
<property name="name" column="NAME"/>
<property name="description" column="DESCRIPTION"/>
<many-to-one name="superProject" column="SUPERPROJECTID" />
<set name="subProjects" cascade="all" inverse="true">
<key column="SUPERPROJECTID"/>
<one-to-many class="mapping.Project"/>
</set>
<set name="persProj" inverse ="true" cascade="all">
<key column="PROJECTID"/>
<one-to-many class="mapping.PersonProject"/>
</set>
</class>
my method to insert into table Pers_Proj:
protected void addPersonToProject(Person person, Project project,String roleName) {
Session session = null;
Transaction transaction = null;
session = sessionFactory.openSession();
transaction = session.beginTransaction();
PersonProject pp = new PersonProject();
pp.setPersonID(person.getId());
pp.setProjectID(project.getId());
pp.setRoleName(roleName);
session.save(pp);
session.getTransaction().commit();
session.close();
}
Login
FAQ
Search
