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

Source Link

Document

Apply a "like" constraint to the named property

Usage

From source file:com.maydesk.base.gui.user.DlgSelectUser.java

License:Mozilla Public License

private void readFromModel() {
    Criteria criteria = PDHibernateFactory.getSession().createCriteria(MUser.class);
    boolean hasRestriction = false;
    if (!PDUtil.isEmpty(txtLastName.getText())) {
        criteria.add(Restrictions.like("lastName", txtLastName.getText().trim() + "%")); //$NON-NLS-1$ //$NON-NLS-2$
        hasRestriction = true;//  www.  ja va 2s .com
    }
    if (!PDUtil.isEmpty(txtFirstName.getText())) {
        criteria.add(Restrictions.like("firstName", txtFirstName.getText().trim() + "%")); //$NON-NLS-1$ //$NON-NLS-2$
        hasRestriction = true;
    }
    if (!PDUtil.isEmpty(txtLogin.getText())) {
        criteria.add(Restrictions.like("login", txtLogin.getText().trim() + "%")); //$NON-NLS-1$ //$NON-NLS-2$
        hasRestriction = true;
    }
    if (!hasRestriction) {
        criteria.add(Restrictions.isNotNull("lastName")); //$NON-NLS-1$
        criteria.add(Restrictions.not(Restrictions.eq("lastName", ""))); //$NON-NLS-1$ //$NON-NLS-2$
    }
    criteria.addOrder(Order.asc("lastName")); //$NON-NLS-1$
    criteria.addOrder(Order.asc("firstName")); //$NON-NLS-1$
    criteria.setMaxResults(20);
    List<MUser> users = criteria.list();
    tableModel.setValues(users);
    tableModel.fireTableDataChanged();
    if (users.size() > 0) {
        table.getSelectionModel().setSelectedIndex(0, true);
    }
}

From source file:com.mazmy.service.driver.DefaultDriverService.java

/**
 * there are several ways to implement filter pattern like 
 *  - hibernate Criteria/* w ww.  j a va2  s  .  c o m*/
 *  - Spring Data Criteria
 *  - Java Stream
 */
@Transactional
@Override
public List<DriverDO> filter(CarDO carDO) {
    Session session = entityManager.unwrap(Session.class);
    Criteria createCriteria = session.createCriteria(DriverDO.class, "driver").createAlias("driver.car", "car");
    if (null != carDO.getEngineType())
        createCriteria.add(Restrictions.eq("car.engineType", carDO.getEngineType()));
    if (null != carDO.getConvertible())
        createCriteria.add(Restrictions.eq("car.convertible", carDO.getConvertible()));
    if (null != carDO.getLicensePlate())
        createCriteria.add(Restrictions.like("car.licensePlate", carDO.getLicensePlate()));

    return createCriteria.list();
}

From source file:com.micromap.dao.AuthoritiesDAO.java

public Authorities buscaAuthorities(String authority) throws Exception {
    Authorities retorno = null;// w w w.  ja v a  2  s  .  c  o m
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        Criteria criteria = session.createCriteria(Authorities.class);
        criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
        criteria.add(Restrictions.like("authority", authority));
        retorno = (Authorities) criteria.uniqueResult();
    } catch (Exception e) {
        throw new Exception(e.getMessage());
    } finally {
        session.close();
    }
    return retorno;
}

From source file:com.miszcze.java.Model.User.java

public String getUserId(String Login, String Password) {
    temp = (User) getSession().createCriteria(User.class).add(Restrictions.like("Login", Login))
            .add(Restrictions.like("Password", Password)).uniqueResult();
    return temp.UserId;
}

From source file:com.myapp.dao.EmployeeDao.java

public List getAllEmployees(String empname) {

    SessionFactory factory = NewHibernateUtil.getSessionFactory();
    Session session = factory.openSession();
    Criteria crit = session.createCriteria(Employees.class);
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.like("firstName", empname + "%"));
    or.add(Restrictions.like("lastName", empname + "%"));
    crit.add(or);//w w w  .j a  va  2s .  c o  m
    List<Employees> employees = crit.list();
    List emplist = new LinkedList();
    for (Employees obj : employees) {
        String fullname = obj.getFirstName() + " " + obj.getLastName();
        emplist.add(fullname);
    }
    return emplist;
}

From source file:com.mycompany.restful.dao.FeatureDao.java

