Example usage for org.hibernate.criterion Restrictions ne

Introduction

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

Prototype

public static SimpleExpression ne(String propertyName, Object value) 

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:com.zl.bgec.basicapi.shop.service.impl.ShopServiceImpl.java

@Override
@Transactional(readOnly = true)//from  w ww .  j  a v  a  2s .c om
public Shop getShopNo(String memberNo) throws Exception {
    Criteria criteria = shopDao.createCriteria(Restrictions.eq("memberNo", memberNo));
    criteria.add(Restrictions.ne("status", "3"));//
    return (Shop) criteria.uniqueResult();
}

---

From source file:controlers.AdminControler.java

public AdminControler() {
    Session session = null;//from ww  w .j  a  va  2 s .  c o m
    Transaction tx = null;
    try {
        session = HibernateUtil.getSessionFactory().openSession();
        tx = session.beginTransaction();

        String sql = "SELECT R.idRez, K.username, F.naziv AS nazivFestivala, R.paket, D.redniBroj AS kojiDan, R.brojUlaznica, R.vremeRez, F.cenaPaket, F.cenaDan "
                + "FROM `rezervacija` R, `korisnik` K, `festival` F, `Dan` D "
                + "WHERE R.username = K.username " + "AND R.idFest = F.idFest " + "AND R.idDan = D.idDan "
                + "AND R.status = 'rezervacija' " + "AND R.vremeRez < :current_date " + "GROUP BY R.idRez "
                + "ORDER BY R.vremeRez DESC;";

        SQLQuery query = session.createSQLQuery(sql);
        query.setParameter("current_date", new Date());
        query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
        sveRezervacije = query.list();

        Criteria cr = session.createCriteria(Festival.class);
        cr.add(Restrictions.ne("status", "prosao"));
        cr.add(Restrictions.ne("status", "otkazan"));
        cr.addOrder(Order.asc("datumVremeDo"));
        List result = cr.list();

        aktuelniFestivali = new HashMap<String, Long>();
        for (Object obj : result) {
            Festival festival = (Festival) obj;
            aktuelniFestivali.put(festival.getNaziv(), festival.getIdFest());
        }

    } catch (Exception ex) {
        if (tx != null)
            tx.rollback();
        ex.printStackTrace();
    } finally {
        if (tx != null)
            tx.commit();
        session.close();
    }
}

---

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

License:Open Source License

/**
 * {@inheritDoc}/* w  ww .  j  a  va2  s.c o  m*/
 */
@SuppressWarnings("unchecked")
@Override
public List<SensorDefinition> findAllVisibleSensorDefinitions() {
    return (List<SensorDefinition>) session.createCriteria(SensorDefinition.class)
            .add(Restrictions.ne("visibility", SensorVisibility.NO_VV)).list();
}

---

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

License:Open Source License

/**
 * Apply a "not equal" constraint to the named property.
 * //from   ww  w. j a va 2s  .c o m
 * @param propertyPath property name prefixed with an association alias
 * @param argument value
 * @return Criterion
 */
protected Criterion createNotEqual(String propertyPath, Object argument) {
    return Restrictions.ne(propertyPath, argument);
}

---

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

License:Open Source License

@Test
public void testCreateCriterion3args() {
    String property = "foo";
    Criterion exptected;//w w w . j a  v  a 2s.co m
    Criterion actual;

    exptected = Restrictions.eq(property, "bar");
    actual = instance.createCriterion(property, Comparison.EQUAL, "bar");
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.ilike(property, "bar%");
    actual = instance.createCriterion(property, Comparison.EQUAL, "bar*");
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.ne(property, "bar");
    actual = instance.createCriterion(property, Comparison.NOT_EQUAL, "bar");
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.not(Restrictions.ilike(property, "%bar"));
    actual = instance.createCriterion(property, Comparison.NOT_EQUAL, "*bar");
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.gt(property, 42);
    actual = instance.createCriterion(property, Comparison.GREATER_THAN, 42);
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.ge(property, -42);
    actual = instance.createCriterion(property, Comparison.GREATER_EQUAL, -42);
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.lt(property, 42.2);
    actual = instance.createCriterion(property, Comparison.LESS_THAN, 42.2);
    assertEquals(exptected.toString(), actual.toString());

    exptected = Restrictions.le(property, -42.2);
    actual = instance.createCriterion(property, Comparison.LESS_EQUAL, -42.2);
    assertEquals(exptected.toString(), actual.toString());

}

---

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

License:Open Source License

@Test
public void testPushCriterionBuilder() {
    MockRSQL2CriteriaConverterImpl converter = new MockRSQL2CriteriaConverterImpl(sessionFactory);
    converter.setMapper(mapper);/*w  w w.ja  v a 2  s  . c  o m*/

    converter.pushCriterionBuilder(new MockCriterionBuilder() {
        @Override
        public Criterion createCriterion(String property, Comparison operator, String argument,
                Class<?> entityClass, String alias, CriteriaBuilder parent)
                throws ArgumentFormatException, UnknownSelectorException {
            fail("Should be at the bottom of builders stack");
            return null;
        }
    });

    converter.pushCriterionBuilder(new MockCriterionBuilder() {
        @Override
        public Criterion createCriterion(String property, Comparison operator, String argument,
                Class<?> entityClass, String alias, CriteriaBuilder parent)
                throws ArgumentFormatException, UnknownSelectorException {
            // ok
            return Restrictions.ne("foo", "notbar");
        }
    });

    converter.pushCriterionBuilder(new MockCriterionBuilder() {
        @Override
        public boolean accept(String selector, Class<?> entityClass, CriteriaBuilder parent) {
            return false;
        }

        @Override
        public Criterion createCriterion(String property, Comparison operator, String argument,
                Class<?> entityClass, String alias, CriteriaBuilder parent)
                throws ArgumentFormatException, UnknownSelectorException {
            fail("Should not be accepted");
            return null;
        }
    });

    Expression expression = new ComparisonExpression("foo", Comparison.EQUAL, "bar");

    DetachedCriteria expResult = DetachedCriteria.forClass(Course.class).add(Restrictions.ne("foo", "notbar"));

    DetachedCriteria result = DetachedCriteria.forClass(Course.class);
    converter.createInnerBuilder(Course.class).convert(expression, result);

    assertEquals(expResult.toString(), result.toString());
}

