Module org.itsallcode.jdbc

Package org.itsallcode.jdbc.batch

Class PreparedStatementBatch

java.lang.Object

org.itsallcode.jdbc.batch.PreparedStatementBatch

All Implemented Interfaces:

AutoCloseable

public class PreparedStatementBatch
extends Object
implements AutoCloseable

Direct batch insert using PreparedStatement. Create a new instance using SimpleConnection.preparedStatementBatch().

Method Summary

Modifier and Type	Method	Description
void	add(PreparedStatementSetter preparedStatementSetter)	Add a new row to the batch.
void	addBatch()	Add a new row to the batch.
void	close()
PreparedStatement	getStatement()	Get the PreparedStatement that is used for the batch insert.

Methods inherited from class java.lang.Object

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

Method Details

add

public void add(PreparedStatementSetter preparedStatementSetter)

Add a new row to the batch.

Important: This method automatically calls PreparedStatement.addBatch(). No need to call it separately.

Parameters:

preparedStatementSetter - prepared statement setter that is used for setting row values of the PreparedStatement.

getStatement

public PreparedStatement getStatement()

Get the PreparedStatement that is used for the batch insert. Use this to set values on the PreparedStatement before calling addBatch().

Use this method if you want to set values on the PreparedStatement directly and you need more control. Prefer using add(PreparedStatementSetter) if possible.

Returns:

the PreparedStatement used for the batch insert

addBatch

public void addBatch()

Add a new row to the batch. Only call this method if you have set all values on the PreparedStatement retrieved from statement.

Don't call this if you use add(PreparedStatementSetter).

close

public void close()

Specified by:

close in interface AutoCloseable