Friday, 28 June 2013

JLab12 : Table Per Subclass Inheritance Mapping

Steps :
1. Create a Java Application with name : JLab12
2. Add JPA Capabilities
3. Copy & Edit Persistence Classes & Util classes from ALab9, as per need.
4. Copy & Edit the Client code from ALab9, as per need.

Follow the directory structure as the following image :


1. Util.java
Same as JPAUtil.java of JLab3

2. A.java
Same as ALab9

3. B.java
Same as ALab9

4. C.java
Same as ALab9

5. D.java
Same as ALab9

6. E.java
Same as ALab9

7. L12.java
package com.persistence;
import javax.persistence.*;
import com.util.Util;
public class L12 {
public static void main(String[] args) {
EntityTransaction tx = null;
try{
EntityManagerFactory sf = Util.getEMF();
EntityManager s = sf.createEntityManager();
tx = s.getTransaction();
tx.begin();
A a = new A("Abby");
s.persist(a);
B b = new B("Baby","Bingo");
s.persist(b);
C c = new C("Cathy","Cammy");
s.persist(c);
D d = new D("Diego","Dan","Dank");
s.persist(d);
E e = new E("Elly","Eve","Elise");
s.persist(e);
tx.commit();
}catch(Exception e){
e.printStackTrace();
if(tx!=null)
tx.rollback();
}
}

}

8. Table
Same as ALab9
create table A(sid int, sname char(15));
create table B(sid int, bname char(15));
create table C(sid int, cname char(15));
create table D(sid int, dname char(15));
create table E(sid int, ename char(15));

** Run As A Java Application & Choose L12 from list.

** Rows inserted In DB tables as :



No comments:

Post a Comment