HIBERNATE 4U: Hibernate Mapping Many-to-One using Annotations

In this example you will learn how to map many-to-one relationship using Hibernate Annotations. Consider the following relationship between Student and Address entity.

According to the relationship many students can have the same address.
To create this relationship you need to have a STUDENT and ADDRESS table. The relational model is shown below.

To create the STUDENT and ADDRESS table you need to create the following Java classes with hibernate annotations.
Student class is used to create the STUDENT table.

package com.vaannila.student;
 
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
 
@Entity
@Table(name = "STUDENT")
public  class Student {
 
    private long  studentId;
    private String  studentName;
    private Address  studentAddress;
 
    public Student()  {
    }
 
    public Student(String  studentName, Address studentAddress) {
        this.studentName  = studentName;
        this.studentAddress =  studentAddress;
    }
 
    @Id
    @GeneratedValue
    @Column(name  = "STUDENT_ID")
    public long  getStudentId() {
        return this.studentId;
    }
 
    public void  setStudentId(long  studentId) {
        this.studentId  = studentId;
    }
 
    @Column(name  = "STUDENT_NAME",  nullable = false,  length = 100)
    public String  getStudentName() {
        return this.studentName;
    }
 
    public void  setStudentName(String studentName) {
        this.studentName  = studentName;
    }
 
    @ManyToOne(cascade  = CascadeType.ALL)
    public Address  getStudentAddress() {
        return this.studentAddress;
    }
 
    public void  setStudentAddress(Address studentAddress) {
        this.studentAddress  = studentAddress;
    }
 
}

The @ManyToOne annotation is used to create the many-to-one relationship between the Student and Address entities. The cascade option is used to cascade the required operations to the associated entity. If the cascade option is set to CascadeType.ALL then all the operations will be cascaded. For instance when you save a Student object, the associated Address object will also be saved automatically.
Address class is used to create the ADDRESS table.

package com.vaannila.student;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
 
@Entity
@Table(name = "ADDRESS")
public  class Address {
 
    private long  addressId;
    private String  street;
    private String city;
    private String  state;
    private String zipcode;
 
    public Address()  {
    }
 
    public Address(String  street, String city, String state, String zipcode) {
        this.street  = street;
        this.city = city;
        this.state  = state;
        this.zipcode = zipcode;
    }
 
    @Id
    @GeneratedValue
    @Column(name  = "ADDRESS_ID")
    public long  getAddressId() {
        return this.addressId;
    }
 
    public void  setAddressId(long  addressId) {
        this.addressId  = addressId;
    }
     
    @Column(name  = "ADDRESS_STREET", nullable = false, length=250)
    public String getStreet() {
        return this.street;
    }
 
    public void  setStreet(String street) {
        this.street  = street;
    }
 
    @Column(name  = "ADDRESS_CITY",  nullable = false,  length=50)
    public String  getCity() {
        return this.city;
    }
 
    public void  setCity(String city) {
        this.city  = city;
    }
 
    @Column(name  = "ADDRESS_STATE",  nullable = false,  length=50)
    public String  getState() {
        return this.state;
    }
 
    public void  setState(String state) {
        this.state  = state;
    }
 
    @Column(name  = "ADDRESS_ZIPCODE", nullable = false, length=10)
    public String getZipcode() {
        return this.zipcode;
    }
 
    public void  setZipcode(String zipcode) {
        this.zipcode  = zipcode;
    }
 
}

Now create the hibernate configuration file with the Student and Address class mapping.

"1.0" encoding="UTF-8"?>

        "-//Hibernate/Hibernate  Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

    
        "hibernate.connection.driver_class"> org.hsqldb.jdbcDriver
        "hibernate.connection.url">  jdbc:hsqldb:hsql://localhost
        "hibernate.connection.username">sa
        "connection.password">
        "connection.pool_size">1
        "hibernate.dialect">  org.hibernate.dialect.HSQLDialect
        "show_sql">true
        "hbm2ddl.auto">create
        class="com.vaannila.student.Student" />
        class="com.vaannila.student.Address" />
    


Create the Main class to run the example.

package com.vaannila.student;
 
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
 
import com.vaannila.util.HibernateUtil;
 
public class Main {
 
    public static  void main(String[]  args) {
        Session session =  HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = null;
        try {
            transaction =  session.beginTransaction();
            Address  address = new Address("OMR Road", "Chennai", "TN", "600097");
            //By using  cascade=all option the address need not be saved explicitly when the  student object is persisted the address will be automatically saved.
            //session.save(address);
            Student  student1 = new Student("Eswar", address);
            Student  student2 = new Student("Joe", address);
            session.save(student1);
            session.save(student2);
            transaction.commit();
        } catch  (HibernateException e) {
            transaction.rollback();
            e.printStackTrace();
        } finally  {
            session.close();
        }
 
    }
 
}

On executing the Main class you will see the following output.
The Student table has two records.

The Address table has one record.

Both the student records points to the same address record, this illustrates the many-to-one mapping.
The folder structure of the example is shown below.

Hibernate Mapping Many-to-One using Annotations

Total Pageviews

Pages

Search This blog