Example usage for org.hibernate.query Query setDate

Introduction

In this page you can find the example usage for org.hibernate.query Query setDate.

Prototype

@Deprecated
@SuppressWarnings("unchecked")
default Query<R> setDate(String name, Date val) 

Source Link

Document

Bind the val (time is truncated) of a given Date object to a named query parameter.

Usage

From source file:DAO.BonCarburantDAO.java

@Override
public List<BonDeCarburant> findBonCarburantByDate(Date date) {
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "FROM BonDeCarburant WHERE deliveryDate = :date ";
    Query query = session.createQuery(hql);
    query.setDate("date", date);

    return query.getResultList();

}

---

From source file:DAO.DemandeArticlesDAO.java

@Override
public List<DemandeArticle> findDemandeArticlesByDate(Date date) {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    List<DemandeArticle> demandesArticles = new ArrayList<>();

    try {/*from w  w w .j ava 2s  . co  m*/

        String hql = "FROM DemandeArticle  WHERE dateDemande=:dateDemande";
        Query query = session.createQuery(hql);
        query.setDate("dateDemande", date);
        demandesArticles.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    System.out.println("dem article found " + demandesArticles.get(0).getClass().getName());

    return demandesArticles;

}

---

From source file:DAO.FixingDAO.java

@Override
public List<Fixing> findFixingsByDate(Date date) {

    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.getTransaction();

    String hql = "FROM Fixing WHERE  fixingDate = :date ";
    Query query = session.createQuery(hql);
    query.setDate("date", date);

    List<Fixing> fixings = query.getResultList();

    session.close();// w  ww  .j a v  a  2s  .c o m

    return fixings;

}

---