public JSONObject getFeatures(RequestParams param) {
    Object recordsFiltered = 0, recordsTotal = 0;
    Criteria Features;/*from   w ww  .j a va2  s . c  om*/
    List<Feature> features;
    Session session = null;
    JSONObject obj = new JSONObject();

    try {
        session = sessionFactory.openSession();
        session.beginTransaction();
        Features = session.createCriteria(Feature.class);

        if (!"".equals(param.getValue()) && param.getValue() != null) {
            Criterion rest1 = Restrictions.like("renderingEngine", "%" + param.getValue() + "%");
            Criterion rest2 = Restrictions.like("browser", "%" + param.getValue() + "%");
            Criterion rest3 = Restrictions.like("platform", "%" + param.getValue() + "%");
            Criterion rest4 = Restrictions.like("engineVersion", "%" + param.getValue() + "%");
            Criterion rest5 = Restrictions.like("cssGrade", "%" + param.getValue() + "%");

            Features.add(Restrictions.or(rest1, rest2, rest3, rest4, rest5));
        }
        if (!"".equals(param.getColumn()) && param.getColumn() != null) {
            if ("asc".equals(param.getDir())) {
                Features.addOrder(Order.asc(param.getColumn()));
            } else {
                Features.addOrder(Order.desc(param.getColumn()));
            }
        }
        recordsTotal = session.createCriteria(Feature.class).setProjection(Projections.rowCount()).list()
                .get(0);
        recordsFiltered = Features.list().size();
        Features.setFirstResult(param.getStart()).setMaxResults(param.getLength());
        features = Features.list();
        obj.put("total", recordsTotal);
        obj.put("filtered", recordsFiltered);
        obj.put("data", features);
        session.getTransaction().commit();
    } catch (Exception ex) {
        if (session != null) {
            session.getTransaction().rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return obj;
}

From source file:com.nectra.foodstop.repository.impl.mysql.RestaurantRepositoryImpl.java

@Override
public List<Restaurant> getRestaurantsByName(String name) {
    Criteria criteria = getCurrentSession().createCriteria(Restaurant.class);
    criteria.add(Restrictions.like("name", "%" + name + "%"));
    return criteria.list();
}

From source file:com.openjmsadapter.configuration.database.DatabaseConfigHolder.java

License:Open Source License

public boolean persistConfiguration() throws Exception {
    sessionFactory.getCurrentSession().beginTransaction();
    for (DestinationConfiguration dest_config : config.getDestinations()) {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(JmsDestinationParameters.class);
        criteria.setLockMode(LockMode.UPGRADE);
        criteria.add(Restrictions.like("destinationName", dest_config.getDestinantionName()));
        JmsDestinationParameters param = (JmsDestinationParameters) criteria.uniqueResult();
        param.setLastSequenceReceived(dest_config.getLastSequenceReceived());
        param.setLastSequenceSent(dest_config.getLastSequenceSent());
        sessionFactory.getCurrentSession().save(param);
    }/*www . java  2s .  c  o  m*/
    sessionFactory.getCurrentSession().getTransaction().commit();
    sessionFactory.getCurrentSession().close();
    sessionFactory.close();
    return true;
}

From source file:com.ourlife.dev.modules.sys.service.SystemService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = userDao.createDetachedCriteria();
    User currentUser = UserUtils.getUser();
    dc.createAlias("company", "company");
    if (user.getCompany() != null && user.getCompany().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }/* www  . j ava 2s .  c  om*/
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", 1L));
    }
    dc.add(dataScopeFilter(currentUser, "office", ""));
    // System.out.println(dataScopeFilterString(currentUser, "office", ""));
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }
    dc.add(Restrictions.eq(User.DEL_FLAG, User.DEL_FLAG_NORMAL));
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("id"));
    }
    return userDao.find(page, dc);
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeLicenseDataAccessor.java

public ArrayList<String> getEmployeeIdsByLicenseId(java.lang.String licenseTypeId) throws ExceptionWrapper {
    ArrayList<String> employeeIds = new ArrayList<String>();
    Session session = hibernateTemplate.getSessionFactory().openSession();
    boolean isInTransaction = session.getTransaction() != null;
    Transaction tx = null;/* w  ww.  ja  v a  2  s . c  o m*/
    if (!isInTransaction) {
        tx = session.beginTransaction();
    }
    try {
        Criteria criteria = session.createCriteria(Employeelicensemapping.class);

        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("licensemaster.licenseTypeId", Long.valueOf(licenseTypeId)));
        criteria.add(Restrictions.like("emp.isActive", true));
        for (Object obj : criteria.list()) {
            Employeelicensemapping employeelicensemapping = (Employeelicensemapping) obj;
            employeeIds.add(Long.toString(employeelicensemapping.getEmployee().getEmployeeId()));
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    } finally {
        {
            if (!isInTransaction && tx.isActive()) {
                tx.commit();
            }
            session.close();
        }
    }
    return employeeIds;
}