Example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria.

Prototype

public Criteria getExecutableCriteria(Session session) 

Source Link

Document

Get an executable instance of Criteria to actually run the query.

Usage

From source file:com.rockagen.gnext.dao.hb.Hibernate4GenericDaoImpl.java

License:Apache License

/**
 * Create a hibernate {@link Criteria} by {@link DetachedCriteria}
 * //from ww w  .j a v  a 2  s . c o m
 * @param criterions
 * @param firstResult
 * @param maxResults
 *            negatives meaning no limit...
 * @return Criteria
 */
protected Criteria createCriteria(DetachedCriteria dcriteria, int firstResult, int maxResults) {
    if (dcriteria == null) {
        dcriteria = DetachedCriteria.forClass(getEntityClass());
    }
    Criteria criteria = dcriteria.getExecutableCriteria(super.getSession());
    if (firstResult > 0) {
        criteria.setFirstResult(firstResult);
    }

    if (maxResults > 0) {
        criteria.setMaxResults(maxResults);
    }
    return criteria;
}

---

From source file:com.sccl.attech.common.persistence.BaseDao.java

License:Open Source License

/**
 * //from   ww w .j ava2s .  co  m
 * @param page
 * @param detachedCriteria
 * @param resultTransformer
 * @return
 */
@SuppressWarnings("unchecked")
public Page<T> find(Page<T> page, DetachedCriteria detachedCriteria, ResultTransformer resultTransformer) {
    // get count
    if (!page.isDisabled() && !page.isNotCount()) {
        page.setCount(count(detachedCriteria));
        if (page.getCount() < 1) {
            return page;
        }
    }
    Criteria criteria = detachedCriteria.getExecutableCriteria(getSession());
    criteria.setResultTransformer(resultTransformer);
    // set page   
    if (!page.isDisabled()) {
        criteria.setFirstResult(page.getFirstResult());
        criteria.setMaxResults(page.getMaxResults());
    }
    // order by
    if (StringUtils.isNotBlank(page.getOrderBy())) {
        for (String order : StringUtils.split(page.getOrderBy(), ",")) {
            String[] o = StringUtils.split(order, " ");
            //????
            String orderStr = o[0];
            if (orderStr.split("-")[0].equals("desc")) {
                criteria.addOrder(Order.desc(orderStr.split("-")[1]));
            } else {
                criteria.addOrder(Order.asc(orderStr.split("-")[1]));
            }
        }
    }
    page.setList(criteria.list());
    return page;
}

---

From source file:com.scit.spring.dao.GenericDAOImpl.java

@Override
public Pagina selPagina2(int pag, String colQuery, String query, String colOrder, Estructuras.Orden orden) {
    DetachedCriteria dc = DetachedCriteria.forClass(clazz)
            .add(Restrictions.like(colQuery, query, MatchMode.ANYWHERE));
    Criteria c = dc.getExecutableCriteria(getCurrentSession());
    if (!colOrder.equals("") && orden != null) {
        switch (orden) {
        case asc:
            c.addOrder(Order.asc(colOrder));
            break;
        case desc:
            c.addOrder(Order.desc(colOrder));
            break;
        }/*w w w . ja  va 2 s .co m*/
    }
    return calcular(c, pag);
}

---

From source file:com.scopix.periscope.periscopefoundation.persistence.DAOHibernate.java

License:Open Source License

/**
 *
 * @param criteria criterio de busqueda//from  w w  w.ja  va 2 s.  c om
 * @param firstResult primer resultado
 * @param maxResults numero maximo de resultados
 * @return Objeto del Tipo E
 */
public E findUniqueResultByCriteria(final DetachedCriteria criteria, final Integer firstResult,
        final Integer maxResults) {
    Assert.notNull(criteria, "DetachedCriteria must not be null");

    HibernateCallback callback = new HibernateCallback() {

        @Override
        public Object doInHibernate(Session session) {
            Criteria executableCriteria = criteria.getExecutableCriteria(session);
            if (firstResult != null) {
                executableCriteria.setFirstResult(firstResult);
            }
            if (maxResults != null) {
                executableCriteria.setMaxResults(maxResults);
            }
            return executableCriteria.uniqueResult();
        }
    };

    Object result = this.getHibernateTemplate().execute(callback);

    return (E) result;
}

---

From source file:com.soft.primerproyecto.Dao.BaseDaoHibernate.java

@Override
public List<T> search(DetachedCriteria criteria) throws Exception {
    Criteria critec = criteria.getExecutableCriteria(getSessionFactory().getCurrentSession());
    return critec.list();
}

---

From source file:com.thinkgem.jeesite.common.persistence.BaseDaoImpl.java

License:Open Source License

/**
 * /*www  .j av  a  2  s  .c om*/
 * 
 * @param detachedCriteria
 * @param page
 * @return
 */
