java.lang.Object
org.springframework.data.relational.core.sql.Between
All Implemented Interfaces:
Condition, Expression, Segment, Visitable

public class Between extends Object implements Condition
BETWEEN Condition comparing between Expressions.

Results in a rendered condition: <left> BETWEEN <begin> AND <end>.

Since:
2.2
Author:
Mark Paluch, Meng Zuozhu
  • Method Details

    • create

      public static Between create(Expression columnOrExpression, Expression begin, Expression end)
      Creates a new Between Condition given two Expressions.
      Parameters:
      columnOrExpression - left side of the comparison.
      begin - begin value of the comparison.
      end - end value of the comparison.
      Returns:
      the Between condition.
    • getColumn

      public Expression getColumn()
      Returns:
      the column Expression.
    • getBegin

      public Expression getBegin()
      Returns:
      the begin Expression.
    • getEnd

      public Expression getEnd()
      Returns:
      the end Expression.
    • isNegated

      public boolean isNegated()
    • not

      public Between not()
      Description copied from interface: Condition
      Creates a Condition that negates this Condition.
      Specified by:
      not in interface Condition
      Returns:
      the negated Condition.
    • toString

      public String toString()
      Description copied from interface: Segment
      Return a SQL string representation of this Segment.

      The representation is intended for debugging purposes and an approximation to the generated SQL. While it might work in the context of a specific dialect, you should not assume that the Segment.toString() representation works across multiple databases.

      Specified by:
      toString in interface Segment
      Returns:
      a SQL string representation of this Segment.
    • visit

      public void visit(Visitor visitor)
      Description copied from interface: Visitable
      Accept a Visitor visiting this Visitable and its nested Visitables if applicable.
      Specified by:
      visit in interface Visitable
      Parameters:
      visitor - the visitor to notify, must not be null.
    • hashCode

      public int hashCode()
      Description copied from interface: Segment
      Generate a hash code from thisSegment.

      Hashcode typically derives from the Segment.toString() representation so two Segments yield the same Segment.hashCode() if their Segment.toString() representation matches.

      Specified by:
      hashCode in interface Segment
      Overrides:
      hashCode in class Object
      Returns:
      a hash code value for this object.
    • equals

      public boolean equals(Object obj)
      Description copied from interface: Segment
      Check whether this Segment is equal to another Segment.

      Equality is typically given if the Segment.toString() representation matches.

      Specified by:
      equals in interface Segment
      Overrides:
      equals in class Object
      Parameters:
      obj - the reference object with which to compare.
      Returns:
      true if this object is the same as the other argument; false otherwise.