Example usage for org.hibernate.criterion Restrictions like

List of usage examples for org.hibernate.criterion Restrictions like

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. like

Introduction

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

Prototype

public static SimpleExpression like(String propertyName, String value, MatchMode matchMode)

Source Link

Document

Apply a "like" constraint to the named property using the provided match mode

Usage

From source file:com.inkubator.hrm.dao.impl.BankGroupDaoImpl.java

private void doSearchByParam(BankGroupSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }// w  w w.  jav  a2 s . c  om
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

From source file:com.inkubator.hrm.dao.impl.BatchJobExecutionDaoImpl.java

@Override
public List<BatchJobExecution> getByParam(BatchJobExecutionSearchParameter parameter, int firstResult,
        int maxResults, Order orderable) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("batchJobInstance", "batchJobInstance", JoinType.INNER_JOIN);

    if (parameter.getJobName() != null) {

        //            criteria.createAlias("batchJobInstance", "bj", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("batchJobInstance.jobName", parameter.getJobName(), MatchMode.ANYWHERE));
    }/*from  ww w. j  a v a2s.  com*/
    if (parameter.getStatus() != null) {
        criteria.add(Restrictions.like("BatchJobExecution", parameter.getStatus()));
    }
    criteria.addOrder(orderable);
    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    //criteria.setFetchMode("batchJobInstance", FetchMode.JOIN);
    return criteria.list();
}

From source file:com.inkubator.hrm.dao.impl.BatchJobExecutionDaoImpl.java

@Override
public Long getTotalByParam(BatchJobExecutionSearchParameter parameter) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    if (parameter.getJobName() != null) {
        criteria.createAlias("batchJobInstance", "bj", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("bj.jobName", parameter.getJobName(), MatchMode.ANYWHERE));
    }//from  w  ww.  j  a v  a 2  s  .  co  m
    if (parameter.getStatus() != null) {
        criteria.add(Restrictions.like("BatchJobExecution", parameter.getStatus()));
    }
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.inkubator.hrm.dao.impl.BioDataDaoImpl.java

private void doSearchBioDataByParam(BioDataSearchParameter parameter, Criteria criteria) {
    if (parameter.getName() != null) {
        //            criteria.add(Restrictions.like("firstName", parameter.getParameter(), MatchMode.ANYWHERE));
        //            Disjunction disjunction = Restrictions.disjunction();
        //            disjunction.add(Restrictions.like("firstName", parameter.getName(), MatchMode.ANYWHERE));
        //            disjunction.add(Restrictions.like("lastName", parameter.getName(), MatchMode.ANYWHERE));
        //            criteria.add(disjunction);

        criteria.createAlias("religion", "religion", JoinType.INNER_JOIN);
        criteria.createAlias("maritalStatus", "maritalStatus", JoinType.INNER_JOIN);
        criteria.add(Restrictions.ilike("combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
    }//  w w  w. ja  v a2 s. c  o  m

    if (parameter.getEmailAddress() != null) {
        criteria.add(Restrictions.like("personalEmail", parameter.getEmailAddress(), MatchMode.ANYWHERE));
    }
    if (parameter.getNickName() != null) {
        criteria.add(Restrictions.like("nickname", parameter.getNickName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));

}

From source file:com.inkubator.hrm.dao.impl.BioDataDaoImpl.java

@Override
public List<BioData> getByName(String name) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //        criteria.createAlias("empDatas", "emp",JoinType.INNER_JOIN);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("firstName", name, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("lastName", name, MatchMode.ANYWHERE));

    criteria.add(disjunction);/*from  w w  w .j a va  2s  .  com*/
    criteria.add(Restrictions.isEmpty("empDatas"));
    criteria.addOrder(Order.asc("firstName"));
    criteria.setFirstResult(0);
    criteria.setMaxResults(7);
    return criteria.list();
}

From source file:com.inkubator.hrm.dao.impl.BioPotensiSwotDaoImpl.java

public void doSearchByParam(BioPotensiSwotSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
        disjunction.add(Restrictions.like("bio.lastName", searchParameter.getName(), MatchMode.START));
        criteria.add(disjunction);//ww w  . ja  v a  2s .c  om
    }
    criteria.add(Restrictions.isNotNull("id"));
}

From source file:com.inkubator.hrm.dao.impl.BioRelasiPerusahaanDaoImpl.java

public void doSearchByParam(BioRelasiPerusahaanSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
        disjunction.add(Restrictions.like("bio.lastName", searchParameter.getName(), MatchMode.START));
        criteria.add(disjunction);/* w ww . j a  v  a2  s .  c o m*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

From source file:com.inkubator.hrm.dao.impl.CareerTerminationTypeDaoImpl.java

private void doSearchTerminationTypeByParam(CareerTerminationTypeSearchParameter searchParameter,
        Criteria criteria) {/*from  w  w w . j  a v  a  2 s  .  c  o  m*/
    criteria.createAlias("systemLetterReference", "systemLetterReference", JoinType.INNER_JOIN);
    criteria.createAlias("systemCareerConst", "systemCareerConst", JoinType.INNER_JOIN);
    if (StringUtils.isNotBlank(searchParameter.getCode())) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotBlank(searchParameter.getName())) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

From source file:com.inkubator.hrm.dao.impl.DivisiDaoImpl.java

private void doSearchByParam(DivisiSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from w w w  .j  ava2  s . c  o  m
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

private void doSearchByParam(Long companyId, EmpDataSearchParameter dataSearchParameter, Criteria criteria) {

    /**//from   w w w.j a v  a  2 s.co m
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, companyId);
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));
    criteria.createAlias("wtGroupWorking", "wtGroupWorking", JoinType.INNER_JOIN);
    if (dataSearchParameter.getJabatanKode() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.code", dataSearchParameter.getJabatanKode(),
                MatchMode.START));
    }

    if (dataSearchParameter.getJabatanName() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.name", dataSearchParameter.getJabatanName(),
                MatchMode.ANYWHERE));
    }

    if (dataSearchParameter.getNIK() != null) {
        criteria.add(Restrictions.like("nik", dataSearchParameter.getNIK(), MatchMode.START));
    }
    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    if (dataSearchParameter.getName() != null) {
        //            Disjunction disjunction = Restrictions.disjunction();
        //            disjunction.add(Restrictions.like("bioData.firstName", dataSearchParameter.getName(), MatchMode.START));
        //            disjunction.add(Restrictions.like("bioData.lastName", dataSearchParameter.getName(), MatchMode.START));
        //            criteria.add(disjunction);
        criteria.add(Restrictions.ilike("bioData.combineName", dataSearchParameter.getName().toLowerCase(),
                MatchMode.ANYWHERE));
    }
}