com.exasol.sql.dml

Class Insert

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.Insert

All Implemented Interfaces:

InsertFragment, Fragment, SqlStatement

public class Insert
extends AbstractFragment
implements SqlStatement, InsertFragment

This class implements an SQL Select statement

Constructor Summary

Constructors

Constructor and Description
Insert(String tableName) Create a new instance of an Insert statement

Method Summary

Modifier and Type	Method and Description
void	accept(InsertVisitor visitor) Accept a visitor (e.g.
Insert	field(String... names) Define fields into which should be inserted
String	getTableName() Get the name of the table into which data should be inserted
Insert	valuePlaceholder() Add an unnamed value placeholder to the value list (this is useful for prepared statements)
Insert	valuePlaceholders(int amount) Add a given number unnamed value placeholder to the value list (this is useful for prepared statements)
Insert	values(Object... values) Insert a list of concrete values

Methods inherited from class com.exasol.sql.AbstractFragment

getRoot

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.sql.Fragment

getRoot

Constructor Detail

Insert

public Insert(String tableName)

Create a new instance of an Insert statement

Parameters:

tableName - name of the table into which the data should be inserted

Method Detail

field

public Insert field(String... names)

Define fields into which should be inserted

Parameters:

names - field names

Returns:

this for fluent programming

getTableName

public String getTableName()

Get the name of the table into which data should be inserted

Returns:

table name

values

public Insert values(Object... values)

Insert a list of concrete values

Parameters:

values - values to be inserted

Returns:

this for fluent programming

valuePlaceholder

public Insert valuePlaceholder()

Add an unnamed value placeholder to the value list (this is useful for prepared statements)

Returns:

this for fluent programming

valuePlaceholders

public Insert valuePlaceholders(int amount)

Add a given number unnamed value placeholder to the value list (this is useful for prepared statements)

Parameters:

amount - number of placeholders to be added

Returns:

this for fluent programming

accept

public void accept(InsertVisitor visitor)

Description copied from interface: InsertFragment

Accept a visitor (e.g. a renderer or validator)

Specified by:

accept in interface InsertFragment

Parameters:

visitor - visitor to accept