@SuppressWarnings("unchecked")
public Page<T> find(Page<T> page, DetachedCriteria detachedCriteria) {
    // get count
    if (!page.isDisabled() && !page.isNotCount()) {
        page.setCount(count(detachedCriteria));
        if (page.getCount() < 1) {
            return page;
        }
    }
    Criteria criteria = detachedCriteria.getExecutableCriteria(getSession());
    criteria.setResultTransformer(Criteria.ROOT_ENTITY);
    // set page
    if (!page.isDisabled()) {
        criteria.setFirstResult(page.getFirstResult());
        criteria.setMaxResults(page.getMaxResults());
    }
    // order by
    if (StringUtils.isNotBlank(page.getOrderBy())) {
        for (String order : StringUtils.split(page.getOrderBy(), ",")) {
            String[] o = StringUtils.split(order, " ");
            if (o.length >= 1) {
                criteria.addOrder(Order.asc(o[0]));
            } else if (o.length >= 2) {
                if ("DESC".equals(o[1].toUpperCase())) {
                    criteria.addOrder(Order.desc(o[0]));
                } else {
                    criteria.addOrder(Order.asc(o[0]));
                }
            }
        }
    }
    page.setList(criteria.list());
    return page;
}

---

From source file:com.ut.tekir.contact.ContactStatusBean.java

License:LGPL

@SuppressWarnings("unchecked")
public List getResultList(Long contactId) {

    log.debug("Cari durum sorgusu ekiliyor");

    DetachedCriteria crit = DetachedCriteria.forClass(FinanceTxn.class);

    crit.add(Restrictions.eq("active", true));
    crit.add(Restrictions.eq("contact.id", contactId));

    /*// w  w  w  .j a v a 2 s.  c  om
    crit.setProjection( Projections.sum("amount")) 
    .setProjection( Projections.groupProperty("contact"))
    .setProjection( Projections.property("contact"));
    */

    HibernateSessionProxy session = (HibernateSessionProxy) entityManager.getDelegate();

    Criteria ecrit = crit.getExecutableCriteria(session);

    log.debug("Cari durum sorgusu ekiliyor");
    //ecrit.setMaxResults( 100 );

    return ecrit.list();
}

---

From source file:com.ut.tekir.finance.ChequeSuggestionBean.java

License:LGPL

@SuppressWarnings("unchecked")
public List<Cheque> selectChequeList() {

    HibernateSessionProxy session = (HibernateSessionProxy) entityManager.getDelegate();
    DetachedCriteria crit = DetachedCriteria.forClass(Cheque.class);

    //TODO: projection saglanmali, embedded money nesnesi sorun cikariyor   
    //       crit.forClass(Money.class, "money");
    //       crit.setProjection(Projections.projectionList()
    //            .add(Projections.property("id"), "id")
    //            .add(Projections.property("maturityDate"), "maturityDate")
    //            .add(Projections.property("referenceNo"), "referenceNo")
    //            .add(Projections.property("bankName"), "bankName")
    //            .add(Projections.property("bankBranch"), "bankBranch")
    //            .add(Projections.property("accountNo"), "accountNo")
    //            .add(Projections.property("chequeOwner"), "chequeOwner")
    //            .add(Projections.property("contact"), "contact")
    //            .add(Projections.property("lastStatus"), "lastStatus")
    //            .add(Projections.property("previousStatus"), "previousStatus")
    //            .add(Projections.property("serialNo"), "serialNo"));
    //        //from   w  w  w .j a  v a2  s. c  o m
    //        crit.setResultTransformer(Transformers.aliasToBean(Cheque.class));
    if (getHistoryBeginDate() != null || getHistoryEndDate() != null) {
        crit.createAlias("history", "history");
        if (getHistoryBeginDate() != null) {
            crit.add(Restrictions.ge("history.date", getHistoryBeginDate()));
        }
        if (getHistoryEndDate() != null) {
            crit.add(Restrictions.le("history.date", getHistoryEndDate()));
        }
        crit.add(Restrictions.eqProperty("history.status", "this.lastStatus"));

    }
    if (getReferenceNo() != null && getReferenceNo().length() > 0) {
        crit.add(Restrictions.ilike("referenceNo", getReferenceNo(), MatchMode.ANYWHERE));
    }

    if (getSerialNo() != null && getSerialNo().length() > 0) {
        crit.add(Restrictions.ilike("serialNo", getSerialNo(), MatchMode.START));
    }

    if (getBeginDate() != null) {
        crit.add(Restrictions.ge("maturityDate", getBeginDate()));
    }

    if (getEndDate() != null) {
        crit.add(Restrictions.le("maturityDate", getEndDate()));
    }

    if (getBankName() != null && getBankName().length() > 0) {
        crit.add(Restrictions.ilike("bankName", getBankName(), MatchMode.START));
    }

    if (getBankBranch() != null && getBankBranch().length() > 0) {
        crit.add(Restrictions.ilike("bankBranch", getBankBranch(), MatchMode.START));
    }

    if (getChequeOwner() != null && getChequeOwner().length() > 0) {
        crit.add(Restrictions.ilike("chequeOwner", getChequeOwner(), MatchMode.START));
    }

    if (getBankBranch() != null && getBankBranch().length() > 0) {
        crit.add(Restrictions.ilike("bankBranch", getBankBranch(), MatchMode.START));
    }

    if (getBankAccount() != null && getBankAccount().length() > 0) {
        crit.add(Restrictions.ilike("bankAccount", getBankAccount(), MatchMode.START));
    }

    if (getBankAccountId() != null) {
        crit.add(Restrictions.eq("bankAccountId", getBankAccountId().getId()));
    }

    if (getContact() != null) {
        crit.add(Restrictions.eq("contact", getContact()));
    }

    if (lastStatus != null) {
        crit.add(Restrictions.eq("lastStatus", lastStatus));
    } else {
        List<ChequeStatus> possibleStatus = null;
        if (clientCheque != null && clientCheque.equals(Boolean.TRUE)) {
            possibleStatus = possibleStatusForCustomer(targetStatus);
        } else {
            possibleStatus = possibleStatusForFirm(targetStatus);
        }

        if (possibleStatus != null) {
            crit.add(Restrictions.in("lastStatus", possibleStatus));
        }
    }

    crit.add(Restrictions.eq("clientCheque", getClientCheque()));

    Criteria ecrit = crit.getExecutableCriteria(session);

    chequeList = ecrit.list();

    return chequeList;
}

