Hibernate Table per subclass:
Three tables are required. The two subclass tables have primary key associations to the superclass table so the relational model is actually a one-to-one association.
Mapping
Book.hbm
<?xml version="1.0" encoding="utf-8" ?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping> <class name="com.candidjava.hibernate.Book" table="Book_Sub"> <id name="id" type="int" column="id"> <generator class="increment"/> </id> <property name="title" type="string" column="title"/> <property name="author" type="string" column="author"/> <property name="cost" type="double" column="cost"/> <joined-subclass name="com.candidjava.hibernate.SpecialEditionBook" table="Special_Sub"> <key column="id"/> <property name="newfeatures" type="string" column="features"/> </joined-subclass> <joined-subclass name="com.candidjava.hibernate.InternationalBook" table="International_sub"> <key column="id"/> <property name="languages" type="string" column="languages"/> <property name="region" type="int" column="region"/> </joined-subclass> </class> </hibernate-mapping>
Inserting record into Table per subclass
public void insertBook(Book bk) { try { Session s = getSession(); Transaction transaction = s.beginTransaction(); s.save(bk); transaction.commit(); } catch (HibernateException e) { e.printStackTrace(); } }
BookDao m=new BookDao(); Book bk=new Book(); bk.setAuthor("raman"); bk.setCost(60); bk.setTitle("mysql"); InternationalBook ib=new InternationalBook(); ib.setAuthor("Candid"); ib.setCost(70); ib.setTitle("mysql"); ib.setLanguages("english"); ib.setRegion(12); SpecialEditionBook sb=new SpecialEditionBook(); sb.setAuthor("surendar"); sb.setCost(90); sb.setTitle("j2ee"); sb.setNewfeatures("angular"); m.insertBook(bk); m.insertBook(ib); m.insertBook(sb);
Retrieving or getting record from Table per subclass
public Book getBook(int id) { Book sd = null; try { Session s = getSession(); sd = (Book) s.get(Book.class, id); } catch (HibernateException e) { System.out.println(e.getMessage()); } return sd; }
BookDao ms=new BookDao(); Book b=ms.getBook(2); System.out.println(b.getAuthor()); System.out.println(b.getTitle()); System.out.println(b.getCost()); if(b instanceof InternationalBook) { InternationalBook ib=(InternationalBook) b; System.out.println(ib.getLanguages()); System.out.println(ib.getRegion()); } if(b instanceof SpecialEditionBook) { SpecialEditionBook sb=(SpecialEditionBook) b; System.out.println(sb.getNewfeatures()); }
POJO
Book.java
package com.candidjava.hibernate; public class Book { int id; String title; String author; double cost; public Book() { } public Book(String title, String author, double cost) { this.title = title; this.author = author; this.cost = cost; } public void setId(int id) { this.id = id; } public int getId() { return id; } public void setTitle(String title) { this.title = title; } public String getTitle() { return title; } public void setAuthor(String author) { this.author = author; } public String getAuthor() { return author; } public void setCost(double cost) { this.cost = cost; } public double getCost() { return cost; } }
International Book
InternationalBook.java
package com.candidjava.hibernate; public class InternationalBook extends Book { private String languages; private int region; public InternationalBook() { } public InternationalBook(String title, String author, double cost, String language, int region) { super(title, author, cost); languages = language; this.region = region; } public void setLanguages(String s) { languages = s; } public String getLanguages() { return languages; } public void setRegion(int i) { region = i; } public int getRegion() { return region; } }
Special Edition Book
SpecialEditionBook.java
package com.candidjava.hibernate; public class SpecialEditionBook extends Book { private String newfeatures; public SpecialEditionBook() { } public SpecialEditionBook(String title, String author, double cost, String features) { super(title, author, cost); newfeatures = features; } public void setNewfeatures(String s) { newfeatures = s; } public String getNewfeatures() { return newfeatures; } }
Download
Table per sub class war table per sub class zip