---

From source file:cz.jirutka.rsql.visitor.hibernate.HibernateCriterionVisitor.java

License:Apache License

@Override
public Criterion visit(ComparisonNode node) {
    String name = node.getSelector();
    /*/*  w  w  w  .ja v a  2  s  . c  om*/
     Get the path and property names
     */
    Tuple<Type, String>[] path = getPath(root, name);
    Type type = getType(path);
    boolean isPrimitive = type instanceof StringRepresentableType;
    boolean isCustom = type instanceof CustomType;
    boolean isCollection = type instanceof CollectionType;

    String exp = getExpression(path, isCollection);
    List<Object> arguments = new ArrayList<Object>(node.getArguments().size());
    for (String argument : node.getArguments()) {
        Object value = argument;
        if (isPrimitive) {
            value = ((StringRepresentableType) type).fromStringValue((String) value);
        } else if (isCustom) {
            value = ((CustomType) type).stringToObject((String) value);
        } else if (isCollection) {
            value = IntegerType.INSTANCE.fromString((String) value);
        }
        if (value instanceof String) {
            value = toSqlWildcardString((String) value);
        }
        arguments.add(value);
    }
    ComparisonOperator operator = node.getOperator();

    assert arguments.size() >= 1;

    Object firstArgument = arguments.get(0);
    if (operator.equals(RSQLOperators.EQUAL)) {
        if (!isCollection) {
            if (String.class.isInstance(firstArgument) && ((String) firstArgument).contains("%")) {
                return Restrictions.ilike(exp, firstArgument);
            } else {
                return Restrictions.eq(exp, firstArgument);
            }
        } else {
            return Restrictions.sizeEq(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.NOT_EQUAL)) {
        if (!isCollection) {
            if (String.class.isInstance(firstArgument) && ((String) firstArgument).contains("%")) {
                return Restrictions.not(Restrictions.ilike(exp, firstArgument));
            } else {
                return Restrictions.ne(exp, firstArgument);
            }
        } else {
            return Restrictions.sizeNe(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.GREATER_THAN)) {
        if (!isCollection) {
            return Restrictions.gt(exp, firstArgument);
        } else {
            return Restrictions.sizeGt(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.GREATER_THAN_OR_EQUAL)) {
        if (!isCollection) {
            return Restrictions.ge(exp, firstArgument);
        } else {
            return Restrictions.sizeGe(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.LESS_THAN)) {
        if (!isCollection) {
            return Restrictions.lt(exp, firstArgument);
        } else {
            return Restrictions.sizeLt(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.LESS_THAN_OR_EQUAL)) {
        if (!isCollection) {
            return Restrictions.le(exp, firstArgument);
        } else {
            return Restrictions.sizeLe(exp, (Integer) firstArgument);
        }
    } else if (operator.equals(RSQLOperators.IN)) {
        if (!isCollection) {
            return Restrictions.in(exp, arguments);
        }
    } else if (operator.equals(RSQLOperators.NOT_IN)) {
        if (!isCollection) {
            return Restrictions.not(Restrictions.in(exp, arguments));
        }
    }
    throw new IllegalArgumentException("Unknown operation " + operator.toString() + " for property" + name);
}

---

From source file:dao.ShopDao.java

public boolean checkShopEmail(Integer id, String email) {
    try {// www. ja va2  s  .c om
        session.getCurrentSession().beginTransaction();

        Criteria cr = session.getCurrentSession().createCriteria(Shop.class);
        cr.add(Restrictions.eq("email", email));
        cr.add(Restrictions.ne("id", id));
        List results = cr.list();

        if (results.size() != 0) {
            session.getCurrentSession().getTransaction().commit();
            return true;
        } else {
            session.getCurrentSession().getTransaction().rollback();
            return false;
        }
    } catch (Exception e) {
        session.getCurrentSession().getTransaction().rollback();
        return false;
    }
}

---

From source file:de.arago.rike.zombie.ZombieHelper.java

License:Open Source License

public static List<Task> getOverdueTasks() {
    DataHelperRike<Task> helper = new DataHelperRike<Task>(Task.class);
    Criteria crit = helper.filter().add(Restrictions.isNotNull("dueDate"))
            .add(Restrictions.lt("dueDate", new Date()))
            .add(Restrictions.ne("status", Task.Status.DONE.toString().toLowerCase()))
            .addOrder(Order.asc("dueDate"));

    return helper.list(crit);
}

---

From source file:de.codesourcery.eve.skills.db.dao.RegionDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Region> fetchAll() {

    return (List<Region>) execute(new HibernateCallback<List<Region>>() {

        @Override// www . j  a  v a2s  .  c  o  m
        public List<Region> doInSession(Session session) {
            final Criteria c = session.createCriteria(Region.class).add(Restrictions.ne("name", "Unknown"));
            return c.list();
        }
    });

}

---

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