Example usage for org.hibernate.criterion Restrictions ne

Introduction

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

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

@Override
public List<PhenoDataSetCategory> getAvailableAllCategoryListExceptThis(Study study, ArkFunction arkFunction,
        PhenoDataSetCategory thisPhenoDataSetCategory) throws ArkSystemException {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);
    criteria.add(Restrictions.ne("id", thisPhenoDataSetCategory.getId()));
    criteria.add(Restrictions.eq("arkFunction", arkFunction));
    criteria.add(Restrictions.eq("study", study));
    List<PhenoDataSetCategory> phenoDataSetCategoryList = (List<PhenoDataSetCategory>) criteria.list();
    return phenoDataSetCategoryList;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public boolean personHasPreferredMailingAddress(Person person, Long currentAddressId) {

    boolean hasPreferredMailing = false;

    Criteria criteria = getSession().createCriteria(Address.class);

    // YesNo yes = getYesNo("Yes");
    criteria.add(Restrictions.eq("person.id", person.getId()));
    criteria.add(Restrictions.eq("preferredMailingAddress", true));
    if (currentAddressId != null) {
        criteria.add(Restrictions.ne("id", currentAddressId));
    }//w  w  w.j a va  2 s.  c o  m

    List list = criteria.list();
    if (list.size() > 0) {
        hasPreferredMailing = true;
    }
    return hasPreferredMailing;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<Study> getChildStudyListOfParent(Study study) {
    Criteria criteria = getStatelessSession().createCriteria(Study.class);
    criteria.add(Restrictions.ne("id", study.getId()));
    criteria.add(Restrictions.eq("parentStudy", study));

    try {/* www .ja  v a 2 s .  c om*/
        criteria.add(Restrictions.ne("studyStatus", getStudyStatus("Archive")));
    } catch (StatusNotAvailableException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    criteria.addOrder(Order.asc("name"));
    List<Study> childStudyList = (List<Study>) criteria.list();
    return childStudyList;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<LinkSubjectPedigree> getParentNonSubjectRelationshipList(final LinkSubjectStudy subject,
        final LinkSubjectStudy parentSubject) {
    Criteria criteria = getSession().createCriteria(LinkSubjectPedigree.class);
    criteria.add(Restrictions.eq("relative", parentSubject));
    criteria.add(Restrictions.ne("subject", subject));
    return criteria.list();
}

From source file:br.com.hrstatus.dao.impl.ServersDAO.java

License:Open Source License

public int countOtherOK() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] countOtherOK()");

    try {/*from   w  w w. ja v a2s.  c  om*/

        final Criteria criteria = session().createCriteria(Servidores.class);
        criteria.add(Restrictions.ne("SO", "Windows"));
        criteria.add(Restrictions.ne("SO", "Unix"));
        criteria.add(Restrictions.eq("status", "OK"));
        criteria.setProjection(Projections.rowCount());
        final int count = ((Long) criteria.uniqueResult()).intValue();
        log.fine("[ " + userInfo.getLoggedUsername() + " ] countOtherOK -> " + count + " found.");
        return count;

    } catch (Exception e) {
        log.severe("[ " + userInfo.getLoggedUsername() + " ] Error: " + e);
        return 0;
    }
}

From source file:br.com.hrstatus.dao.impl.ServersDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Servidores> getHostnamesWithLogDir() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getHostnamesWithLogDir()");

    try {/*from   w  w w.j av a2s  . co m*/

        final Criteria getHostnamesWithLogDir = session().createCriteria(Servidores.class);
        getHostnamesWithLogDir.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
        getHostnamesWithLogDir.add(Restrictions.ne("logDir", ""));
        return getHostnamesWithLogDir.list();

    } catch (Exception e) {
        log.severe("Error: " + e);
        return new ArrayList<Servidores>();
    }
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findAll() {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findByBanco(Long idBanco) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.eq("banco.id", idBanco));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findByDescricao(String descricao) {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.ContaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Conta> findAllAtivos() {
    Criteria criteria = getSession().createCriteria(Conta.class);
    criteria.add(Restrictions.eq("ativo", true));
    criteria.add(Restrictions.ne("tipoConta", TipoConta.CARTAO));
    return criteria.addOrder(Order.asc("descricao")).list();
}