Example usage for org.hibernate.criterion Restrictions gt

Introduction

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

Prototype

public static SimpleExpression gt(String propertyName, Object value) 

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

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

License:Open Source License

/**
 * ?criteriaeq,gt,ge,lt,le?//from   www. j  ava2 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 List<BuildResult> findCompletedSince(final Project[] projects, final long sinceTime) {
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = session.createCriteria(BuildResult.class);
            criteria.add(Restrictions.isNull("user"));
            addProjectsToCriteria(projects, criteria);
            criteria.add(Restrictions.gt("stamps.endTime", sinceTime));
            criteria.addOrder(Order.desc("id"));
            return criteria.list();
        }/*from w w w .  java2  s.  c  om*/
    });
}

---

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();
        }/*from   w w w .j a va2  s  .  c  om*/
    });
}

---

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

License:Apache License

public List<BuildResult> queryBuildsWithMessages(final Project[] projects, final Feature.Level level,
        final int max) {
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = session.createCriteria(BuildResult.class);
            criteria.add(Restrictions.isNull("user"));
            addProjectsToCriteria(projects, criteria);
            criteria.add(Restrictions.gt(level.toString().toLowerCase() + "FeatureCount", 0));

            if (max >= 0) {
                criteria.setMaxResults(max);
            }/*from www .j  av a  2s . c o  m*/

            criteria.addOrder(Order.desc("id"));
            return criteria.list();
        }
    });
}

---

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

License:Apache License

public List<BuildResult> findByAfterBuild(final long buildId, final int maxResults,
        final ResultState... states) {
    final BuildResult result = findById(buildId);
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = getBuildResultCriteria(session, result.getProject(), states,
                    result.isPersonal());
            criteria.add(Restrictions.gt("id", buildId));
            if (result.isPersonal()) {
                criteria.add(Restrictions.eq("user", result.getUser()));
            }/*from  w  w  w  .j a  v a 2s .  c o m*/
            criteria.addOrder(Order.asc("id"));
            criteria.setMaxResults(maxResults);
            return criteria.list();
        }
    });
}

---

From source file:controlers.GuestControler.java

public String traziFestivale() {

    porukaZaPretragu = "";
    Session session = null;/*from   ww  w .  j  a  va  2  s .  c om*/
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(Festival.class);

        if (nazivFestivala != null && !nazivFestivala.equals("") && !nazivFestivala.equals(" "))
            cr.add(Restrictions.like("naziv", "%" + nazivFestivala + "%"));
        if (datumOd != null)
            cr.add(Restrictions.gt("datumVremeOd", datumOd));
        if (datumDo != null)
            cr.add(Restrictions.lt("datumVremeOd", datumDo));
        if (mesto != null && !mesto.equals("") && !mesto.equals(" "))
            cr.add(Restrictions.like("mesto", "%" + mesto + "%"));

        List result = cr.list();
        if (izvodjac != null && !izvodjac.equals("") && !izvodjac.equals(" ")) {
            for (int j = 0; j < result.size(); j++) {
                Festival oneFest = (Festival) result.get(j);
                if (oneFest.getIzvodjacs() != null && oneFest.getIzvodjacs().size() > 0) {
                    boolean founded = false;
                    for (Izvodjac izv : (Set<Izvodjac>) oneFest.getIzvodjacs())
                        if (izv.getNaziv().toLowerCase().contains(izvodjac.toLowerCase())) {
                            founded = true;
                            break;
                        }
                    if (!founded) {
                        result.remove(oneFest);
                        j--;
                    }
                } else {
                    result.remove(oneFest);
                    j--;
                }
            }
        }
        trazeniFestivali = (List<Festival>) result;
    } catch (Exception ex) {
        if (tx != null)
            tx.rollback();
        ex.printStackTrace();
    } finally {
        if (tx != null)
            tx.commit();
        session.close();
    }

    return "indexguest";
}

---

From source file:controlers.UserControler.java