---

From source file:com.ut.tekir.finance.PromissorySuggestionBean.java

License:LGPL

@SuppressWarnings("unchecked")
public List<PromissoryNote> selectPromissoryList() {

    HibernateSessionProxy session = (HibernateSessionProxy) entityManager.getDelegate();
    DetachedCriteria crit = DetachedCriteria.forClass(PromissoryNote.class);
    //TODO: projection saglanmali, embedded money nesnesi sorun cikariyor 
    //        crit.setProjection(Projections.projectionList()
    //          .add(Projections.property("id"), "id")
    //            .add(Projections.property("maturityDate"), "maturityDate")
    //            .add(Projections.property("referenceNo"), "referenceNo")
    //            .add(Projections.property("paymentPlace"), "paymentPlace")
    //            .add(Projections.property("promissorynoteOwner"), "promissorynoteOwner")
    //            .add(Projections.property("clientPromissoryNote"), "clientPromissoryNote")
    //            .add(Projections.property("contact"), "contact")
    //            .add(Projections.property("lastStatus"), "lastStatus")
    //            .add(Projections.property("previousStatus"), "previousStatus")
    //            .add(Projections.property("serialNo"), "serialNo"));
    //        //from   ww w.j a  va 2s.  c  om
    //        crit.setResultTransformer(Transformers.aliasToBean(PromissoryNote.class));
    if (getHistoryBeginDate() != null || getHistoryEndDate() != null) {
        crit.createAlias("history", "history");
        if (getHistoryBeginDate() != null) {
            crit.add(Restrictions.ge("history.date", getHistoryBeginDate()));
        }
        if (getHistoryEndDate() != null) {
            crit.add(Restrictions.le("history.date", getHistoryEndDate()));
        }
        crit.add(Restrictions.eqProperty("history.status", "this.lastStatus"));
    }

    if (getReferenceNo() != null && getReferenceNo().length() > 0) {
        crit.add(Restrictions.ilike("referenceNo", getReferenceNo(), MatchMode.ANYWHERE));
    }

    if (getSerialNo() != null && getSerialNo().length() > 0) {
        crit.add(Restrictions.ilike("serialNo", getSerialNo(), MatchMode.START));
    }

    if (getBeginDate() != null) {
        crit.add(Restrictions.ge("maturityDate", getBeginDate()));
    }

    if (getEndDate() != null) {
        crit.add(Restrictions.le("maturityDate", getEndDate()));
    }

    if (getPaymentPlace() != null && getPaymentPlace().length() > 0) {
        crit.add(Restrictions.ilike("paymentPlace", getPaymentPlace(), MatchMode.START));
    }

    if (getPromissorynoteOwner() != null && getPromissorynoteOwner().length() > 0) {
        crit.add(Restrictions.ilike("promissorynoteOwner", getPromissorynoteOwner(), MatchMode.START));
    }

    if (getContact() != null) {
        crit.add(Restrictions.eq("contact", getContact()));
    }

    if (lastStatus != null) {
        crit.add(Restrictions.eq("lastStatus", lastStatus));
    } else {
        List<ChequeStatus> possibleStatus = null;
        if (clientPromissory != null && clientPromissory.equals(Boolean.TRUE)) {
            possibleStatus = possibleStatusForCustomer(targetStatus);
        } else {
            possibleStatus = possibleStatusForFirm(targetStatus);
        }

        if (possibleStatus != null) {
            crit.add(Restrictions.in("lastStatus", possibleStatus));
        }
    }

    crit.add(Restrictions.eq("clientPromissoryNote", getClientPromissory()));

    Criteria ecrit = crit.getExecutableCriteria(session);

    promissoryList = ecrit.list();

    return promissoryList;
}

---

From source file:com.wwinsoft.modules.orm.hibernate.HibernateDao.java

License:Apache License

public List<T> findDetached(List<PropertyFilter> filters) {
    ResolveAlias ra = new ResolveAlias();
    DetachedCriteria detachedCriteria = buildDetachedCriteriaByPropertyFilter(filters, ra);
    return detachedCriteria.getExecutableCriteria(getSession()).list();
}

---

• «
• 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
• »