Posts

Hibernate Many To Many Insert Operation

We will use following files User.java MobilePhone.java HibernateEngine.java hibernate.cfg.xml Queries CREATE TABLE MOBILE_PHONES_DATA ( PHONE_ID INT PRIMARY KEY AUTO_INCREMENT, MODEL_NUMBER INT, MODEL_NAME VARCHAR(20)); CREATE TABLE USERS_DATA ( USER_ID INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20), ADDRESS VARCHAR(35)); CREATE TABLE MOBILE_PHONES_AND_USERS_REL( MOBILE_PHONE_ID INT, MOBILE_USER_ID INT, FOREIGN KEY (MOBILE_PHONE_ID) REFERENCES MOBILE_PHONES_DATA (PHONE_ID), FOREIGN KEY (MOBILE_USER_ID) REFERENCES USERS_DATA (USER_ID)); User.java @Entity @Table(name="USERS_DATA") public class User { @Id @GeneratedValue @Column(name="USER_ID") private int id; @Column(name="NAME") private String name; @Column(name="ADDRESS") private String address; //@ManyToMany(targetEntity=MobilePhone.class,mappedBy="users") @ManyToMany(targetEntity=MobilePhone.class, cascade=CascadeType.ALL) @JoinTable(name=...
Read more

Hibernate Many to One delete Operation

// For SQL and POJO see the Many to One Insert Operation : Here import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class HibernateEngine { public static void main(String[] javaPlanet) { System.out.println(" ....... ENGINE START ............"); System.out.println(" .. MANY TO ONE ANNOTATION DELETE LESSON ..\n"); Configuration condigurationObj = new Configuration(); condigurationObj.configure("hibernate.cfg.xml"); SessionFactory factoryObj = condigurationObj.buildSessionFactory(); Session sessionObj = factoryObj.openSession(); Children childObj= (Children) sessionObj.get(Children.class, new Integer(3)); Transaction transaction=sessionObj.beginTransaction(); sessionObj.delete(childObj); transaction.commit(); System.out.println("\n....... DATA DELETED SUCCESSFULLY .........."); sessionObj.close(); factoryObj.close(); System.out.println("\n......
Read more

Hibernate Many to One Update Operation

// For SQL and POJO see the Many to One Insert Operation : Here import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class HibernateEngine { public static void main(String[] javaWorld) { System.out.println(" ....... ENGINE START ............"); System.out.println(" .. MANY TO ONE ANNOTATION UPDATE LESSON .."); Configuration condigurationObj = new Configuration(); condigurationObj.configure("hibernate.cfg.xml"); SessionFactory factoryObj = condigurationObj. buildSessionFactory (); Session sessionObj = factoryObj.openSession(); Children childObj = (Children) sessionObj.get(Children.class, new Integer(1)); childObj.setName("Nandni"); childObj.setAge(20); /* In below two line we are changing the already exist parent name*/ Parent parentObj = childObj.getParentObj(); parentObj.setName("Divya"); /* Using below three line ...
Read more

Hibernate Many To One Insert Operation

We will use following files Parent.java Children.java hibernate.cfg.xml HibernateEngine.java Queries CREATE TABLE PARENTS_DATA (PARENT_ID INT PRIMARY KEY AUTO_INCREMENT,NAME VARCHAR(20)); CREATE TABLE CHILDREN_DATA (CHILD_ID INT PRIMARY KEY AUTO_INCREMENT,NAME VARCHAR(20),AGE INT,PARENT_ID INT); Parent.java @Entity @Table(name="PARENTS_DATA") public class Parent { @Id @GeneratedValue(strategy=IDENTITY) @Column(name="PARENT_ID") private int id=0; @Column(name="NAME") private String name; @OneToMany(fetch=FetchType.LAZY, targetEntity=Children.class, cascade=CascadeType.ALL) @JoinColumn(name="PARENT_ID",referencedColumnName="PARENT_ID") private Set children; // provide set and get methods for all members }  Children.java @Entity @Table(name="CHILDREN_DATA") public class Children { @Id @GeneratedValue @Column(name="CHILD_ID") private int id; @Column(name="NAME") private String name; ...
Read more

Hibernate One to Many delete Operation

// FOR TABLE and  POJO  see the One to Many Insert Operation : Here import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class HibernateEngineDelete { public static void main(String[] javaPlanet) { System.out.println(" ....... ENGINE START ............"); System.out.println(" .. ONE TO MANY ANNOTATION DELETE LESSON ..\n"); Configuration configurationObj = new Configuration(); configurationObj.configure("hibernate.cfg.xml"); SessionFactory sessionFactoryObj = configurationObj.buildSessionFactory(); Session sessionObj = sessionFactoryObj.openSession(); Parent parentObj= (Parent) sessionObj.get(Parent.class, new Integer(101)); Transaction transaction=sessionObj.beginTransaction(); sessionObj.delete(parentObj); transaction.commit(); System.out.println("\n....... DATA DELETED SUCCESSFULLY .........."); sessionObj.close(); sessionFactoryObj.close(); S...
Read more

Hibernate One to Many update Operation

// FOR TABLE and  POJO  see the One to Many Insert Operation : Here import java.util.Set; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class HibernateEngine_Update { public static void main(String[] javaWorld) { System.out.println(" ....... ENGINE START ............"); System.out.println(" .. ONE TO MANY ANNOTATION UPDATE LESSON .."); Configuration configurationObj = new Configuration(); configurationObj.configure("hibernate.cfg.xml"); SessionFactory sessionFactoryObj = configurationObj.buildSessionFactory(); Session sessionObj = sessionFactoryObj.openSession(); Parent parentObj= (Parent) sessionObj.get(Parent.class, new Integer(101)); parentObj.setName("Sunny"); Set<Children> childrenSet=parentObj.getChildren(); for(Children child:childrenSet){ child.setName("parker"); child.setAge(20); } parentObj.setChildren(children...
Read more

Hibernate One to Many Select Operation

// FOR TABLE and  POJO  see the One to Many Insert Operation : Here import java.util.Set; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; public class HibernateEngineSelect { public static void main(String[] javaWorld) { System.out.println(" ....... ENGINE START ............"); System.out.println(" .. ONE TO MANY ANNOTATION SELECT LESSON ..\n"); Configuration config = new Configuration(); config .configure("hibernate.cfg.xml"); SessionFactory sessFact = config .buildSessionFactory(); Session sessionObj = sessFact .openSession(); Parent parentObj= (Parent) sessionObj.get(Parent.class, new Integer(101)); System.out.println("\n----------Parent Data----------"); System.out.println("Parent Id :"+parentObj.getId()); System.out.println("Parent Name : "+parentObj.getName()); System.out.println("---------------(:-)---------------\n...
Read more