Package org.apache.ibatis.jdbc

Class AbstractSQL<T>

  • Direct Known Subclasses:
    SQL
    public abstract class AbstractSQL<T>
extends java.lang.Object
    Author:
    Clinton Begin, Jeff Butler, Adam Gent, Kazuki Shimizu

    • Constructor Detail

      • AbstractSQL

        public AbstractSQL()

    • Method Detail

      • getSelf

        public abstract T getSelf()

      • UPDATE

        public T UPDATE​(java.lang.String table)

      • SET

        public T SET​(java.lang.String sets)

      • SET

        public T SET​(java.lang.String... sets)
        Since:
        3.4.2

      • INSERT_INTO

        public T INSERT_INTO​(java.lang.String tableName)

      • VALUES

        public T VALUES​(java.lang.String columns,
                java.lang.String values)

      • INTO_COLUMNS

        public T INTO_COLUMNS​(java.lang.String... columns)
        Since:
        3.4.2

      • INTO_VALUES

        public T INTO_VALUES​(java.lang.String... values)
        Since:
        3.4.2

      • SELECT

        public T SELECT​(java.lang.String columns)

      • SELECT

        public T SELECT​(java.lang.String... columns)
        Since:
        3.4.2

      • SELECT_DISTINCT

        public T SELECT_DISTINCT​(java.lang.String columns)

      • SELECT_DISTINCT

        public T SELECT_DISTINCT​(java.lang.String... columns)
        Since:
        3.4.2

      • DELETE_FROM

        public T DELETE_FROM​(java.lang.String table)

      • FROM

        public T FROM​(java.lang.String table)

      • FROM

        public T FROM​(java.lang.String... tables)
        Since:
        3.4.2

      • JOIN

        public T JOIN​(java.lang.String join)

      • JOIN

        public T JOIN​(java.lang.String... joins)
        Since:
        3.4.2

      • INNER_JOIN

        public T INNER_JOIN​(java.lang.String join)

      • INNER_JOIN

        public T INNER_JOIN​(java.lang.String... joins)
        Since:
        3.4.2

      • LEFT_OUTER_JOIN

        public T LEFT_OUTER_JOIN​(java.lang.String join)

      • LEFT_OUTER_JOIN

        public T LEFT_OUTER_JOIN​(java.lang.String... joins)
        Since:
        3.4.2

      • RIGHT_OUTER_JOIN

        public T RIGHT_OUTER_JOIN​(java.lang.String join)

      • RIGHT_OUTER_JOIN

        public T RIGHT_OUTER_JOIN​(java.lang.String... joins)
        Since:
        3.4.2

      • OUTER_JOIN

        public T OUTER_JOIN​(java.lang.String join)

      • OUTER_JOIN

        public T OUTER_JOIN​(java.lang.String... joins)
        Since:
        3.4.2

      • WHERE

        public T WHERE​(java.lang.String conditions)

      • WHERE

        public T WHERE​(java.lang.String... conditions)
        Since:
        3.4.2

      • OR

        public T OR()

      • AND

        public T AND()

      • GROUP_BY

        public T GROUP_BY​(java.lang.String columns)

      • GROUP_BY

        public T GROUP_BY​(java.lang.String... columns)
        Since:
        3.4.2

      • HAVING

        public T HAVING​(java.lang.String conditions)

      • HAVING

        public T HAVING​(java.lang.String... conditions)
        Since:
        3.4.2

      • ORDER_BY

        public T ORDER_BY​(java.lang.String columns)

      • ORDER_BY

        public T ORDER_BY​(java.lang.String... columns)
        Since:
        3.4.2

      • LIMIT

        public T LIMIT​(java.lang.String variable)
        Set the limit variable string(e.g. "#{limit}").
        Parameters:
        variable - a limit variable string
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        OFFSET(String)

      • LIMIT

        public T LIMIT​(int value)
        Set the limit value.
        Parameters:
        value - an offset value
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        OFFSET(long)

      • OFFSET

        public T OFFSET​(java.lang.String variable)
        Set the offset variable string(e.g. "#{offset}").
        Parameters:
        variable - a offset variable string
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        LIMIT(String)

      • OFFSET

        public T OFFSET​(long value)
        Set the offset value.
        Parameters:
        value - an offset value
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        LIMIT(int)

      • FETCH_FIRST_ROWS_ONLY

        public T FETCH_FIRST_ROWS_ONLY​(java.lang.String variable)
        Set the fetch first rows variable string(e.g. "#{fetchFirstRows}").
        Parameters:
        variable - a fetch first rows variable string
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        OFFSET_ROWS(String)

      • FETCH_FIRST_ROWS_ONLY

        public T FETCH_FIRST_ROWS_ONLY​(int value)
        Set the fetch first rows value.
        Parameters:
        value - a fetch first rows value
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        OFFSET_ROWS(long)

      • OFFSET_ROWS

        public T OFFSET_ROWS​(java.lang.String variable)
        Set the offset rows variable string(e.g. "#{offset}").
        Parameters:
        variable - a offset rows variable string
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        FETCH_FIRST_ROWS_ONLY(String)

      • OFFSET_ROWS

        public T OFFSET_ROWS​(long value)
        Set the offset rows value.
        Parameters:
        value - an offset rows value
        Returns:
        a self instance
        Since:
        3.5.2
        See Also:
        FETCH_FIRST_ROWS_ONLY(int)

      • ADD_ROW

        public T ADD_ROW()

      • usingAppender

        public <A extends java.lang.Appendable> A usingAppender​(A a)

      • toString

        public java.lang.String toString()
        Overrides:
        toString in class java.lang.Object