Example usage for org.hibernate.criterion Restrictions sqlRestriction

Introduction

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

Prototype

public static Criterion sqlRestriction(String sql)

Source Link

Document

Apply a constraint expressed in SQL with no JDBC parameters.

Usage

From source file:cruds.UsersCrudImplementation.java

@Override
public ArrayList<Users> selectMaxRateUsers() {
    ArrayList<Integer> maxRate = maxValue();
    List<Users> maxRateOfUsers = new ArrayList<>();
    Criteria criteria = sc.createCriteria(Users.class);
    System.out.println(maxRate.get(0));
    criteria.add(Restrictions.in("rate", maxRate));
    criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
    criteria.setMaxResults(3);//  ww  w.  j  a v a  2  s  . c o m
    System.out.println(maxRate.get(1));
    maxRateOfUsers = criteria.list();
    return (ArrayList<Users>) maxRateOfUsers;
}

From source file:cz.uhk.fim.kulhama1.skolniprojectchaty.dao.CottageDAO.java

public List<Cottage> getCottagesByRow(String row, String operand, String stringArray) {
    return this.sessionFactory.getCurrentSession().createCriteria(Cottage.class)
            .add(Restrictions.sqlRestriction(row + " " + operand + " (" + stringArray + ")")).list();
}

From source file:dao.AutorDAO.java

public List<Autor> listaAutorsPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("nome like '" + nome + "%'")).list();

}

From source file:dao.EditoraDAO.java

public List<Editora> listaEditorasPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("nome like '" + nome + "%'")).list();

}

From source file:dao.GeneroDAO.java

public List<Genero> listaGenerosPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("nome like '" + nome + "%'")).list();

}

From source file:dao.LivroDAO.java

public List<Livro> listaLivrosPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("titulo like '" + nome + "%'")).list();

}

From source file:dao.StatusDAO.java

public List<Status> listaStatussPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("nome like '" + nome + "%'")).list();

}

From source file:dao.StatusLeituraDAO.java

public List<StatusLeitura> listaStatusLeiturasPorNome(String nome) {
    Session session = (Session) getEntityManager().getDelegate();
    return session.createCriteria(this.getPersistentClass())
            .add(Restrictions.sqlRestriction("nome like '" + nome + "%'")).list();

}

From source file:de.cosmocode.hibernate.MySQLRestrictions.java

License:Apache License

private static Criterion bit(String columnName, String binaryOperator, long flag, String operator, long value) {
    return Restrictions.sqlRestriction(
            "({alias}." + columnName + " " + binaryOperator + " " + flag + ") " + operator + " " + value);
}

From source file:de.escidoc.core.common.business.filter.CqlFilter.java

License:Open Source License

/**
 * Return the given criterion if it is not NULL. Otherwise return "TRUE".
 * /*from w  w w .j a va  2 s .c om*/
 * @param criterion
 *            Hibernate query or NULL
 * @return the given Hibernate query or "TRUE"
 */
private static Criterion getAndRestriction(final Criterion criterion) {
    return criterion != null ? criterion : Restrictions.sqlRestriction("1 = 1");
}