Example usage for org.hibernate Session load

Introduction

In this page you can find the example usage for org.hibernate Session load.

Prototype

void load(Object object, Serializable id);

Source Link

Document

Read the persistent state associated with the given identifier into the given transient instance.

Usage

From source file:com.icesoft.icefaces.tutorial.crud.hibernate.RegisterManager.java

License:Apache License

/**
 * Listener for the remove course button click action.
 * @param ActionEvent click action event.
 */// ww  w. jav a 2  s  .  c  om
public void removeCourseFromStudent() {
    if (courseIdToRemoveFromStudent < 0) {
        return;
    }

    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();

    currentStudent = (Student) session.get(Student.class, currentStudent.getStudentId());
    Course removeCourse = (Course) session.load(Course.class, courseIdToRemoveFromStudent);

    currentStudent.getCourses().remove(removeCourse);
    removeCourse.getStudents().remove(currentStudent);
    // Or persist removeCourse. Either way cascades.
    session.persist(currentStudent);
    setStudentCourses();

    session.getTransaction().commit();

    courseIdToRemoveFromStudent = -1;
}

From source file:com.ikon.dao.AuthDAO.java

License:Open Source License

/**
 * Delete user from database//from w  w  w .j  av  a 2  s  .  co m
 */
@SuppressWarnings("unchecked")
public static void deleteUser(String usrId) throws DatabaseException {
    log.debug("deleteUser({})", usrId);
    String qsMail = "delete from MailAccount ma where ma.user=:user";
    String qsTwitter = "delete from TwitterAccount ta where ta.user=:user";
    String qsBookmark = "delete from Bookmark bm where bm.user=:user";
    String qsConfig = "delete from UserConfig uc where uc.user=:user";
    String qsItems = "delete from UserItems ui where ui.user=:user";
    String qsSharedQuery = "from QueryParams qp where :user in elements(qp.shared)";
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        User user = (User) session.load(User.class, usrId);
        session.delete(user);

        Query qMail = session.createQuery(qsMail);
        qMail.setString("user", usrId);
        qMail.executeUpdate();

        Query qTwitter = session.createQuery(qsTwitter);
        qTwitter.setString("user", usrId);
        qTwitter.executeUpdate();

        Query qBookmark = session.createQuery(qsBookmark);
        qBookmark.setString("user", usrId);
        qBookmark.executeUpdate();

        Query qConfig = session.createQuery(qsConfig);
        qConfig.setString("user", usrId);
        qConfig.executeUpdate();

        Query qItems = session.createQuery(qsItems);
        qItems.setString("user", usrId);
        qItems.executeUpdate();

        Query qSharedQuery = session.createQuery(qsSharedQuery);
        qSharedQuery.setString("user", usrId);
        for (QueryParams qp : (List<QueryParams>) qSharedQuery.list()) {
            qp.getShared().remove(usrId);
            session.update(qp);
        }

        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("deleteUser: void");
}

From source file:com.ikon.dao.AuthDAO.java

License:Open Source License

/**
 * Delete role from database/*w w w .j a va 2s .c  o m*/
 */
public static void deleteRole(String rolId) throws DatabaseException {
    log.debug("deleteRole({})", rolId);
    String qs = "delete from ikon_USER_ROLE where UR_ROLE=:rolId";
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Role role = (Role) session.load(Role.class, rolId);
        session.delete(role);

        // TODO: Make Hibernate handle this relation.
        SQLQuery q = session.createSQLQuery(qs);
        q.setString("rolId", rolId);
        q.executeUpdate();

        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("deleteRole: void");
}

From source file:com.ikon.dao.AuthDAO.java

License:Open Source License

/**
 * Grant role to user//from  www  .java 2 s . c o m
 */
public static void grantRole(String usrId, String rolId) throws DatabaseException {
    log.debug("grantRole({}, {})", usrId, rolId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        User user = (User) session.load(User.class, usrId);
        Role role = (Role) session.load(Role.class, rolId);
        user.getRoles().add(role);
        session.update(user);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("grantRole: void");
}

From source file:com.ikon.dao.AuthDAO.java

License:Open Source License

/**
 * Revoke role from user// w ww . ja va 2 s.  co m
 */
public void revokeRole(String usrId, String rolId) throws DatabaseException {
    log.debug("revokeRole({}, {})", usrId, rolId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        User user = (User) session.load(User.class, usrId);
        Role role = (Role) session.load(Role.class, rolId);
        user.getRoles().remove(role);
        session.update(user);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("revokeRole: void");
}

From source file:com.ikon.dao.AutomationDAO.java

License:Open Source License

/**
 * Delete/*from   w w w  . j  a v a2s .c o  m*/
 */
public void delete(long raId) throws DatabaseException {
    log.debug("delete({})", raId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        AutomationRule ra = (AutomationRule) session.load(AutomationRule.class, raId);
        session.delete(ra);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("delete: void");
}

From source file:com.ikon.dao.AutomationDAO.java

License:Open Source License

/**
 * Delete action/*from  w ww  .ja  va 2  s .c  o  m*/
 */
public void deleteAction(long aaId) throws DatabaseException {
    log.debug("deleteAction({})", aaId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        AutomationAction aa = (AutomationAction) session.load(AutomationAction.class, aaId);
        session.delete(aa);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("deleteAction: void");
}

From source file:com.ikon.dao.AutomationDAO.java

License:Open Source License

/**
 * Delete validation// w w w .  ja v a  2s  .c  om
 */
public void deleteValidation(long avId) throws DatabaseException {
    log.debug("deleteValidation({})", avId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        AutomationValidation av = (AutomationValidation) session.load(AutomationValidation.class, avId);
        session.delete(av);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("deleteAction: void");
}

From source file:com.ikon.dao.BookmarkDAO.java

License:Open Source License

/**
 * Delete// www  .ja va 2 s  .c o m
 */
public static void delete(long bmId) throws DatabaseException {
    log.debug("delete({})", bmId);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Bookmark bm = (Bookmark) session.load(Bookmark.class, bmId);
        session.delete(bm);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("delete: void");
}

From source file:com.ikon.dao.ConfigDAO.java

License:Open Source License

/**
 * Delete//w  ww  . ja v  a2s .c o m
 */
public static void delete(String key) throws DatabaseException {
    log.debug("delete({})", key);
    Session session = null;
    Transaction tx = null;

    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Config mt = (Config) session.load(Config.class, key);
        session.delete(mt);
        HibernateUtil.commit(tx);
    } catch (HibernateException e) {
        HibernateUtil.rollback(tx);
        throw new DatabaseException(e.getMessage(), e);
    } finally {
        HibernateUtil.close(session);
    }

    log.debug("delete: void");
}