Example usage for org.hibernate Session clear

Introduction

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

Prototype

void clear();

Source Link

Document

Completely clear the session.

Usage

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByIDCustomer(int id, String status) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {//from  w w w . j  av  a 2s  .  c  o m
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery(
                "from PurchaseOrder where ID_Customer like '" + id + "' AND Status like '" + status + "'")
                .list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByIDWarehouse(int id) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/*from  ww  w . ja va2 s .  c om*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery("from PurchaseOrder where ID_Warehouse like '" + id + "'").list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String dateFrom, String dateTo, String status) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {// ww w  .j av  a 2  s.  co  m
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session
                .createQuery("from PurchaseOrder where ID_Warehouse like '" + id_wh + "' AND Status like '"
                        + status + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                .list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String status) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {//from w ww . j av  a2s  . co  m
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery(
                "from PurchaseOrder where ID_Warehouse like '" + id_wh + "' AND Status like '" + status + "'")
                .list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByIDWarehouse(int id_wh, String dateFrom, String dateTo) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/* w  w w.j  ava2s  . c  om*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery("from PurchaseOrder where ID_Warehouse like '" + id_wh
                + "'  AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'").list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByAdmin(int pageNumber) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/*from   w w w  .j  a va2  s  . c om*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery("from PurchaseOrder").setFirstResult((pageNumber - 1) * pageSize)
                .setMaxResults(pageSize).list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, String status, String warehouse,
        int pageNumber) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/*ww  w. j  ava2  s  .  c o m*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session
                .createQuery("from PurchaseOrder where ID_Warehouse like '" + warehouse + "' AND Status like '"
                        + status + "' AND Date_Order >='" + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByAdmin(String status, int pageNumber) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/*  w  w w . j  ava2s.  com*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session.createQuery("from PurchaseOrder where Status like '" + status + "'")
                .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, String warehouse, int pageNumber) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {// w w w.  j  ava2s .  com
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session
                .createQuery("from PurchaseOrder where ID_Warehouse like '" + warehouse + "' AND Date_Order >='"
                        + dateFrom + "' AND Date_Order <='" + dateTo + "'")
                .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

From source file:autoancillarieslimited.hiberate.dao.PurchaseOrderDAO.java

public List<PurchaseOrder> getListByAdmin(String dateFrom, String dateTo, int pageNumber) {
    List<PurchaseOrder> set = null;
    Session session = null;
    Transaction beginTransaction = null;
    try {/*from   w  ww.j a  v  a 2  s  .co m*/
        session = HibernateUtil.getSessionFactory().openSession();
        beginTransaction = session.beginTransaction();
        set = session
                .createQuery("from PurchaseOrder where Date_Order >='" + dateFrom + "' AND Date_Order <='"
                        + dateTo + "'")
                .setFirstResult((pageNumber - 1) * pageSize).setMaxResults(pageSize).list();
        session.flush();
        session.clear();
        session.getTransaction().commit();
    } catch (HibernateException ex) {
        ex.printStackTrace();
        if (beginTransaction != null) {
            beginTransaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return set;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »