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, Object value) 

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator)

Usage

From source file:com.apt.facade.AssignmentFacade.java

public int getNumberAssignment(AssignmentFinder finder) {
    List<Assignment> lst = new ArrayList<>();

    Session session = null;//from ww w  .  ja  va 2  s  . c om
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Assignment.class);

        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getAssignmentId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("assignmentId", finder.getAssignmentId())));
        }
        if (finder.getAssignmentName() != null) {
            crit.add(Restrictions
                    .and(Restrictions.ilike("assignmentName", "%" + finder.getAssignmentName() + "%")));
        }
        if (finder.getBatch() != null) {
            crit.add(Restrictions.and(Restrictions.eq("batch", finder.getBatch())));
        }
        if (finder.getSubject() != null) {
            crit.add(Restrictions.and(Restrictions.eq("subject", finder.getSubject())));
        }
        if (finder.getStatus() != null) {
            crit.add(Restrictions.and(Restrictions.eq("status", finder.getStatus())));
        }
        if (finder.getStarttime() != null) {
            crit.add(Restrictions.and(Restrictions.ge("startTime", finder.getStarttime())));
        }
        if (finder.getEndtime() != null) {
            crit.add(Restrictions.and(Restrictions.le("endTime", finder.getEndtime())));
        }

        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst.size();
}

---

From source file:com.apt.facade.BatchFacade.java

public List<Batch> getBatchList(BatchFinder finder, int page, int recordPerPage) {
    List<Batch> lst = new ArrayList<>();

    Session session = null;/* www  .  j ava2s.c  o  m*/
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Batch.class);
        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getBatchId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("batchId", finder.getBatchId())));
        }
        if (finder.getBatchName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("batchName", "%" + finder.getBatchName() + "%")));
        }
        crit.setFirstResult((page - 1) * recordPerPage);
        crit.setMaxResults(recordPerPage);
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst;
}

---

From source file:com.apt.facade.BatchFacade.java

public int getNumberBatch(BatchFinder finder) {
    List<Batch> lst = new ArrayList<>();

    Session session = null;//from w w  w .j  a v  a  2s. co  m
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Batch.class);
        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getBatchId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("batchId", finder.getBatchId())));
        }
        if (finder.getBatchName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("batchName", "%" + finder.getBatchName() + "%")));
        }
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst.size();
}

---

From source file:com.apt.facade.StudentFacade.java

public List<Student> getStudentList(StudentFinder finder, int page, int recordPerPage) {
    List<Student> lst = new ArrayList<>();

    Session session = null;/*from  w  w  w.  j  av a2 s.co m*/
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Student.class);

        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getStudentId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("studentId", finder.getStudentId())));
        }
        if (finder.getStudentName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("studentName", "%" + finder.getStudentName() + "%")));
        }
        if (finder.getBatch() != null) {
            crit.createAlias("batch", "a");
            Criterion rest = Restrictions.or(Restrictions.eq("a.batchId", finder.getBatch().getBatchId()),
                    Restrictions.eq("a.batchName", finder.getBatch().getBatchName()));
            crit.add(Restrictions.and(rest));
        }
        crit.setFirstResult((page - 1) * recordPerPage);
        crit.setMaxResults(recordPerPage);
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst;
}

---

From source file:com.apt.facade.StudentFacade.java

public int getNumberStudent(StudentFinder finder) {
    List<Student> lst = new ArrayList<>();

    Session session = null;//from  w w  w  .j a va 2 s  .  co  m
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Student.class);

        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getStudentId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("studentId", finder.getStudentId())));
        }
        if (finder.getStudentName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("studentName", "%" + finder.getStudentName() + "%")));
        }
        if (finder.getBatch() != null) {
            crit.createAlias("batch", "a");
            Criterion rest = Restrictions.or(Restrictions.eq("a.batchId", finder.getBatch().getBatchId()),
                    Restrictions.eq("a.batchName", finder.getBatch().getBatchName()));
            crit.add(Restrictions.and(rest));
        }

        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst.size();
}

---

From source file:com.apt.facade.SubjectFacade.java

public List<Subject> getSubjectList(SubjectFinder finder, int page, int recordPerPage) {
    List<Subject> lst = new ArrayList<>();

    Session session = null;//w  w w  .j  av a  2 s  .  c  o  m
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Subject.class);
        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getSubjectId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("subjectId", finder.getSubjectId())));
        }
        if (finder.getSubjectName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("subjectName", "%" + finder.getSubjectName() + "%")));
        }
        crit.setFirstResult((page - 1) * recordPerPage);
        crit.setMaxResults(recordPerPage);
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst;
}

---

From source file:com.apt.facade.SubjectFacade.java

public int getNumberSubject(SubjectFinder finder) {
    List<Subject> lst = new ArrayList<>();

    Session session = null;/*from  ww w  .  j  a v  a  2  s. c om*/
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Subject.class);
        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getSubjectId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("subjectId", finder.getSubjectId())));
        }
        if (finder.getSubjectName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("subjectName", "%" + finder.getSubjectName() + "%")));
        }
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst.size();
}

---

From source file:com.callcenter.controller.command.Whom.java

License:Apache License

public void addSearchFilter(DetachedCriteria criteria) {
    String actualNumber = number.replaceAll("\\*", "%").replaceAll("\\?", "_");
    if (type == Whom.Type.TO_AND_FROM) {
        criteria.add(//from   w  ww  . ja v a  2 s.c o m
                Restrictions.or(Restrictions.ilike(Constants.CallRecord.CALLED_ID_PROPERTY_NAME, actualNumber),
                        Restrictions.ilike(Constants.CallRecord.CALLER_ID_PROPERTY_NAME, actualNumber)));
        return;
    }
    if (type == Whom.Type.TO) {
        criteria.add(Restrictions.ilike(Constants.CallRecord.CALLED_ID_PROPERTY_NAME, actualNumber));
        return;
    }
    criteria.add(Restrictions.ilike(Constants.CallRecord.CALLER_ID_PROPERTY_NAME, actualNumber));
}

---

From source file:com.cfs.controller.UsersDAO.java

public List<Users> usuarioPorNome(String nome) throws Exception {
    List<Users> lista = null;
    try {/*w w w .j  av  a2  s. c  o m*/
        session = HibernateUtil.getSessionFactory().openSession();
        Criteria criteria = session.createCriteria(Users.class);
        criteria.add(Restrictions.ilike("nome", "%" + nome + "%"));
        //criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
        lista = criteria.list();
    } catch (Exception e) {
        throw new Exception(e.getMessage());
    } finally {
        session.close();
    }
    return lista;
}

---

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;// w w w  .ja va2 s  .c  o m
    String property = criteria.getProperty();
    Object value = criteria.getValue();

    if (criteria.getOp().equals("=")) {
        criterion = Restrictions.eq(property, value);
    } else if (criteria.getOp().equals(">")) {
        criterion = Restrictions.gt(property, value);
    } else if (criteria.getOp().equals("<")) {
        criterion = Restrictions.lt(property, value);
    } else if (criteria.getOp().equals(">=")) {
        criterion = Restrictions.ge(property, value);
    } else if (criteria.getOp().equals("<=")) {
        criterion = Restrictions.le(property, value);
    } else if (criteria.getOp().equals("in")) {
        criterion = Restrictions.in(property, (Object[]) value);
    } else if (criteria.getOp().equals("like")) {
        criterion = Restrictions.like(property, value);
    } else if (criteria.getOp().equals("ilike")) {
        criterion = Restrictions.ilike(property, value);
    }
    return criterion;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »