Example usage for org.hibernate.criterion Restrictions idEq

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions idEq.

Prototype

public static Criterion idEq(Object value)

Source Link

Document

Apply an "equal" constraint to the identifier property

Usage

From source file:com.alfonsogalvanmadera.robot.DAO.DAOAccion2.java

public Accion2 bucarAccion2(Integer id) throws Exception {
    Accion2 a = (Accion2) session.createCriteria(Accion2.class).add(Restrictions.idEq(id)).uniqueResult();
    cerrarTodo();//from   w w  w .j a  v a2s  .c o m
    return a;
}

From source file:com.alfonsogalvanmadera.robot.DAO.DAOCadena2.java

public Cadena2 bucarCadena(Integer id) throws Exception {
    Cadena2 c = (Cadena2) session.createCriteria(Cadena2.class).add(Restrictions.idEq(id)).uniqueResult();
    return c;//from   w w  w .ja va  2s.  co m
}

From source file:com.alfonsogalvanmadera.robot.DAO.DAOCliente2.java

public Cliente2 buscarCliente(Integer id) {
    Cliente2 c = (Cliente2) session.createCriteria(Cliente2.class).add(Restrictions.idEq(id)).uniqueResult();
    cerrarTodo();//from  w  ww  .  java 2s .c  o  m
    return c;
}

From source file:com.alfonsogalvanmadera.robot.DAO.DAODato2.java

public Dato2 buscarDato2(Integer id) {
    Dato2 d = (Dato2) session.createCriteria(Dato2.class).add(Restrictions.idEq(id)).uniqueResult();
    cerrarTodo();
    return d;
}

From source file:com.billing.ng.dao.impl.GenericDAOImpl.java

License:Open Source License

/**
 * Returns true if a persisted record exsits for the given id.
 *
 * This method requires an underlying Hibernate persistence provider.
 *
 * @param id primary key of entity/*from  ww w .  j  a v  a  2  s  . com*/
 * @return true if entity exists for id, false if entity does not exist
 */
public boolean isIdPersisted(ID id) {
    Criteria criteria = createCritiera().add(Restrictions.idEq(id)).setProjection(Projections.id());

    return !criteria.list().isEmpty();
}

From source file:com.eucalyptus.reporting.export.Export.java

License:Open Source License

@SuppressWarnings("unchecked")
private static <T> T getById(final Class<T> itemClass, final Object id) {
    final EntityTransaction transaction = Entities.get(itemClass);
    try {//from   w  ww  . ja v  a 2  s .  c  om
        return (T) criteriaFor(itemClass, Restrictions.idEq(id)).uniqueResult();
    } finally {
        transaction.rollback();
    }
}

From source file:com.gisgraphy.domain.repository.GenericGisDao.java

License:Open Source License

/**
 * base method for all findNearest* /*w w w . j  ava2 s.  com*/
 * 
 * @param point
 *                The point from which we want to find GIS Object
 * @param pointId
 *                the id of the point that we don't want to be include, it
 *                is used to not include the gisFeature from which we want
 *                to find the nearest
 * @param distance
 *                distance The radius in meters
 * @param firstResult
 *                the firstResult index (for pagination), numbered from 1,
 *                if < 1 : it will not be taken into account
 * @param maxResults
 *                The Maximum number of results to retrieve (for
 *                pagination), if <= 0 : it will not be taken into acount
 * @param requiredClass
 *                the class of the object to be retireved
 * @param isMunicipality whether we should filter on city that are flag as 'municipality'.
          act as a filter, if false it doesn't filters( false doesn't mean that we return non municipality)
 * @return A List of GisFeatureDistance with the nearest elements or an
 *         emptylist (never return null), ordered by distance.<u>note</u>
 *         the specified gisFeature will not be included into results
 * @see GisFeatureDistance
 * @return a list of gisFeature (never return null but an empty list)
 */
