Example usage for org.hibernate.criterion Restrictions le

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value) 

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

From source file:com.zdtx.ifms.specific.service.task.FuelMileageManager.java

public Page<Mileageoil> getBetch(Page<Mileageoil> page, FuelMileageVo fmvo) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Mileageoil.class);
    if (fmvo.getVehicleid() != null && fmvo.getVehicleid() != -1) {
        criteria.add(Restrictions.eq("vehicleid", fmvo.getVehicleid()));
    }/*from   w  ww.  j  a v  a2  s . c om*/
    if (fmvo.getTypeid() != null && fmvo.getTypeid() != -1l) {
        criteria.add(Restrictions.eq("typeid", fmvo.getTypeid()));
    }

    if (fmvo.getStartdate() != null && !"".equals(fmvo.getStartdate())) {
        criteria.add(Restrictions.ge("riqi", fmvo.getStartdate()));
    }
    if (fmvo.getEnddate() != null && !"".equals(fmvo.getEnddate())) {
        criteria.add(Restrictions.le("riqi", fmvo.getEnddate()));
    }

    List<Order> orderList = new ArrayList<Order>();
    orderList.add(Order.asc("riqi"));
    Page<Mileageoil> pageResult = baseDao.getBatch(page, criteria.getExecutableCriteria(baseDao.getSession()),
            orderList);
    if (1 == pageResult.getCurrentPage()) {
        Struts2Util.getSession().setAttribute("criteria_export", criteria);
        Struts2Util.getSession().setAttribute("page_export", page);
        Struts2Util.getSession().setAttribute("order_export", orderList);
    }
    return pageResult;
}

---

From source file:com.zhima.base.dao.BaseDao.java

License:Open Source License

/**
 * ?criteriaeq,gt,ge,lt,le?/*www.j a  v  a 2 s. c o  m*/
 * 
 * @param criteria
 * @param list
 *            ??
 */
