How to use

org.hibernate.criterion.SimpleSubqueryExpression

constructor

/**
 * Creates a criterion which checks that the value of a literal is less-than ALL the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion ltAll(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion gtSome(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">", "some", dc );
}

/**
 * Creates a criterion which checks that the value of a given literal as being equal to the value in
 * the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion eq(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "=", null, dc );
}

/**
 * Creates a criterion which checks that the value of a given literal as being less-than the value in
 * the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion lt(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<", null, dc );
}

/**
 * Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the
 * value in the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion ge(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">=", null, dc );
}

/**
 * Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values
 * in the subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion geSome(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">=", "some", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is IN the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion in(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "in", null, dc );
}

/**
 * Creates a criterion which checks that the value of a literal is greater-than ALL the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion gtAll(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion geAll(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">=", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is NOT IN the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion notIn(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "not in", null, dc );
}

/**
 * Creates a criterion which checks that the value of a given literal as being greater-than the value in
 * the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion gt(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, ">", null, dc );
}

/**
 * Creates a criterion which checks that the value of a literal equals ALL the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion eqAll(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "=", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values
 * in the subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion leSome(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<=", "some", dc );
}

/**
 * Creates a criterion which checks that the value of a given literal as being not-equal to the value in
 * the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion ne(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression(value, "<>", null, dc);
}

/**
 * Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the
 * value in the subquery result.  The implication is that the subquery returns a single result..
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion le(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<=", null, dc );
}

/**
 * Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion leAll(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<=", "all", dc );
}

/**
 * Creates a criterion which checks that the value of a literal is less-than SOME of the values in the
 * subquery result.
 *
 * @param value The literal value to use in comparison
 * @param dc The detached criteria representing the subquery
 *
 * @return The Criterion
 *
 * @see SimpleSubqueryExpression
 */
public static Criterion ltSome(Object value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression( value, "<", "some", dc );
}

public static Criterion ne(String value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression(value, "<>", null, dc);
}

public static Criterion ltAll(String value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression(value, "<", "all", dc);
}

public static Criterion geAll(String value, DetachedCriteria dc) {
  return new SimpleSubqueryExpression(value, ">=", "all", dc);
}