Example usage for org.hibernate.criterion Restrictions ilike

Introduction

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

Prototype

public static Criterion ilike(String propertyName, String value, MatchMode matchMode)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator) using the provided match mode

Usage

From source file:de.forsthaus.backend.dao.impl.ArticleDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override// www  . j ava2s  . c  o  m
public List<Article> getArticlesLikeArticleNumber(String text) {

    DetachedCriteria criteria = DetachedCriteria.forClass(Article.class);
    criteria.add(Restrictions.ilike("artNr", text, MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.ArticleDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w  w  w . j  a  va 2  s .  co m*/
public List<Article> getArticlesLikeName(String string) {

    DetachedCriteria criteria = DetachedCriteria.forClass(Article.class);
    criteria.add(Restrictions.ilike("artKurzbezeichnung", string, MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.BrancheDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  www  .j a  va2 s .  c  om*/
public List<Branche> getBranchesLikeName(String string) {

    DetachedCriteria criteria = DetachedCriteria.forClass(Branche.class);
    criteria.add(Restrictions.ilike("braBezeichnung", string, MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.BrancheDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w w  w .  j  ava 2 s .co  m*/
public ResultObject getAllBranchesLikeText(String text, int start, int pageSize) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Branche.class);

    if (!StringUtils.isEmpty(text)) {
        criteria.add(Restrictions.ilike("braBezeichnung", text, MatchMode.ANYWHERE));
    }

    criteria.addOrder(Order.asc("braBezeichnung"));

    int totalCount = getHibernateTemplate().findByCriteria(criteria).size();

    List<Branche> list = getHibernateTemplate().findByCriteria(criteria, start, pageSize);

    return new ResultObject(list, totalCount);
}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Customer> getCustomersLikeMatchcode(final String string) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.add(Restrictions.ilike("kunMatchcode", string.toUpperCase(), MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Customer> getCustomersLikeOrt(final String string) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.add(Restrictions.ilike("kunOrt", string.toUpperCase(), MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Customer> getCustomersLikeName1(final String string) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.add(Restrictions.ilike("kunName1", string.toUpperCase(), MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Customer> getCustomersLikeName2(final String string) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.add(Restrictions.ilike("kunName2", string.toUpperCase(), MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.OfficeDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w ww  . java  2 s.c o m
public List<Office> getOfficesLikeCity(String string) {

    DetachedCriteria criteria = DetachedCriteria.forClass(Office.class);
    criteria.add(Restrictions.ilike("filOrt", string, MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.OfficeDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/* w  w  w . j a  v a2  s.c  om*/
public List<Office> getOfficesLikeName1(String string) {

    DetachedCriteria criteria = DetachedCriteria.forClass(Office.class);
    criteria.add(Restrictions.ilike("filName1", string, MatchMode.ANYWHERE));

    return getHibernateTemplate().findByCriteria(criteria);
}