How to use

org.hibernate.criterion.SQLCriterion

constructor

/**
 * Apply a constraint expressed in SQL with no JDBC parameters.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The SQL restriction
 *
 * @return The Criterion
 *
 * @see SQLCriterion
 */
public static Criterion sqlRestriction(String sql) {
  return new SQLCriterion( sql );
}

/**
 * Create a restriction expressed in SQL with one JDBC parameter.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The SQL restriction
 * @param value The parameter value
 * @param type The parameter type
 *
 * @return The Criterion
 *
 * @see SQLCriterion
 */
public static Criterion sqlRestriction(String sql, Object value, Type type) {
  return new SQLCriterion( sql, value, type );
}

/**
 * Create a restriction expressed in SQL with JDBC parameters.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The SQL restriction
 * @param values The parameter values
 * @param types The parameter types
 *
 * @return The Criterion
 *
 * @see SQLCriterion
 */
public static Criterion sqlRestriction(String sql, Object[] values, Type[] types) {
  return new SQLCriterion( sql, values, types );
}

/**
 * Apply a constraint expressed in SQL with no parameters.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The sql
 *
 * @return Criterion
 *
 * @deprecated use {@link org.hibernate.criterion.Restrictions#sqlRestriction(String)}
 */
@Deprecated
public static Criterion sql(String sql) {
  return new SQLCriterion( sql );
}

/**
 * Apply a constraint expressed in SQL, with a JDBC parameter.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The sql
 * @param value The parameter value
 * @param type The parameter type
 *
 * @return Criterion
 *
 * @deprecated use {@link org.hibernate.criterion.Restrictions#sqlRestriction(String, Object, Type)}
 */
@Deprecated
public static Criterion sql(String sql, Object value, Type type) {
  return new SQLCriterion( sql, value, type );
}

/**
 * Apply a constraint expressed in SQL, with JDBC parameters.  Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql The sql
 * @param values The parameter values
 * @param types The parameter types
 *
 * @return Criterion
 *
 * @deprecated use {@link org.hibernate.criterion.Restrictions#sqlRestriction(String, Object[], Type[])}
 */
@Deprecated
public static Criterion sql(String sql, Object[] values, Type[] types) {
  return new SQLCriterion( sql, values, types );
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sql(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sql(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @param sql
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameter. Any occurrences of <tt>{alias}</tt> will be replaced
 * by the table alias.
 *
 * @param sql
 * @param value
 * @param type
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql, Object value, Type type) {
  return new SQLCriterion(sql, new Object[] { value }, new Type[] { type } );
}
/**

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameters. Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql
 * @param values
 * @param types
 * @return Criterion
 */
public static Criterion sql(String sql, Object[] values, Type[] types) {
  return new SQLCriterion(sql, values, types);
}
/**

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameter. Any occurrences of <tt>{alias}</tt> will be replaced
 * by the table alias.
 *
 * @param sql
 * @param value
 * @param type
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql, Object value, Type type) {
  return new SQLCriterion(sql, new Object[] { value }, new Type[] { type } );
}
/**

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameters. Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql
 * @param values
 * @param types
 * @return Criterion
 */
public static Criterion sql(String sql, Object[] values, Type[] types) {
  return new SQLCriterion(sql, values, types);
}
/**

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameters. Any occurrences of <tt>{alias}</tt> will be
 * replaced by the table alias.
 *
 * @param sql
 * @param values
 * @param types
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql, Object[] values, Type[] types) {
  return new SQLCriterion(sql, values, types);
}
/**

/**
 * Apply a constraint expressed in SQL, with the given JDBC
 * parameter. Any occurrences of <tt>{alias}</tt> will be replaced
 * by the table alias.
 *
 * @param sql
 * @param value
 * @param type
 * @return Criterion
 */
public static Criterion sqlRestriction(String sql, Object value, Type type) {
  return new SQLCriterion(sql, new Object[] { value }, new Type[] { type } );
}
/**

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @deprecated use {@link org.hibernate.criterion.Restrictions#sqlRestriction(String)}
 * @param sql
 * @return Criterion
 */
@Deprecated
public static Criterion sql(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}

/**
 * Apply a constraint expressed in SQL. Any occurrences of <tt>{alias}</tt>
 * will be replaced by the table alias.
 *
 * @deprecated use {@link org.hibernate.criterion.Restrictions#sqlRestriction(String)}
 * @param sql
 * @return Criterion
 */
@Deprecated
public static Criterion sql(String sql) {
  return new SQLCriterion(sql, ArrayHelper.EMPTY_OBJECT_ARRAY, ArrayHelper.EMPTY_TYPE_ARRAY);
}