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:be.shad.tsqb.dao.TypeSafeQueryDaoImpl.java

License:Apache License

/**
 * Lists the same query with an updated collection in the named param for the batched named param.
 *///from  w  ww .j  av a2  s  . co  m
@SuppressWarnings("unchecked")
private <T> List<T> listAll(Query<Object[]> query, HqlQuery hqlQuery, CollectionNamedParameter chunkedParam) {
    List<Object[]> results;
    if (chunkedParam == null) {
        results = query.getResultList();
    } else {
        results = new LinkedList<>();
        int p = chunkedParam.getBatchSize();
        List<Object> values = new ArrayList<>(p);
        Iterator<?> it = chunkedParam.getValue().iterator();
        while (it.hasNext()) {
            values.add(it.next());
            if (values.size() == p || !it.hasNext()) {
                query.setParameterList(chunkedParam.getName(), values);
                results.addAll(query.getResultList());
                values.clear();
            }
        }
    }

    if (hqlQuery.getResultTransformer() != null) {
        return (List<T>) hqlQuery.getResultTransformer().transformList(results);
    } else {
        return (List<T>) results;
    }
}

---

From source file:be.shad.tsqb.test.GetSuperTypeAsSubtypeAndBuildQueryTest.java

License:Apache License

/**
 * Assuming the property path doesn't need to be on the super type
 * if it is on one of the subtypes of a hibernate types
 * with an @Inheritance annotation.//from   w  ww .j a  va2  s. co  m
 * <p>
 * If this doesn't hold true, then creating this query will surely fail.
 */
@Test
public void testHibernateAssumption() {
    Query<?> query = getSessionFactory().getCurrentSession()
            .createQuery("from Building b where b.revenue > 10.0");
    query.getResultList();
}

---

From source file:com.codeup.hibernate.repositories.MoviesRepository.java

@Override
public List<Movie> withTitleSimilarTo(String title) {
    Query query = session.createQuery("FROM Movie WHERE title LIKE ?");
    query.setParameter(0, "%" + title + "%");

    @SuppressWarnings("unchecked")
    List<Movie> movies = query.getResultList();

    return movies;
}

---

From source file:com.codeup.hibernate.repositories.MoviesRepository.java

@Override
public List<Movie> underCategory(int categoryId) {
    Query query = session.createQuery("SELECT m FROM Movie m JOIN m.categories c WHERE c.id = ?");
    query.setParameter(0, categoryId);/*from w ww .  jav a2 s . co  m*/

    @SuppressWarnings("unchecked")
    List<Movie> movies = query.getResultList();

    return movies;
}

---

From source file:com.dao.AsientoDAO.java

public List<Asiento> getAsientos() {
    List<Asiento> asientos = new ArrayList<>();
    try (Session session = SessionUtil.getSession()) {
        CriteriaBuilder builder = session.getCriteriaBuilder();
        CriteriaQuery<Asiento> query = builder.createQuery(Asiento.class);
        Root<Asiento> root = query.from(Asiento.class);
        query.select(root);//  www  .  j  a  va  2s . c o m
        Query<Asiento> q = session.createQuery(query);
        asientos = q.getResultList();
    }

    return asientos;
}

---

From source file:com.dao.EventoDAO.java

public List<Evento> getEventos() {
    List<Evento> eventos = new ArrayList<>();
    try (Session session = SessionUtil.getSession()) {
        CriteriaBuilder builder = session.getCriteriaBuilder();
        CriteriaQuery<Evento> query = builder.createQuery(Evento.class);
        Root<Evento> root = query.from(Evento.class);
        query.select(root);/*  w ww.  ja v a2 s.  c  o  m*/
        Query<Evento> q = session.createQuery(query);
        eventos = q.getResultList();
    }

    return eventos;
}

---

From source file:com.dao.LugarDAO.java

public List<Lugar> getLugares() {
    List<Lugar> lugares = new ArrayList<>();
    try (Session session = SessionUtil.getSession()) {
        CriteriaBuilder builder = session.getCriteriaBuilder();
        CriteriaQuery<Lugar> query = builder.createQuery(Lugar.class);
        Root<Lugar> root = query.from(Lugar.class);
        query.select(root);/* ww  w.j  a va 2  s . c  om*/
        Query<Lugar> q = session.createQuery(query);
        lugares = q.getResultList();
    }

    return lugares;
}

---

From source file:com.dao.PagoDAO.java

public List<Pago> getPagos() {
    List<Pago> pagos = new ArrayList<>();
    try (Session session = SessionUtil.getSession()) {
        CriteriaBuilder builder = session.getCriteriaBuilder();
        CriteriaQuery<Pago> query = builder.createQuery(Pago.class);
        Root<Pago> root = query.from(Pago.class);
        query.select(root);//from w w  w .  java  2s  .  c o m
        Query<Pago> q = session.createQuery(query);
        pagos = q.getResultList();
    }

    return pagos;
}

---

From source file:com.imos.sample.database.repository.HibernateRepository.java

public List<O> executeQuery(String queryStr, Class<O> cls, boolean uniqueResult) throws RepositoryException {
    List<O> result = new ArrayList<>();
    try {//from  w  ww .j a va2 s .c  o  m
        open();
        session.getTransaction().begin();
        Query<O> query = session.createQuery(queryStr, cls);
        if (uniqueResult) {
            result.add(query.getSingleResult());
        } else {
            result = query.getResultList();
        }
        session.getTransaction().commit();
        log.info("Hibernate database event {} succeed", EventType.JPA_QUERY.name());
    } catch (Exception e) {
        log.info("Hibernate database event {} failed", EventType.JPA_QUERY.name());
        session.getTransaction().rollback();
        throw new RepositoryException(e);
    } finally {
        close();
    }
    return result;
}

---

From source file:com.pfm.personalfinancemanager.datapostgres.sets.PaymentCategorySet.java

private boolean categoryExistsForEdit(String categoryName, UUID userId, UUID categoryId, Session session) {
    Query q = session.createQuery(
            "From PaymentCategories pc where pc.pcatName = :categoryName and pc.pcatUser.userUserid = :userId and pc.pcatId!=:categoryId",
            PaymentCategories.class).setParameter("categoryName", categoryName).setParameter("userId", userId)
            .setParameter("categoryId", categoryId);

    boolean exists = false;
    if (q.getResultList().size() > 0) {
        exists = true;/*  w  w  w  .j  a v a  2 s  .  com*/
    }

    return exists;
}

---

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