SqlBuilder (Ujorm 2.05-SNAPSHOT

java.lang.Object
- org.ujorm.tools.jdbc.JdbcBuilder
- - org.ujorm.tools.sql.SqlBuilder

All Implemented Interfaces:: Serializable

public class SqlBuilder
extends JdbcBuilder

PrepareStatement builder support

How to use a SELECT

 SqlBuilder sql = new SqlBuilder()
     .select("t.id", "t.name")
     .from("testTable t")
     .where()
     .andCondition("t.name", "=", "Test")
     .andCondition("t.created", ">=", someDate);
 for (ResultSet rs : sql.executeSelect(dbConnection)) {
      int id = rs.getInt(1);
      String name = rs.getString(2);
 }

How to use a INSERT

 SqlBuilder sql = new SqlBuilder()
     .insert("testTable")
     .write("(")
     .columnInsert("id", 10)
     .columnInsert("name", "Test")
     .columnInsert("date", someDate)
     .super.write(")");
 sql.executeUpdate(dbConnection);

How to use a UPDATE

 SqlBuilder sql = new SqlBuilder()
     .update("testTable")
     .columnUpdate("name", "Test")
     .columnUpdate("date", SOME_DATE)
     .where()
     .andCondition("id", "IN", 10, 20, 30)
     .andCondition("created BETWEEN ? AND ?", null, someDate, someDate.plusMonths(1))
     .andCondition("name", "IS NOT NULL")
 sql.executeUpdate(dbConnection);

For more information see a jUnit test.

See Also:: Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from class org.ujorm.tools.jdbc.JdbcBuilder
  JdbcBuilder.MarkerEnvelope, JdbcBuilder.SqlEnvelope

Field Summary
- Fields inherited from class org.ujorm.tools.jdbc.JdbcBuilder
  arguments, columnCounter, conditionCounter, insertMode, ITEM_SEPARATOR, SPACE, sql, VALUE_MARKER

Constructor Summary

Constructors
Constructor and Description

SqlBuilder()

SqlBuilder(List<CharSequence> sql, List<Object> arguments)

Constructors
Constructor and Description
`SqlBuilder()`
`SqlBuilder(List<CharSequence> sql, List<Object> arguments)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlBuilder`	`addArguments(Object... values)` Add argument values with no SAPARATOR and no MARKER (for a common use)
`protected SqlBuilder`	`addValue(Object value)` Add a value to SQL (inlucing MARKER)
`SqlBuilder`	`andCondition(CharSequence sqlCondition, String operator, Object... values)` Add a condition for a multivalue argument joined by AND operator
`SqlBuilder`	`andCondition(CharSequence sqlCondition, String operator, Object value)` Add a condition for a valid argument joined by AND operator
`SqlBuilder`	`column(CharSequence column)` Add new column
`SqlBuilder`	`columnInsert(CharSequence column, Object value)` Set new value to column by template {@code name = ?
`SqlBuilder`	`columnUpdate(CharSequence column, Object value)` Set new value to column by template {@code name = ?
`SqlBuilder`	`condition(CharSequence sqlCondition, String operator, Object value)` Add a condition for an argument with length
`SqlBuilder`	`delete(CharSequence table)` Write WHERE
`SqlBuilder`	`from(CharSequence... tables)` Write FORM tables
`SqlBuilder`	`insert(CharSequence table)` Write WHERE
`SqlBuilder`	`orCondition(CharSequence sqlCondition, String operator, Object... values)` Add a condition for a multivalue argument joined by OR operator
`SqlBuilder`	`orCondition(CharSequence sqlCondition, String operator, Object value)` Add a condition for a valid argument joined by OR operator
`SqlBuilder`	`select(CharSequence... columns)` Write SELECT columns
`SqlBuilder`	`update(CharSequence table)` Write WHERE
`SqlBuilder`	`value(Object value)` Add an argument value (including a SEPARATOR and a MARKER) for buidling a SQL INSERT statement
`SqlBuilder`	`where()` Write WHERE
`SqlBuilder`	`write(CharSequence sqlFragment)` Write a sql fragment including a space before
`SqlBuilder`	`write(SqlBuilder builder)`
`SqlBuilder`	`writeMany(CharSequence... sqlFragments)` Write many sql fragments including a space before
`SqlBuilder`	`writeManyNoSpace(CharSequence... sqlFragments)` Write many sql fragments with no space before
`SqlBuilder`	`writeNoSpace(CharSequence sqlFragment)` Write a sql fragment with no space before

Methods inherited from class org.ujorm.tools.jdbc.JdbcBuilder
createValuePrinter, executeSelect, executeSelect, executeUpdate, getArguments, getBufferSizeEstimation, getSql, getSql, prepareStatement, toString, uniqueValue, uniqueValueOptional, write, writeOperator

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - SqlBuilder
```
public SqlBuilder()
```
  - SqlBuilder
```
public SqlBuilder(List<CharSequence> sql,
                  List<Object> arguments)
```
- Method Detail
  - select
```
public SqlBuilder select(@Nonnull
                         CharSequence... columns)
```
    Write SELECT columns
  - from
```
public SqlBuilder from(@Nonnull
                       CharSequence... tables)
```
    Write FORM tables
  - where
```
public SqlBuilder where()
```
    Write WHERE
  - insert
```
public SqlBuilder insert(@Nonnull
                         CharSequence table)
```
    Write WHERE
  - update
```
public SqlBuilder update(@Nonnull
                         CharSequence table)
```
    Write WHERE
  - delete
```
public SqlBuilder delete(@Nonnull
                         CharSequence table)
```
    Write WHERE
  - addArguments
```
public SqlBuilder addArguments(Object... values)
```
    Description copied from class: JdbcBuilder
    
    Add argument values with no SAPARATOR and no MARKER (for a common use)
    
    Overrides:
    
    addArguments in class JdbcBuilder
    
    See Also:
    
    JdbcBuilder.value(java.lang.Object), JdbcBuilder.writeNoSpace(java.lang.CharSequence)
  - addValue
```
protected SqlBuilder addValue(Object value)
```
    Description copied from class: JdbcBuilder
    
    Add a value to SQL (inlucing MARKER)
    
    Overrides:
    
    addValue in class JdbcBuilder
    
    Parameters:
    
    value - A null value is ignored
    
    See Also:
    
    JdbcBuilder.addArguments(java.lang.Object...)
  - value
```
public SqlBuilder value(Object value)
```
    Description copied from class: JdbcBuilder
    
    Add an argument value (including a SEPARATOR and a MARKER) for buidling a SQL INSERT statement
    
    Overrides:
    
    value in class JdbcBuilder
    
    See Also:
    
    JdbcBuilder.addArguments(java.lang.Object...)
  - condition
```
public SqlBuilder condition(CharSequence sqlCondition,
                            String operator,
                            Object value)
```
    Description copied from class: JdbcBuilder
    
    Add a condition for an argument with length
    
    Overrides:
    
    condition in class JdbcBuilder
    
    Parameters:
    
    sqlCondition - A condition in the SQL format like the next: "table.id = ?". Send a null value to ignore the method.
    
    operator - An optional operator is followed by the JdbcBuilder.VALUE_MARKER automatically
    
    value - Add a value to arguments including a markup to the SQL statement. To ignore the value, send a null. An array is supported
  - orCondition
```
public SqlBuilder orCondition(CharSequence sqlCondition,
                              String operator,
                              Object... values)
```
    Description copied from class: JdbcBuilder
    
    Add a condition for a multivalue argument joined by OR operator
    
    Overrides:
    
    orCondition in class JdbcBuilder
    
    Parameters:
    
    sqlCondition - A condition in the SQL format like the next: "table.id = ?"
    
    operator - An optional operator is followed by the JdbcBuilder.VALUE_MARKER automatically
    
    values - The value of the condition (a replacement for the question character)
  - orCondition
```
public SqlBuilder orCondition(CharSequence sqlCondition,
                              String operator,
                              Object value)
```
    Description copied from class: JdbcBuilder
    
    Add a condition for a valid argument joined by OR operator
    
    Overrides:
    
    orCondition in class JdbcBuilder
    
    Parameters:
    
    sqlCondition - A condition in the SQL format like the next: "table.id = ?"
    
    operator - An optional operator is followed by the JdbcBuilder.VALUE_MARKER automatically
    
    value - Add the value to arguments including a markup to the SQL statement. To ignore the value, send a null.
  - andCondition
```
public SqlBuilder andCondition(CharSequence sqlCondition,
                               String operator,
                               Object... values)
```
    Description copied from class: JdbcBuilder
    
    Add a condition for a multivalue argument joined by AND operator
    
    Overrides:
    
    andCondition in class JdbcBuilder
    
    Parameters:
    
    sqlCondition - A condition in the SQL format like the next: "table.id = ?"
    
    operator - An optional operator is followed by the JdbcBuilder.VALUE_MARKER automatically
    
    values - The value of the condition (a replacement for the question character)
  - andCondition
```
public SqlBuilder andCondition(CharSequence sqlCondition,
                               String operator,
                               Object value)
```
    Description copied from class: JdbcBuilder
    
    Add a condition for a valid argument joined by AND operator
    
    Overrides:
    
    andCondition in class JdbcBuilder
    
    Parameters:
    
    sqlCondition - A condition in the SQL format like the next: "table.id = ?"
    
    operator - An optional operator is followed by the JdbcBuilder.VALUE_MARKER automatically
    
    value - Add the value to arguments including a markup to the SQL statement. To ignore the value, send a null.
  - columnInsert
```
public SqlBuilder columnInsert(CharSequence column,
                               Object value)
```
    Description copied from class: JdbcBuilder
    
    Set new value to column by template {@code name = ?
    
    Overrides:
    
    columnInsert in class JdbcBuilder
  - columnUpdate
```
public SqlBuilder columnUpdate(CharSequence column,
                               Object value)
```
    Description copied from class: JdbcBuilder
    
    Set new value to column by template {@code name = ?
    
    Overrides:
    
    columnUpdate in class JdbcBuilder
  - column
```
public final SqlBuilder column(CharSequence column)
```
    Description copied from class: JdbcBuilder
    
    Add new column
    
    Overrides:
    
    column in class JdbcBuilder
  - writeManyNoSpace
```
public final SqlBuilder writeManyNoSpace(CharSequence... sqlFragments)
```
    Description copied from class: JdbcBuilder
    
    Write many sql fragments with no space before
    
    Overrides:
    
    writeManyNoSpace in class JdbcBuilder
  - writeMany
```
public final SqlBuilder writeMany(CharSequence... sqlFragments)
```
    Description copied from class: JdbcBuilder
    
    Write many sql fragments including a space before
    
    Overrides:
    
    writeMany in class JdbcBuilder
  - writeNoSpace
```
public final SqlBuilder writeNoSpace(CharSequence sqlFragment)
```
    Description copied from class: JdbcBuilder
    
    Write a sql fragment with no space before
    
    Overrides:
    
    writeNoSpace in class JdbcBuilder
    
    Parameters:
    
    sqlFragment - An empty or null fragment is ignored.
  - write
```
public final SqlBuilder write(CharSequence sqlFragment)
```
    Description copied from class: JdbcBuilder
    
    Write a sql fragment including a space before
    
    Overrides:
    
    write in class JdbcBuilder
    
    Parameters:
    
    sqlFragment - An empty or null value is ignored.
  - write
```
public final SqlBuilder write(SqlBuilder builder)
```

Class SqlBuilder

How to use a SELECT

How to use a INSERT

How to use a UPDATE

Nested Class Summary

Nested classes/interfaces inherited from class org.ujorm.tools.jdbc.JdbcBuilder

Field Summary

Fields inherited from class org.ujorm.tools.jdbc.JdbcBuilder

Constructor Summary

Method Summary

Methods inherited from class org.ujorm.tools.jdbc.JdbcBuilder

Methods inherited from class java.lang.Object

Constructor Detail

SqlBuilder

SqlBuilder

Method Detail

select

from

where

insert

update

delete

addArguments

addValue

value

condition

orCondition

orCondition

andCondition

andCondition

columnInsert

columnUpdate

column

writeManyNoSpace

writeMany

writeNoSpace

write

write