//package com.tnzi;
//
//public class main {
//
//}
package com.tnzi;
 
import org.hibernate.Session;
 
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
 
import util.HibernateUtil;
 
public class Main {
 
public static void main(String[] args) {
try{
Set addSet = null;
//Employee_Business_Group employee_Business_Group = null;
Employee employee = null;
//Main mn = new Main();

employee = new Employee();
employee.setLogin_Id("2223");
employee.setEmployee_First_Name("aaaa");
employee.setEmployee_Last_Name("q");
employee.setEmployee_Status_Cd("A");
employee.setUpdate_User("Bhaskar");
employee.setGlobal_Site_Name("yahoo");
employee.setUpdate_Date(new Date());

employee = new Employee();
employee.setLogin_Id("7777");
employee.setEmployee_First_Name("tntntn");
employee.setEmployee_Last_Name("xq");
employee.setEmployee_Status_Cd("A");
employee.setUpdate_User("Bhaar");
employee.setGlobal_Site_Name("rediff");
employee.setUpdate_Date(new Date());

// for first person
addSet = new HashSet();
Employee_Business_Group employee_Business_Group = new Employee_Business_Group();
employee_Business_Group.setBusiness_Group_Id(1);
employee_Business_Group.setPrimary_Business_Group("F");
employee_Business_Group.setUpdate_User("T44444");
employee_Business_Group.setUpdate_Date(new Date());

addSet.add(employee_Business_Group);

employee_Business_Group = new Employee_Business_Group();
employee_Business_Group.setBusiness_Group_Id(2);
employee_Business_Group.setPrimary_Business_Group("B");
employee_Business_Group.setUpdate_User("T44444");
employee_Business_Group.setUpdate_Date(new Date());

addSet.add(employee_Business_Group);

employee.setEmployee_Business_Group(addSet);
System.out.println(employee);
createAndStoreEmployee(employee);

HibernateUtil.getSessionFactory().close();
}catch(Exception e){
e.printStackTrace();
}

}
 
private static void createAndStoreEmployee(Employee employee) throws Exception{

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
 
session.beginTransaction();
System.out.println(employee);
session.save(employee);
 
session.getTransaction().commit();
}

}

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
String insertStatement = "insert into Object (id, name) select oo.id, oo.name from OtherObject oo";
s.createQuery( insertStatement ).executeUpdate();
tx.commit();
session.close();