Module org.itsallcode.jdbc

Package org.itsallcode.jdbc.batch

Class PreparedStatementBatchBuilder

java.lang.Object

org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder

public class PreparedStatementBatchBuilder
extends Object

Builder for PreparedStatementBatch. Create a new builder instance using SimpleConnection.preparedStatementBatch().

Field Summary

Fields

Modifier and Type	Field	Description
static final int	DEFAULT_MAX_BATCH_SIZE	Default maximum batch size.

Constructor Summary

Constructors

Constructor	Description
PreparedStatementBatchBuilder(Function<String,SimplePreparedStatement> statementFactory)	Create a new instance.

Method Summary

Modifier and Type	Method	Description
PreparedStatementBatch	build()	Build the batch inserter.
PreparedStatementBatchBuilder	into(String tableName, List<String> columnNames)	Define table and column names used for generating the INSERT statement.
PreparedStatementBatchBuilder	into(Identifier tableName, List<Identifier> columnNames)	Define table and column names used for generating the INSERT statement.
PreparedStatementBatchBuilder	maxBatchSize(int maxBatchSize)	Define maximum batch size, using DEFAULT_MAX_BATCH_SIZE as default.
PreparedStatementBatchBuilder	sql(String sql)	Define the SQL statement to be used for the batch job, e.g.

Methods inherited from class java.lang.Object

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

Field Details

DEFAULT_MAX_BATCH_SIZE

public static final int DEFAULT_MAX_BATCH_SIZE

Default maximum batch size.

See Also:

• Constant Field Values

Constructor Details

PreparedStatementBatchBuilder

public PreparedStatementBatchBuilder(Function<String,SimplePreparedStatement> statementFactory)

Create a new instance.

Parameters:

statementFactory - factory for creating SimplePreparedStatement.

Method Details

sql

public PreparedStatementBatchBuilder sql(String sql)

Define the SQL statement to be used for the batch job, e.g. INSERT or UPDATE.

Parameters:

sql - SQL statement

Returns:

this for fluent programming

into

public PreparedStatementBatchBuilder into(Identifier tableName,
 List<Identifier> columnNames)

Define table and column names used for generating the INSERT statement.

Parameters:

tableName - table name

columnNames - column names

Returns:

this for fluent programming

into

public PreparedStatementBatchBuilder into(String tableName,
 List<String> columnNames)

Define table and column names used for generating the INSERT statement.

Parameters:

tableName - table name

columnNames - column names

Returns:

this for fluent programming

maxBatchSize

public PreparedStatementBatchBuilder maxBatchSize(int maxBatchSize)

Define maximum batch size, using DEFAULT_MAX_BATCH_SIZE as default.

Parameters:

maxBatchSize - maximum batch size

Returns:

this for fluent programming

build

public PreparedStatementBatch build()

Build the batch inserter.

Returns:

the batch inserter