Package com.github.eikecochu.sqlbuilder

Class SQLBuilder

  • public final class SQLBuilder
extends java.lang.Object
    Convenience class for quick starting a new statement. Contains all valid starting points.

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static Delete Delete​(Table table)
      Start with an DELETE statement
      static Delete Delete​(java.lang.String table)
      Start with an DELETE statement
      static Insert Insert​(Table table)
      Start with an INSERT statement
      static Insert Insert​(java.lang.String table)
      Start with an INSERT statement
      static Query Query​(java.lang.String sql)
      Create a final Query
      static Select Select()
      Start with a SELECT statement
      static Select Select​(java.lang.String... columns)
      Start with a SELECT statement
      static Update Update​(Table table)
      Start with an UPDATE statement
      static Update Update​(java.lang.String table)
      Start with an UPDATE statement
      static With With​(java.lang.String name)
      Start with a WITH statement

      • Methods inherited from class java.lang.Object

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

    • Method Detail

      • With

        public static With With​(java.lang.String name)
        Start with a WITH statement
        Parameters:
        name - The name of the WITH block
        Returns:
        The new WITH statement

      • Select

        public static Select Select()
        Start with a SELECT statement
        Returns:
        The new SELECT statement

      • Select

        public static Select Select​(java.lang.String... columns)
        Start with a SELECT statement
        Parameters:
        columns - The columns to be selected
        Returns:
        The new SELECT statement

      • Insert

        public static Insert Insert​(java.lang.String table)
        Start with an INSERT statement
        Parameters:
        table - The table name of the table to insert into
        Returns:
        The new INSERT statement

      • Insert

        public static Insert Insert​(Table table)
        Start with an INSERT statement
        Parameters:
        table - The Table representation of the table to insert into
        Returns:
        The new INSERT statement

      • Update

        public static Update Update​(java.lang.String table)
        Start with an UPDATE statement
        Parameters:
        table - The table name of the table to update
        Returns:
        The new UPDATE statement

      • Update

        public static Update Update​(Table table)
        Start with an UPDATE statement
        Parameters:
        table - The Table representation of the table to update
        Returns:
        The new UPDATE statement

      • Delete

        public static Delete Delete​(java.lang.String table)
        Start with an DELETE statement
        Parameters:
        table - The table name of the table to delete from
        Returns:
        The new DELETE statement

      • Delete

        public static Delete Delete​(Table table)
        Start with an DELETE statement
        Parameters:
        table - The Table representation of the table to delete from
        Returns:
        The new DELETE statement

      • Query

        public static Query Query​(java.lang.String sql)
        Create a final Query
        Parameters:
        sql - The SQL statement to use
        Returns:
        The new Query