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 Summary

      Constructors 
      Constructor Description
      AbstractSQL()  

    • Method Summary

      Modifier and Type Method Description
      T ADD_ROW()  
      T AND()  
      T DELETE_FROM​(java.lang.String table)  
      T FETCH_FIRST_ROWS_ONLY​(int value)
      Set the fetch first rows value.
      T FETCH_FIRST_ROWS_ONLY​(java.lang.String variable)
      Set the fetch first rows variable string(e.g.
      T FROM​(java.lang.String table)  
      T FROM​(java.lang.String... tables)  
      abstract T getSelf()  
      T GROUP_BY​(java.lang.String columns)  
      T GROUP_BY​(java.lang.String... columns)  
      T HAVING​(java.lang.String conditions)  
      T HAVING​(java.lang.String... conditions)  
      T INNER_JOIN​(java.lang.String join)  
      T INNER_JOIN​(java.lang.String... joins)  
      T INSERT_INTO​(java.lang.String tableName)  
      T INTO_COLUMNS​(java.lang.String... columns)  
      T INTO_VALUES​(java.lang.String... values)  
      T JOIN​(java.lang.String join)  
      T JOIN​(java.lang.String... joins)  
      T LEFT_OUTER_JOIN​(java.lang.String join)  
      T LEFT_OUTER_JOIN​(java.lang.String... joins)  
      T LIMIT​(int value)
      Set the limit value.
      T LIMIT​(java.lang.String variable)
      Set the limit variable string(e.g.
      T OFFSET​(long value)
      Set the offset value.
      T OFFSET​(java.lang.String variable)
      Set the offset variable string(e.g.
      T OFFSET_ROWS​(long value)
      Set the offset rows value.
      T OFFSET_ROWS​(java.lang.String variable)
      Set the offset rows variable string(e.g.
      T OR()  
      T ORDER_BY​(java.lang.String columns)  
      T ORDER_BY​(java.lang.String... columns)  
      T OUTER_JOIN​(java.lang.String join)  
      T OUTER_JOIN​(java.lang.String... joins)  
      T RIGHT_OUTER_JOIN​(java.lang.String join)  
      T RIGHT_OUTER_JOIN​(java.lang.String... joins)  
      T SELECT​(java.lang.String columns)  
      T SELECT​(java.lang.String... columns)  
      T SELECT_DISTINCT​(java.lang.String columns)  
      T SELECT_DISTINCT​(java.lang.String... columns)  
      T SET​(java.lang.String sets)  
      T SET​(java.lang.String... sets)  
      java.lang.String toString()  
      T UPDATE​(java.lang.String table)  
      <A extends java.lang.Appendable>
      A      		 usingAppender​(A a)  
      T VALUES​(java.lang.String columns, java.lang.String values)  
      T WHERE​(java.lang.String conditions)  
      T WHERE​(java.lang.String... conditions)  

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

    • 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