Examples with Query org.hibernate.query.Query used on opensource projects

Example 86 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class CrfVersionDao method findByOcOID.

public CrfVersion findByOcOID(String OCOID) {
    getSessionFactory().getStatistics().logSummary();
    Query q = getCurrentSession().createQuery(findByOcIdQuery);
    q.setParameter("OCOID", OCOID);
    return (CrfVersion) q.uniqueResult();
}

Example 87 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemDataDao method findByEventCrfItemName.

public ItemData findByEventCrfItemName(int eventCrfId, String itemName, int ordinal) {
    Query q = getCurrentSession().createQuery(findByEventCrfItemName);
    q.setParameter("eventCrfId", eventCrfId);
    q.setParameter("itemName", itemName);
    q.setParameter("ordinal", ordinal);
    return (ItemData) q.uniqueResult();
}

Example 88 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemDataDao method findByEventCrfGroupOrdinal.

public ItemData findByEventCrfGroupOrdinal(EventCrf eventCrf, Integer itemGroupId, Integer ordinal) {
    Query q = getCurrentSession().createQuery(findByEventCrfGroupOrdinalQuery);
    q.setParameter("eventCrfId", eventCrf.getEventCrfId());
    q.setParameter("itemGroupId", itemGroupId);
    q.setParameter("ordinal", ordinal);
    return (ItemData) q.uniqueResult();
}

Example 89 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemDataDao method findAllByEventCrfItemId.

public List<ItemData> findAllByEventCrfItemId(int eventCrfId, Integer itemId) {
    Query q = getCurrentSession().createQuery(findAllByEventCrfItemId);
    q.setParameter("eventCrfId", eventCrfId);
    q.setParameter("itemId", itemId);
    return (List<ItemData>) q.list();
}

Example 90 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemDataDao method findByItemsEventCrf.

public List<ItemData> findByItemsEventCrf(List<Item> items, Integer eventCrfId, Integer numItems) {
    Query q = getCurrentSession().createQuery(findByItemEventCrfOrdinalQuery);
    q.setParameter("items", items);
    q.setParameter("eventCrfid", eventCrfId);
    q.setParameter("numItems", numItems);
    return (List<ItemData>) q.list();
}