Package org.httprpc.sql

Class QueryBuilder

  • public class QueryBuilder
extends java.lang.Object
    Class for programmatically constructing a SQL query.

    • Method Detail

      • select

        public static QueryBuilder select​(java.lang.String... columns)
        Creates a "select" query.
        Parameters:
        columns - The column names.
        Returns:
        The new QueryBuilder instance.

      • from

        public QueryBuilder from​(java.lang.String... tables)
        Appends a "from" clause to a query.
        Parameters:
        tables - The table names.
        Returns:
        The QueryBuilder instance.

      • join

        public QueryBuilder join​(java.lang.String table)
        Appends a "join" clause to a query.
        Parameters:
        table - The table name.
        Returns:
        The QueryBuilder instance.

      • leftJoin

        public QueryBuilder leftJoin​(java.lang.String table)
        Appends a "left join" clause to a query.
        Parameters:
        table - The table name.
        Returns:
        The QueryBuilder instance.

      • rightJoin

        public QueryBuilder rightJoin​(java.lang.String table)
        Appends a "right join" clause to a query.
        Parameters:
        table - The table name.
        Returns:
        The QueryBuilder instance.

      • on

        public QueryBuilder on​(java.lang.String predicate)
        Appends an "on" clause to a query.
        Parameters:
        predicate - The predicate.
        Returns:
        The QueryBuilder instance.

      • where

        public QueryBuilder where​(java.lang.String predicate)
        Appends a "where" clause to a query.
        Parameters:
        predicate - The predicate.
        Returns:
        The QueryBuilder instance.

      • orderBy

        public QueryBuilder orderBy​(java.lang.String... columns)
        Appends an "order by" clause to a query.
        Parameters:
        columns - The column names.
        Returns:
        The QueryBuilder instance.

      • limit

        public QueryBuilder limit​(int count)
        Appends a "limit" clause to a query.
        Parameters:
        count - The limit count.
        Returns:
        The QueryBuilder instance.

      • forUpdate

        public QueryBuilder forUpdate()
        Appends a "for update" clause to a query.
        Returns:
        The QueryBuilder instance.

      • insertInto

        public static QueryBuilder insertInto​(java.lang.String table,
                                      java.util.Map<java.lang.String,​?> values)
        Creates an "insert into" query.
        Parameters:
        table - The table name.
        values - The values to insert.
        Returns:
        The new QueryBuilder instance.

      • update

        public static QueryBuilder update​(java.lang.String table)
        Creates an "update" query.
        Parameters:
        table - The table name.
        Returns:
        The new QueryBuilder instance.

      • set

        public QueryBuilder set​(java.util.Map<java.lang.String,​?> values)
        Appends a "set" command to a query.
        Parameters:
        values - The values to update.
        Returns:
        The QueryBuilder instance.

      • deleteFrom

        public static QueryBuilder deleteFrom​(java.lang.String table)
        Creates a "delete from" query.
        Parameters:
        table - The table name.
        Returns:
        The new QueryBuilder instance.

      • toString

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