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:chiron.maxscore.service.impl.CourseServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Course.class);

    if (condition == null) {
        return criteria;
    }//from   w ww. java  2  s .  com

    if (condition.containsKey("course_name")) {
        criteria.add(
                Restrictions.ilike("courseName", condition.get("course_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.GradeServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Grade.class);

    if (condition == null) {
        return criteria;
    }/* w  w w . ja  v  a2  s . c  o  m*/

    criteria.createAlias("specialty", "s");
    criteria.createAlias("s.college", "c");

    if (condition.containsKey("college_id")) {
        criteria.add(Restrictions.eq("c.id", condition.get("college_id")));
    } else if (condition.containsKey("specialty_id")) {
        criteria.add(Restrictions.eq("s.id", condition.get("specialty_id")));
    }

    if (condition.containsKey("grade_name")) {
        criteria.add(
                Restrictions.ilike("gradeName", condition.get("grade_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.MenuServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Menu.class);

    if (condition == null) {
        return criteria;
    }// www .j a  v  a  2  s .c o  m
    if (condition.containsKey("menu_title")) {
        criteria.add(
                Restrictions.ilike("menuTitle", condition.get("menu_title").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.ModuleServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Module.class);

    if (condition == null) {
        return criteria;
    }/*from   w  ww  .  j av  a  2 s .  c o  m*/

    if (condition.containsKey("module_type")) {
        criteria.add(Restrictions.eq("moduleType", condition.get("module_type")));
    }

    if (condition.containsKey("module_name")) {
        criteria.add(
                Restrictions.ilike("moduleName", condition.get("module_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Option.class);

    if (condition == null) {
        return criteria;
    }/*from www.  j a  va  2s .c om*/

    if (condition.containsKey("option_name")) {
        criteria.add(
                Restrictions.ilike("optionName", condition.get("option_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.RoleServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Role.class);

    if (condition == null) {
        return criteria;
    }/*from  ww  w.j  a v  a 2  s  . com*/

    if (condition.containsKey("role_name")) {
        criteria.add(Restrictions.ilike("roleName", condition.get("role_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.SpecialtyServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Specialty.class);

    if (condition == null) {
        return criteria;
    }/*ww  w.ja  v a  2 s  .c  om*/

    if (condition.containsKey("college_id")) {
        criteria.createAlias("college", "c").add(Restrictions.eq("c.id", condition.get("college_id")));
    }

    if (condition.containsKey("specialty_name")) {
        criteria.add(Restrictions.ilike("specialtyName", condition.get("specialty_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.TeacherServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Teacher.class);

    if (condition == null) {
        return criteria;
    }/*from   w w  w .  j a  v a 2s. c o m*/

    if (condition.containsKey("teacher_name")) {
        criteria.add(Restrictions.ilike("teacherName", condition.get("teacher_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:co.utb.softeng.contactsapp.dao.impl.CitaDAOImpl.java

@Override
public List<Cita> getByContactName(String contactName) {

    DetachedCriteria subQuery = DetachedCriteria.forClass(Contact.class).createCriteria("citas")
            .add(Restrictions.ilike("name", contactName, MatchMode.ANYWHERE)).setProjection(Projections.id());

    Criteria mainCriteria = getSession().createCriteria(Cita.class).add(Subqueries.propertyIn("id", subQuery))
            .setFetchMode("contacts", FetchMode.JOIN);

    return mainCriteria.list();
}

From source file:co.utb.softeng.contactsapp.dao.impl.ContactDAOImpl.java

public List<Contact> getByName(String name) {
    return getSession().createCriteria(Contact.class).add(Restrictions.ilike("name", name, MatchMode.ANYWHERE))
            .setFetchMode("citas", FetchMode.JOIN).list();
}