Hibernate One to One Example using XML

Example of One to one mapping in hibernate

There are two ways to perform one to one mapping in hibernate:

By many-to-one element (using unique=”true” attribute)
By one-to-one element

Here, we are going to perform one to one mapping by one-to-one element. In such case, no foreign key is created in the primary table.

In this example, one employee can have one address and one address belongs to one employee only. Here, we are using bidirectional association. Let’s look at the persistent classes.

1) Persistent classes for one to one mapping

There are two persistent classes Employee.java and Address.java. Employee class contains Address class reference and vice versa.

Employee.java

 package com.tutoraspire;  public class Employee { private int employeeId; private String name,email; private Address address; //setters and getters } 

Address.java

 package com.tutoraspire;  public class Address { private int addressId; private String addressLine1,city,state,country; private int pincode; private Employee employee; //setters and getters } 

2) Mapping files for the persistent classes

The two mapping files are employee.hbm.xml and address.hbm.xml.

employee.hbm.xml

In this mapping file we are using one-to-one element in both the mapping files to make the one to one mapping.

 <?xml version=’1.0′ encoding=’UTF-8′?> <!DOCTYPE hibernate-mapping PUBLIC           “-//Hibernate/Hibernate Mapping DTD 5.3//EN”           “http://hibernate.sourceforge.net/hibernate-mapping-5.3.dtd”>             <hibernate-mapping>           <class name=”com.tutoraspire.Employee” table=”emp212″>           <id name=”employeeId”>           <generator class=”increment”></generator>           </id>           <property name=”name”></property>           <property name=”email”></property>                      <one-to-one name=”address” cascade=”all”></one-to-one>           </class>                      </hibernate-mapping> 

address.hbm.xml

This is the simple mapping file for the Address class. But the important thing is generator class. Here, we are using foreign generator class that depends on the Employee class primary key.

 <?xml version=’1.0′ encoding=’UTF-8′?> <!DOCTYPE hibernate-mapping PUBLIC           “-//Hibernate/Hibernate Mapping DTD 5.3//EN”           “http://hibernate.sourceforge.net/hibernate-mapping-5.3.dtd”>             <hibernate-mapping>           <class name=”com.tutoraspire.Address” table=”address212″>           <id name=”addressId”>           <generator class=”foreign”>           <param name=”property”>employee</param>           </generator>           </id>           <property name=”addressLine1″></property>           <property name=”city”></property>           <property name=”state”></property>           <property name=”country”></property>           <property name=”pincode”></property>                      <one-to-one name=”employee”></one-to-one>           </class>                      </hibernate-mapping> 

3) Configuration file

This file contains information about the database and mapping file.

hibernate.cfg.xml

  <?xml version=’1.0′ encoding=’UTF-8′?> <!DOCTYPE hibernate-configuration PUBLIC           “-//Hibernate/Hibernate Configuration DTD 5.3//EN”           “http://hibernate.sourceforge.net/hibernate-configuration-5.3.dtd”>  <hibernate-configuration>      <session-factory>         <property name=”hbm2ddl.auto”>update</property>         <property name=”dialect”>org.hibernate.dialect.Oracle9Dialect</property>         <property name=”connection.url”>jdbc:oracle:thin:@tutoraspire.com:1521:xe</property>         <property name=”connection.username”>system</property>         <property name=”connection.password”>jtp</property>         <property name=”connection.driver_class”>oracle.jdbc.driver.OracleDriver</property>     <mapping resource=”employee.hbm.xml”/>     <mapping resource=”address.hbm.xml”/>     </session-factory>  </hibernate-configuration>  

4) User classes to store and fetch the data

Store.java

 package com.tutoraspire;      import org.hibernate.*; import org.hibernate.boot.Metadata; import org.hibernate.boot.MetadataSources; import org.hibernate.boot.registry.StandardServiceRegistry; import org.hibernate.boot.registry.StandardServiceRegistryBuilder;      public class Store {   public static void main(String[] args) {        StandardServiceRegistry ssr=new StandardServiceRegistryBuilder().configure(“hibernate.cfg.xml”).build(); Metadata meta=new MetadataSources(ssr).getMetadataBuilder().build();  SessionFactory factory=meta.getSessionFactoryBuilder().build(); Session session=factory.openSession();      Transaction t=session.beginTransaction();       Employee e1=new Employee();       e1.setName(“Ravi Malik”);       e1.setEmail(“ravi@gmail.com”);              Address address1=new Address();       address1.setAddressLine1(“G-21,Lohia nagar”);       address1.setCity(“Ghaziabad”);       address1.setState(“UP”);       address1.setCountry(“India”);       address1.setPincode(201301);              e1.setAddress(address1);       address1.setEmployee(e1);              session.persist(e1);       t.commit();              session.close();       System.out.println(“success”);   }   }   

Output

Hibernate One to One Example 1 Hibernate One to One Example 2

Fetch.java

 package com.tutoraspire;    import java.util.*; import javax.persistence.TypedQuery; import org.hibernate.Session;   import org.hibernate.SessionFactory; import org.hibernate.boot.Metadata; import org.hibernate.boot.MetadataSources; import org.hibernate.boot.registry.StandardServiceRegistry; import org.hibernate.boot.registry.StandardServiceRegistryBuilder;     public class Fetch {   public static void main(String[] args) {   StandardServiceRegistry ssr=new StandardServiceRegistryBuilder().configure(“hibernate.cfg.xml”).build(); Metadata meta=new MetadataSources(ssr).getMetadataBuilder().build();  SessionFactory factory=meta.getSessionFactoryBuilder().build(); Session session=factory.openSession();            TypedQuery query=session.createQuery(“from Employee e”);       List<Employee> list=query.getResultList();              Iterator<Employee> itr=list.iterator();       while(itr.hasNext()){        Employee emp=itr.next();        System.out.println(emp.getEmployeeId()+” “+emp.getName()+” “+emp.getEmail());        Address address=emp.getAddress();        System.out.println(address.getAddressLine1()+” “+address.getCity()+” “+           address.getState()+” “+address.getCountry()+” “+address.getPincode());       }          session.close();       System.out.println(“success”);   }   }   

Output

Hibernate One to One Example 3

Download

Download this Hibernate Example

Next TopicHibernate One to One Example using Annotation

Hibernate Tutorial: One To One Mapping in Hibernate by one-to-one Example

Hibernate One to One Example using XML

1) Persistent classes for one to one mapping

Employee.java

Address.java

2) Mapping files for the persistent classes

employee.hbm.xml

address.hbm.xml

3) Configuration file

hibernate.cfg.xml

4) User classes to store and fetch the data

Store.java

Output

Fetch.java

Output

Download

Framework7 Tabs

How to add Link in Html

You may also like