@SuppressWarnings("rawtypes")
private void setExpression(Criteria criteria, String[] list, String expression, Object dto) {
    Class dtoClass = dto.getClass();
    try {
        for (String str : list) {
            if (str != null && !"".equals(str.trim())) {
                Field dtoField = dtoClass.getDeclaredField(str);
                dtoField.setAccessible(true);
                if (dtoField != null) {
                    if (HibernateConstrant.HIBERNATE_CRITERIA_EQ.equals(expression)) {
                        criteria.add(Restrictions.eq(str, dtoField.get(dto)));
                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_GE.equals(expression)) {
                        criteria.add(Restrictions.gt(str, dtoField.get(dto)));
                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_GT.equals(expression)) {
                        criteria.add(Restrictions.ge(str, dtoField.get(dto)));
                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_LT.equals(expression)) {
                        criteria.add(Restrictions.lt(str, dtoField.get(dto)));
                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_LE.equals(expression)) {
                        criteria.add(Restrictions.le(str, dtoField.get(dto)));

                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_NE.equals(expression)) {
                        criteria.add(Restrictions.ne(str, dtoField.get(dto)));
                    } else if (HibernateConstrant.HIBERNATE_CRITERIA_LIKE.equals(expression)) {
                        criteria.add(Restrictions.like(str, "%" + dtoField.get(dto) + "%"));
                    }
                }

            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

---

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

public long getBuildCount(final Project project, final long after, final long upTo) {
    return getHibernateTemplate().execute(new HibernateCallback<Long>() {
        public Long doInHibernate(Session session) throws HibernateException {
            Criteria criteria = getBuildResultCriteria(session, project, null, false);
            criteria.add(Restrictions.gt("number", after));
            criteria.add(Restrictions.le("number", upTo));
            criteria.setProjection(Projections.rowCount());
            return (Long) criteria.uniqueResult();
        }//  ww w. j  av  a  2s .c o m
    });
}

---

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

private void addDatesToCriteria(long earliestStartTime, long latestStartTime, Criteria criteria) {
    if (earliestStartTime > 0) {
        criteria.add(Restrictions.ge("stamps.startTime", earliestStartTime));
    }//from w  w w . j  a  va2 s . c  o m

    if (latestStartTime > 0) {
        // CIB-446: Don't accept timestamps that are uninitialised
        criteria.add(Restrictions.ge("stamps.startTime", 0L));
        criteria.add(Restrictions.le("stamps.startTime", latestStartTime));
    }
}

---

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

private void addNumbersToCriteria(long lowestNumber, long highestNumber, Criteria criteria) {
    if (lowestNumber > 0) {
        criteria.add(Restrictions.ge("number", lowestNumber));
    }/*from   w  ww  .  j  a  va2s.  c  o m*/

    if (highestNumber > 0) {
        criteria.add(Restrictions.le("number", highestNumber));
    }
}

---

From source file:cpcc.core.services.jobs.JobRepositoryImpl.java

License:Open Source License

/**
 * {@inheritDoc}/*  w ww  . j  a va2  s.co m*/
 */
@SuppressWarnings("unchecked")
@Override
public void removeOldJobs() {
    List<Job> oldJobs = (List<Job>) session.createCriteria(Job.class)
            .add(Restrictions.or(Restrictions.le("end", new Date(System.currentTimeMillis() - maxJobAge)),
                    Restrictions.and(Restrictions.le("end", new Date(System.currentTimeMillis() - 30000)),
                            Restrictions.in("status",
                                    new JobStatus[] { JobStatus.OK, JobStatus.FAILED, JobStatus.NO_FACTORY }))))
            .list();

    for (Job job : oldJobs) {
        logger.debug("Removing old job " + job.getId() + " " + job.getQueued() + " " + job.getQueueName() + " "
                + job.getParameters());

        session.delete(job);
    }
}

---

From source file:cpcc.core.services.RealVehicleRepositoryImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from   w ww.  j  a va 2s  .co m
 */
@Override
public void cleanupOldVehicleStates() {
    @SuppressWarnings("unchecked")
    List<RealVehicleState> oldRvStates = (List<RealVehicleState>) session.createCriteria(RealVehicleState.class)
            .add(Restrictions.le("lastUpdate", new Date(timeService.currentTimeMillis() - TOO_OLD_TO_REMEMBER)))
            .list();

    oldRvStates.stream().forEach(x -> session.delete(x));
}

---

From source file:cpcc.vvrte.services.db.VvRteRepositoryImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from  ww  w .  ja va2  s  .c  o m
 */
@SuppressWarnings("unchecked")
@Override
public List<VirtualVehicle> findAllStuckVehicles(Set<VirtualVehicleState> allowedStates) {
    List<VirtualVehicle> vvs = new ArrayList<VirtualVehicle>();

    vvs.addAll(
            (List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class, "v")
                    .add(Restrictions.in("state", allowedStates)).createCriteria("v.task", "t",
                            JoinType.LEFT_OUTER_JOIN, Restrictions.eq("taskState", TaskState.COMPLETED))
                    .list());

    vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class)
            .add(Restrictions.eq("state", VirtualVehicleState.TASK_COMPLETION_AWAITED))
            .add(Restrictions.isNull("task")).list());

    vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class)
            .add(Restrictions.eq("state", VirtualVehicleState.MIGRATION_AWAITED_SND))
            .add(Restrictions.le("migrationStartTime", new Date(timeService.currentTimeMillis() - 10000)))
            .list());

    vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class).add(Restrictions.in("state",
            Arrays.asList(VirtualVehicleState.MIGRATING_SND, VirtualVehicleState.MIGRATION_INTERRUPTED_SND,
                    VirtualVehicleState.MIGRATION_COMPLETED_SND)))
            .add(Restrictions.le("updateTime", new Date(timeService.currentTimeMillis() - 55000))).list());

    vvs.addAll((List<VirtualVehicle>) session.createCriteria(VirtualVehicle.class)
            .add(Restrictions.eq("state", VirtualVehicleState.MIGRATING_RCV))
            .add(Restrictions.le("updateTime", new Date(timeService.currentTimeMillis() - 175000))).list());

    return vvs;
}

---

From source file:CRUD.Materiais.MateriaisController.java

public static void avisoEstoque() {
    Session ses = HibernateUtil.getSessionFactory().openSession();
    Transaction trans = ses.beginTransaction();
    List lista;//from  ww w. j  a v a  2  s. c om

    Criteria query = ses.createCriteria(Materiais.class);
    query.add(Restrictions.le("quantidade", 10));
    lista = query.list();
    if (!lista.isEmpty()) {
        new NotificacaoEstoque(lista).setVisible(true);
    }
}

---

From source file:cz.jirutka.rsql.hibernate.AbstractCriterionBuilder.java

License:Open Source License

/**
 * Apply a "less than or equal" constraint to the named property.
 * //w ww  .j a v  a 2s  .c o  m
 * @param propertyPath property name prefixed with an association alias
 * @param argument value
 * @return Criterion
 */
protected Criterion createLessEqual(String propertyPath, Object argument) {
    return Restrictions.le(propertyPath, argument);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »