Guest User

Hibernate Application

a guest
Sep 20th, 2012
331
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.12 KB | None | 0 0
  1. package com.jayan;
  2.  
  3. import java.util.Iterator;
  4. import java.util.List;
  5. import org.hibernate.Session;
  6. import org.hibernate.Transaction;
  7.  
  8. public class Test {
  9.  
  10.  public static void main(String[] args) {  
  11.   Test tst = new Test();  
  12.   //adding records
  13.   tst.addUser("Jayan", "Rukmal");
  14.   tst.addUser("Shashika", "Jaya");  
  15.   tst.addTask(1, "Email", "Send birthday wish to Pubudu");
  16.   tst.addTask(2, "SMS", "Send message to Dad");  
  17.    
  18.   //  retrieving data  
  19.   tst.getFullName("Saranga");
  20.    
  21.   // full updating records  
  22.   User user = new User();
  23.   user.setId(1);
  24.   user.setFirstName("Jayan");
  25.   user.setLastName("withanage");
  26.   tst.updateUser(user);
  27.    
  28.   //partial updating records  
  29.   tst.updateLastName(2, "Pradeep");
  30.  
  31.   //deleting records  
  32.   User user1 = new User();
  33.   user1.setId(2);
  34.   tst.deleteUser(user1);
  35.  }
  36.  
  37.  private void addUser(String firstName, String lastName) {
  38.    
  39.   Transaction trns = null;
  40.   Session session = Hibernate.getSessionFactory().openSession();
  41.   try {
  42.    trns = session.beginTransaction();
  43.    
  44.    User user = new User();
  45.    
  46.    user.setFirstName(firstName);
  47.    user.setLastName(lastName);
  48.    
  49.    session.save(user);
  50.    
  51.    session.getTransaction().commit();
  52.   } catch (RuntimeException e) {
  53.    if(trns != null){
  54.     trns.rollback();
  55.    }
  56.    e.printStackTrace();
  57.   } finally{
  58.    session.flush();
  59.    session.close();
  60.   }
  61.  }
  62.  
  63.  private void addTask(int userID, String title, String description) {
  64.    
  65.   Transaction trns = null;
  66.   Session session = Hibernate.getSessionFactory().openSession();
  67.   try {
  68.    trns = session.beginTransaction();
  69.    
  70.    Task task = new Task();
  71.    
  72.    task.setUserID(userID);
  73.    task.setTitle(title);
  74.  
  75.    
  76.    session.save(task);
  77.    
  78.    session.getTransaction().commit();
  79.   } catch (RuntimeException e) {
  80.    if(trns != null){
  81.     trns.rollback();
  82.    }
  83.    e.printStackTrace();
  84.   } finally{
  85.    session.flush();
  86.    session.close();
  87.   }
  88.  }
  89.  
  90.  private void updateLastName(int id, String lastName) {
  91.   Transaction trns = null;
  92.   Session session = Hibernate.getSessionFactory().openSession();
  93.   try {
  94.    trns = session.beginTransaction();
  95.    String hqlUpdate = "update User u set u.lastName = :newLastName where u.id = :oldId";
  96.    int updatedEntities = session.createQuery( hqlUpdate )
  97.    .setString( "newLastName", lastName )
  98.    .setInteger( "oldId", id )
  99.    .executeUpdate();
  100.  
  101.    trns.commit();
  102.   } catch (RuntimeException e) {
  103.    if(trns != null){
  104.     trns.rollback();
  105.    }
  106.    e.printStackTrace();
  107.   } finally{
  108.    session.flush();
  109.    session.close();
  110.   }
  111.    
  112.  }
  113.  
  114.  private void updateUser(User user) {
  115.   Transaction trns = null;
  116.   Session session = Hibernate.getSessionFactory().openSession();
  117.   try {
  118.    trns = session.beginTransaction();
  119.    
  120.    session.update(user);
  121.  
  122.    session.getTransaction().commit();
  123.   } catch (RuntimeException e) {
  124.    if(trns != null){
  125.     trns.rollback();
  126.    }
  127.    e.printStackTrace();
  128.   } finally{
  129.    session.flush();
  130.    session.close();
  131.   }
  132.  }
  133.  
  134.  private void getFullName(String firstName) {
  135.   Transaction trns = null;
  136.   Session session = Hibernate.getSessionFactory().openSession();
  137.   try {
  138.    trns = session.beginTransaction();
  139.    List<User> users = session.createQuery("from User as u where u.firstName = :firstName")
  140.    .setString( "firstName", firstName )
  141.    .list();
  142.    for (Iterator<User> iter = users.iterator(); iter.hasNext();) {
  143.     User user = iter.next();
  144.     System.out.println(user.getFirstName() +" " + user.getLastName());
  145.    }
  146.    trns.commit();
  147.   } catch (RuntimeException e) {
  148.    if(trns != null){
  149.     trns.rollback();
  150.    }
  151.    e.printStackTrace();
  152.   } finally{
  153.    session.flush();
  154.    session.close();
  155.   }
  156.  }
  157.  
  158.  private void deleteUser(User user) {
  159.   Transaction trns = null;
  160.   Session session = Hibernate.getSessionFactory().openSession();
  161.   try {
  162.    trns = session.beginTransaction();
  163.    
  164.    session.delete(user);
  165.  
  166.    session.getTransaction().commit();
  167.   } catch (RuntimeException e) {
  168.    if(trns != null){
  169.     trns.rollback();
  170.    }
  171.    e.printStackTrace();
  172.   } finally{
  173.    session.flush();
  174.    session.close();
  175.   }
  176.  }
  177. }
Advertisement
Add Comment
Please, Sign In to add comment