Package com.northconcepts.datapipeline.jdbc.sql.select
package com.northconcepts.datapipeline.jdbc.sql.select
SQL generation classes for SELECT.
-
ClassDescriptionA
ConjunctivePartthat joins its parts with AND.A single SQL condition, such as"price > ?", with the values for its?parameters.Base class for parts that join their child parts with an operator such as AND or OR, parenthesizing each child when more than one applies.Generates a full join clause.Generates an INNER JOIN clause.Base class for the JOIN clauses of aSelect, each joining a table on a condition.Generates a LEFT JOIN clause.Negates another criteria part, rendering it asnot (...).AConjunctivePartthat joins its parts with OR.The WHERE or HAVING clause of a query, built from conditions combined with AND and OR; renders nothing when empty.Whether aQueryCriteriarenders as a WHERE or a HAVING clause.Base class for the nodes of aQueryCriteriacondition tree.The GROUP BY clause of aSelect; renders nothing when it has no fields.The ORDER BY clause of aSelect; renders nothing when it has no fields.One ORDER BY entry: a field, its direction and optional null placement.Base class for the clauses and conditions that make up aSelectquery.The SELECT column list of aSelect; selects*when no fields are added.Generates a right join clause.Builds a SELECT statement with its parameter values; as aQuerySourceit can also be nested in another query.Interface for classes that can generate SQL SELECT statements.A single table in the FROM clause of aSelect.Combines severalSelectqueries with UNION or UNION ALL; can be nested in another query as a source.