@SuppressWarnings("unchecked")
protected List<GisFeatureDistance> getNearestAndDistanceFrom(final Point point, final Long pointId,
        final double distance, final int firstResult, final int maxResults, final boolean includeDistanceField,
        final Class<? extends GisFeature> requiredClass, final boolean isMunicipality) {
    Assert.notNull(point);
    return (List<GisFeatureDistance>) this.getHibernateTemplate().execute(new HibernateCallback() {

        public Object doInHibernate(Session session) throws PersistenceException {
            Criteria criteria = session.createCriteria(requiredClass);

            if (maxResults > 0) {
                criteria = criteria.setMaxResults(maxResults);
            }
            if (firstResult >= 1) {
                criteria = criteria.setFirstResult(firstResult - 1);
            }
            criteria = criteria.add(new DistanceRestriction(point, distance));
            List<String> fieldList = IntrospectionHelper.getFieldsAsList(requiredClass);
            ProjectionList projections = ProjectionBean.fieldList(fieldList, true);
            if (includeDistanceField) {
                projections.add(SpatialProjection.distance_sphere(point, GisFeature.LOCATION_COLUMN_NAME)
                        .as("distance"));
            }
            criteria.setProjection(projections);
            if (pointId != 0) {
                // remove The From Point
                criteria = criteria.add(Restrictions.not(Restrictions.idEq(pointId)));
            }
            if (includeDistanceField) {
                criteria.addOrder(new ProjectionOrder("distance"));
            }
            if (isMunicipality && (requiredClass == City.class || requiredClass == GisFeature.class)) {
                criteria.add(Restrictions.eq(City.MUNICIPALITY_FIELD_NAME, isMunicipality));
            }

            criteria.setCacheable(true);
            List<Object[]> queryResults = criteria.list();

            String[] aliasList;
            if (includeDistanceField) {
                aliasList = (String[]) ArrayUtils.add(IntrospectionHelper.getFieldsAsArray(requiredClass),
                        "distance");
            } else {
                aliasList = IntrospectionHelper.getFieldsAsArray(requiredClass);
            }
            int idPropertyIndexInAliasList = 0;
            for (int i = 0; i < aliasList.length; i++) {
                if (aliasList[i] == "id") {
                    idPropertyIndexInAliasList = i;
                    break;
                }
            }

            boolean hasZipCodesProperty = ZipCodesAware.class.isAssignableFrom(requiredClass);
            Map<Long, Set<String>> idToZipCodesMap = null;
            if (hasZipCodesProperty && queryResults.size() > 0) {
                List<Long> ids = new ArrayList<Long>();
                for (Object[] tuple : queryResults) {
                    ids.add((Long) tuple[idPropertyIndexInAliasList]);
                }
                String zipCodeQuery = "SELECT code as code,gisfeature as id FROM "
                        + ZipCode.class.getSimpleName().toLowerCase() + " zip where zip.gisfeature in (:ids)";
                Query qry = session.createSQLQuery(zipCodeQuery).addScalar("code", Hibernate.STRING)
                        .addScalar("id", Hibernate.LONG);
                qry.setCacheable(true);

                qry.setParameterList("ids", ids);
                List<Object[]> zipCodes = (List<Object[]>) qry.list();

                if (zipCodes.size() > 0) {
                    idToZipCodesMap = new HashMap<Long, Set<String>>();
                    for (Object[] zipCode : zipCodes) {
                        Long idFromZipcode = (Long) zipCode[1];
                        Set<String> zipCodesFromMap = idToZipCodesMap.get(idFromZipcode);
                        if (zipCodesFromMap == null) {
                            Set<String> zipCodesToAdd = new HashSet<String>();
                            idToZipCodesMap.put(idFromZipcode, zipCodesToAdd);
                            zipCodesFromMap = zipCodesToAdd;
                        }
                        zipCodesFromMap.add((String) zipCode[0]);
                    }
                }
            }
            List<GisFeatureDistance> results = ResultTransformerUtil.transformToGisFeatureDistance(aliasList,
                    queryResults, idToZipCodesMap, requiredClass);
            return results;
        }
    });

}

From source file:com.github.jguaneri.notifications.repository.specification.notification.impl.NotificationSpecificationById.java

License:Open Source License

@Override
public Criterion toCriteria() {
    return Restrictions.idEq(notificationId);
}

From source file:com.googlecode.ouvidoria.model.complaint.ComplaintDaoImpl.java

@Override
@SuppressWarnings("unchecked")
public List<?> searchByCriteria(final int transform, final String queryString, int pageNumber, int pageSize,
        final ComplaintVO vo) {
    Criteria criteria = this.getSession().createCriteria(Complaint.class);

    if (vo != null) {
        if (vo.getId() != null) {
            criteria.add(Restrictions.idEq(vo.getId()));
        } else {/*from w ww.ja  va 2  s  . c om*/
            if (vo.getStatus() != null) {
                System.out.println("DAO .... " + vo.getStatus());
                criteria.add(Restrictions.eq("status", vo.getStatus()));
            }
            //TODO demandant
            if (vo.getSubjectId() != null) {
                criteria.createCriteria("subject").add(Restrictions.idEq(vo.getSubjectId()));
            }
            if (vo.getText() != null) {
                criteria.add(Restrictions.ilike("text", "%" + vo.getText() + "%"));
            }
            if (vo.getTypeId() != null) {
                criteria.createCriteria("type").add(Restrictions.idEq(vo.getTypeId()));
            }
        }
    }
    criteria.addOrder(Order.desc("date"));

    if (pageNumber > 0 && pageSize > 0) {
        criteria.setFirstResult(super.calculateFirstResult(pageNumber, pageSize));
        criteria.setMaxResults(pageSize);
    }

    List results = criteria.list();
    transformEntities(transform, results);
    return results;
}

From source file:com.herval.gestaoefetivo.daos.GenericDAO.java

@SuppressWarnings("unchecked")
public Entidade buscar(Long codigo) {
    Session sessao = HibernateUtil.getSessionFactory().openSession();
    try {/*  w  w w. j  a v  a  2s  . c o m*/
        Criteria consulta = sessao.createCriteria(classe);
        consulta.add(Restrictions.idEq(codigo));
        Entidade resultado = (Entidade) consulta.uniqueResult();
        return resultado;
    } catch (RuntimeException erro) {
        throw erro;
    } finally {
        sessao.close();
    }
}