Example usage for org.hibernate.criterion Restrictions like

Introduction

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

Prototype

public static SimpleExpression like(String propertyName, Object value)

Source Link

Document

Apply a "like" constraint to the named property

Usage

From source file:com.cimmyt.model.dao.impl.LocationCatalogDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, LocationCatalog filter) {
    // TODO Auto-generated method stub
    if (filter.getLocationid() != null) {
        criteria.add(Restrictions.eq("locationid", filter.getLocationid()));
    }/*from www  .jav  a 2 s.  c  o  m*/

    if (filter.getLocation_name() != null && !filter.getLocation_name().isEmpty()) {
        criteria.add(Restrictions.like("location_name", "%" + filter.getLocation_name() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.ProjectDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, Project filter) {
    if (filter.getProjectid() != null) {
        criteria.add(Restrictions.eq("projectid", filter.getProjectid()));
    }//from  ww  w  .jav  a2  s  . com
    if (filter.getProjectname() != null && !filter.getProjectname().isEmpty()) {
        criteria.add(Restrictions.like("projectname", "%" + filter.getProjectname() + "%"));
    }
    if (filter.getProjectdescription() != null && !filter.getProjectdescription().isEmpty()) {
        criteria.add(Restrictions.like("projectdescription", "%" + filter.getProjectdescription() + "%"));
    }
    if (filter.getPurposename() != null && !filter.getPurposename().isEmpty()) {
        criteria.add(Restrictions.like("purposename", "%" + filter.getPurposename() + "%"));
    }
    if (filter.getPurposedescription() != null && !filter.getPurposedescription().isEmpty()) {
        criteria.add(Restrictions.like("purposedescription", "%" + filter.getPurposedescription() + "%"));
    }
    criteria.addOrder(Order.desc("projectid"));
}

From source file:com.cimmyt.model.dao.impl.SeasonDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, Season filter) {
    // TODO Auto-generated method stub
    // TODO Auto-generated method stub
    if (filter.getSeasonid() != null) {
        criteria.add(Restrictions.eq("seasonid", filter.getSeasonid()));
    }//from ww  w  .  ja v a 2s .co  m

    if (filter.getSeason_name() != null && !filter.getSeason_name().isEmpty()) {
        criteria.add(Restrictions.like("season_name", "%" + filter.getSeason_name() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.ShipmentDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, Shipment filter) {

    if (filter.getComment() != null) {
        criteria.add(Restrictions.like("comment", "%" + filter.getComment() + "%"));
    }/*from   w ww .ja  v  a  2s  .co  m*/
    if (filter.getIsSentToKB() != null) {
        criteria.add(Restrictions.eq("isSentToKB", filter.getIsSentToKB()));
    }
}

From source file:com.cimmyt.model.dao.impl.ShipmentSetsDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, ShipmentSet filter) {
    if (filter.getComments() != null) {
        criteria.add(Restrictions.like("comments", "%" + filter.getComments() + "%"));
    }//from   w  w  w  .j a  v  a2  s. co m
    if (filter.getStInvestigator() != null && filter.getStInvestigator().getInvest_name() != null
            && !filter.getStInvestigator().getInvest_name().isEmpty()) {
        criteria.createAlias("stInvestigator", "invest");
        criteria.add(Restrictions.like("invest.invest_name",
                "%" + filter.getStInvestigator().getInvest_name() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.StatusDAOImpl.java

License:Apache License

/**
 * /*from   w  ww . j  ava2 s.  co  m*/
 * @param criteria
 * @param companyFilter
 */
protected void buildCriteria(DetachedCriteria criteria, Status statusFilter) {
    if (statusFilter.getIdStatus() != null) {
        criteria.add(Restrictions.eq("idStatus", statusFilter.getIdStatus()));
    }

    if (statusFilter.getStatusDescription() != null
            && statusFilter.getStatusDescription().trim().length() > 0) {
        criteria.add(Restrictions.like("name", "%" + statusFilter.getStatusDescription() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.StudyTemplateDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, StudyTemplate filter) {
    if (filter.getStudytemplateid() != null) {
        criteria.add(Restrictions.eq("studytemplateid", filter.getStudytemplateid()));
    }//from www .  j av  a2  s .co  m

    if (StrUtils.notEmpty(filter.getTemplatename())) {
        criteria.add(Restrictions.like("templatename", "%" + filter.getTemplatename() + "%"));
    }

}

From source file:com.cimmyt.model.dao.impl.TissueDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, Tissue filter) {
    // TODO Auto-generated method stub
    if (filter.getIdtissue() != null) {
        criteria.add(Restrictions.eq("idtissue", filter.getIdtissue()));
    }//from  w  w w.j  a  v  a  2  s.c  o  m

    if (filter.getTissueName() != null && !filter.getTissueName().isEmpty()) {
        criteria.add(Restrictions.like("tissuename", "%" + filter.getTissueName() + "%"));
    }
}

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

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;/*from  w ww  .  j ava 2 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;
}

From source file:com.collaborativeclouds.workers.ParkingData.java

public String getSlotofUser(String username) {
    try {/*from   w w w  .  j  a  va 2 s  .c o  m*/
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        List<Parking> mPark = null;
        Criteria mCriteria = mSession.createCriteria(Parking.class);
        mCriteria.add(Restrictions.like("username", username));
        mPark = mCriteria.list();
        String json = new Gson().toJson(mPark);
        return json;
    } catch (Exception ex) {
        return "Failed";
    }
}