public String traziFestivale() {

    porukaZaPretragu = "";
    Session session = null;/*  w  w  w.  j av a 2s .  c  o m*/
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(Festival.class);

        if (nazivFestivala != null && !nazivFestivala.equals("") && !nazivFestivala.equals(" "))
            cr.add(Restrictions.like("naziv", "%" + nazivFestivala + "%"));
        if (datumOd != null)
            cr.add(Restrictions.gt("datumVremeOd", datumOd));
        if (datumDo != null)
            cr.add(Restrictions.lt("datumVremeOd", datumDo));
        if (mesto != null && !mesto.equals("") && !mesto.equals(" "))
            cr.add(Restrictions.like("mesto", "%" + mesto + "%"));
        cr.add(Restrictions.gt("datumVremeDo", new Date()));
        List result = cr.list();
        if (izvodjac != null && !izvodjac.equals("") && !izvodjac.equals(" ")) {
            for (int j = 0; j < result.size(); j++) {
                Festival oneFest = (Festival) result.get(j);
                if (oneFest.getIzvodjacs() != null && oneFest.getIzvodjacs().size() > 0) {
                    boolean founded = false;
                    for (Izvodjac izv : (Set<Izvodjac>) oneFest.getIzvodjacs())
                        if (izv.getNaziv().toLowerCase().contains(izvodjac.toLowerCase())) {
                            founded = true;
                            break;
                        }
                    if (!founded) {
                        result.remove(oneFest);
                        j--;
                    }
                } else {
                    result.remove(oneFest);
                    j--;
                }
            }
        }
        trazeniFestivali = (List<Festival>) result;
    } catch (Exception ex) {
        if (tx != null)
            tx.rollback();
        ex.printStackTrace();
    } finally {
        if (tx != null)
            tx.commit();
        session.close();
    }

    return "index";
}

---

From source file:corner.service.tree.TreeService.java

License:Apache License

/**
 * /*  w w  w.ja va 2  s. co m*/
 * @param page 
 * 
 * @param clazz class
 * @param depend 
 * @param depth   ?
 */
public List getDepthTree(IPage page, Class clazz, String[] depends, int depth, int left, int right) {
    DetachedCriteria criteria = DetachedCriteria.forClass(clazz);

    if (depth == 1) {
        //         select * from MP_S_ACCOUNT_ITEM_CODE where tree_depth = 1;
        criteria.add(Restrictions.eq(ITreeAdaptor.DEPTH_PRO_NAME, depth));
    } else {
        //         select * from MP_S_ACCOUNT_ITEM_CODE where tree_depth = 2 and tree_left_code > 1 and tree_right_code < 8;
        Criterion leftright = Restrictions.and(Restrictions.gt(ITreeAdaptor.LEFT_PRO_NAME, left),
                Restrictions.lt(ITreeAdaptor.RIGHT_PRO_NAME, right));
        criteria.add(Restrictions.and(Restrictions.eq(ITreeAdaptor.DEPTH_PRO_NAME, depth), leftright));
    }

    //
    if (page instanceof ITreeQueryPage) {
        ((ITreeQueryPage) page).appendCriteria(criteria, depends);
    }

    criteria.addOrder(Order.asc(ITreeAdaptor.LEFT_PRO_NAME));

    return findByCriteria(criteria);
}

---

From source file:corner.services.tree.AbstractMoveTreeNodeProcessor.java

License:Apache License

/**
 * //from ww w. ja  va 2  s.com
 * 
 * @return 
 */
protected TreeAdapter getParentNode() {
    if (this.parentNode != null) {
        return this.parentNode;
    }
    if (node.getDepth() > 1) {// ?,?

        List<?> list = service.executeFind(new HibernateCallback() {

            public Object doInHibernate(Session session) throws HibernateException, SQLException {
                Criteria criteria = session.createCriteria(treeClassName);
                /**
                 * ?  ??? ?? ? -1
                 */
                criteria.add(Restrictions.gt(TreeAdapter.RIGHT_PRO_NAME, node.getRight()))
                        .add(Restrictions.lt(TreeAdapter.LEFT_PRO_NAME, node.getLeft()));
                criteria.addOrder(Order.desc(TreeAdapter.LEFT_PRO_NAME));

                criteria.setFirstResult(0);
                criteria.setMaxResults(1);
                return criteria.list();
            }
        });

        if (list.size() != 1) { //
            throw new RuntimeException("?(" + node.getLeft() + "," + node.getRight()
                    + ")");
        }
        parentNode = (TreeAdapter) list.get(0);
    } else { // ,?

        parentNode = constructRootNode();

    }
    return parentNode;
}

---

From source file:corner.services.tree.MoveDownProcessor.java

License:Apache License

@Override
protected void appendQueryReplaceNodeCriteria(Criteria criteria) {
    criteria.add(Restrictions.gt(TreeAdapter.RIGHT_PRO_NAME, getCurrentNode().getRight()))
            .add(Restrictions.lt(TreeAdapter.RIGHT_PRO_NAME, getParentNode().getRight()));
    criteria.addOrder(Order.asc(TreeAdapter.LEFT_PRO_NAME));

}

---

• «
• 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
• »