Example usage for org.hibernate.query Query getResultList

Introduction

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

Prototype

default List<R> getResultList() 

Source Link

Usage

From source file:DAO.DemandeArticlesDAO.java

@Override
public List<DemandeArticle> findDemandeArticlesByResponsable(String responsable) {

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

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

    try {//from w w  w. jav  a2s .  c o m

        String hql = "FROM DemandeArticle  WHERE fixing.responsableMission=:responsableMission";
        Query query = session.createQuery(hql);
        query.setString("responsableMission", responsable);
        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.DemandeArticlesDAO.java

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

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

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

    try {/*from   ww w  .  j a  v a  2s.  c  o 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> findFixingByYear(Integer year) {

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

    String hql = "FROM Fixing WHERE  YEAR (fixingDate) = :year ";
    Query query = session.createQuery(hql);
    query.setInteger("year", year);

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

    session.close();/*from   w ww . j  a va2 s  . c o m*/

    return fixings;

}

---

From source file:DAO.FixingDAO.java

@Override
public List<Fixing> findFixingsByImmatriculation(String immatriculation) {

    // new DAO with get previous session (false)
    CarDAO carDao = new CarDAO(false);

    // get car by immatriculation
    Car car = carDao.getCarByImmatriculation(immatriculation);

    System.out.println("Car found " + car.getImmatriculation());

    // reopen the session (because CarDAO has closed it)
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.beginTransaction();

    String hql = "FROM Fixing WHERE  car = :car ";
    Query query = session.createQuery(hql);
    query.setEntity("car", car);

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

    session.close();/*from   w  w  w.  j a  va2s  .c o  m*/

    return fixings;

}

---

From source file:DAO.FixingDAO.java

@Override
public List<Fixing> findFixingsByDepartement(String departementName) {

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

    // new DAO with get previous session (false)
    CarDAO carDao = new CarDAO(false);

    // get cars by departement
    List<Car> cars = carDao.getCarByDepartement(departementName);

    List<Fixing> fixings = new ArrayList<>();

    // reopen the session (because CarDAO has closed it)
    session = HibernateUtil.getSessionFactory().getCurrentSession();
    transaction = session.beginTransaction();

    // for each car in that departement , we will get all its fixings
    for (Car car : cars) {
        String hql = "FROM Fixing WHERE  car = :car ";
        Query query = session.createQuery(hql);
        query.setEntity("car", car);

        try {/*w w  w .j  a  va 2  s .c o m*/
            fixings.addAll(query.getResultList());
        } catch (NullPointerException e) {
            /// this car does not have any Fixings
        }
    }

    session.close();

    return fixings;

}

---

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();//  ww w . j  a v  a  2 s.  c  o  m

    return fixings;

}

---

From source file:DAO.FixingDAO.java

@Override
public List<Fixing> findAllFixingAlerts() {

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

    List<Fixing> fixings = new ArrayList<>();

    try {//  w  w  w .ja  v  a  2  s .  c o  m
        String hql = "FROM Fixing WHERE indexKM+9500 < indexKM OR dateProchaineTaxe < CURRENT_DATE()+10 OR dateProchaineVigniette < CURRENT_DATE()+10";
        Query query = session.createQuery(hql);
        fixings.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return fixings;

}

---

From source file:DAO.FixingDAO.java

@Override
public List<Car> findCoutKilometrique() {

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

    List<Car> cars = new ArrayList<>();

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

        String hql = "FROM Car AS c WHERE (prixAchat*0.4 <  (SELECT SUM(f.price) FROM Fixing AS f WHERE car.immatriculation= c.immatriculation))  OR indexKm>indexKm+9500";
        Query query = session.createQuery(hql);
        cars.addAll(query.getResultList());
    } catch (NoResultException e) {
        session.close();
        return null;
    }
    session.close();

    return cars;

}

---

From source file:dk.fambagge.recipes.web.data.LazyCustomList.java

@SuppressWarnings("Duplicates")
@Override//from  ww w.j av  a  2  s.  com
public List<T> load(int first, int pageSize, String sortField, SortOrder sortOrder,
        Map<String, Object> filters) {

    List<T> results = new ArrayList<>();

    filterMap = new HashMap<>();

    if (filters != null) {
        filterMap.putAll(filters);
    }

    if (customFilter != null) {
        filterMap.put("name", customFilter);
    }

    Database.execute((session) -> {
        CriteriaBuilder builder = session.getCriteriaBuilder();

        CriteriaQuery<Long> criteriaCount = builder.createQuery(Long.class);
        Root<T> rootCount = criteriaCount.from(domainClass);

        Predicate[] predicatesCount = new Predicate[filterMap.size()];

        //Setup filters
        int i = 0;
        for (Entry<String, Object> entry : filterMap.entrySet()) {
            String filterField = entry.getKey();
            String filterValue = entry.getValue().toString();

            predicatesCount[i] = builder.like(builder.lower(rootCount.get(filterField)),
                    "%" + filterValue.toLowerCase() + "%");
            i++;
        }

        criteriaCount.select(builder.count(rootCount));
        criteriaCount.where(predicatesCount);

        int count = session.createQuery(criteriaCount).uniqueResult().intValue();

        this.setRowCount(count);

        CriteriaQuery<T> criteria = builder.createQuery(domainClass);
        Root<T> root = criteria.from(domainClass);

        Predicate[] predicates = new Predicate[filterMap.size()];

        //Setup filters
        i = 0;
        for (Entry<String, Object> entry : filterMap.entrySet()) {
            String filterField = entry.getKey();
            String filterValue = entry.getValue().toString();

            predicates[i] = builder.like(builder.lower(root.get(filterField)),
                    "%" + filterValue.toLowerCase() + "%");
            i++;
        }

        criteria.select(root);
        criteria.where(predicates);

        String sortFieldFixed = sortField == null ? "name" : sortField;
        SortOrder sortOrderFixed = sortOrder == null ? SortOrder.ASCENDING : sortOrder;

        switch (sortOrderFixed) {
        case ASCENDING:
            criteria.orderBy(builder.asc(root.get(sortFieldFixed)));
            break;
        case DESCENDING:
            criteria.orderBy(builder.desc(root.get(sortFieldFixed)));
            break;
        }

        Query<T> query = session.createQuery(criteria);
        query.setFirstResult(first);
        query.setMaxResults(pageSize);

        results.addAll(query.getResultList());
    });

    return results;
}

---

From source file:it.greenvulcano.gvesb.iam.repository.hibernate.UserRepositoryHibernate.java

License:Open Source License

public Set<User> find(Map<Parameter, Object> parameters, LinkedHashMap<Parameter, Order> order, int firstResult,
        int maxResult) {
    Set<User> result = new LinkedHashSet<>();

    QueryHelper helper = buildQueryHelper(false, parameters, order);

    @SuppressWarnings("unchecked")
    Query<UserJPA> q = getSession().createQuery(helper.getQuery().toString());
    helper.getParams().entrySet().forEach(p -> q.setParameter(p.getKey(), p.getValue()));

    q.setFirstResult(firstResult);/*from  w ww .  ja v a  2  s  . c  o  m*/
    q.setMaxResults(maxResult);

    result.addAll(q.getResultList());

    return result;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• »