Module org.jooq

Package org.jooq.tools.jdbc

Class BatchedPreparedStatement

java.lang.Object

org.jooq.tools.jdbc.JDBC41Statement

org.jooq.tools.jdbc.DefaultStatement

org.jooq.tools.jdbc.DefaultPreparedStatement

org.jooq.tools.jdbc.BatchedPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class BatchedPreparedStatement
extends DefaultPreparedStatement

A batched statement.

This statement doesn't execute immediately, but buffers all bind variables in batch, delaying execution until a new SQL string is encountered. See BatchedConnection for details.

Author:

Lukas Eder

See Also:

• BatchedConnection

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor	Description
BatchedPreparedStatement(String sql, BatchedConnection connection, PreparedStatement delegate)

Method Summary

Modifier and Type	Method	Description
void	addBatch()
void	addBatch(String s)
void	clearBatch()
void	close()
boolean	execute()
boolean	execute(String s)
boolean	execute(String s, int autoGeneratedKeys)
boolean	execute(String s, int[] columnIndexes)
boolean	execute(String sql, String[] columnNames)
int[]	executeBatch()
long[]	executeLargeBatch()
long	executeLargeUpdate()
long	executeLargeUpdate(String s)
long	executeLargeUpdate(String s, int autoGeneratedKeys)
long	executeLargeUpdate(String s, int[] columnIndexes)
long	executeLargeUpdate(String s, String[] columnNames)
ResultSet	executeQuery()
ResultSet	executeQuery(String s)
int	executeUpdate()
int	executeUpdate(String s)
int	executeUpdate(String s, int autoGeneratedKeys)
int	executeUpdate(String s, int[] columnIndexes)
int	executeUpdate(String s, String[] columnNames)
BatchedConnection	getBatchedConnection()
boolean	getExecuteImmediate()
ResultSet	getGeneratedKeys()
long	getLargeUpdateCount()
boolean	getMoreResults()
boolean	getMoreResults(int current)
ResultSet	getResultSet()
int	getUpdateCount()
boolean	isWrapperFor(Class<?> iface)
void	setExecuteImmediate(boolean executeImmediate)
<T> T	unwrap(Class<T> iface)

Methods inherited from class org.jooq.tools.jdbc.DefaultPreparedStatement

clearParameters, getDelegate, getDelegatePreparedStatement, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from class org.jooq.tools.jdbc.DefaultStatement

cancel, clearWarnings, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, getConnection, getDelegateStatement, getFetchDirection, getFetchSize, getLargeMaxRows, getMaxFieldSize, getMaxRows, getQueryTimeout, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, wrap

Methods inherited from class org.jooq.tools.jdbc.JDBC41Statement

getObject, getObject

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

cancel, clearWarnings, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getMaxFieldSize, getMaxRows, getQueryTimeout, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Constructor Details

BatchedPreparedStatement

public BatchedPreparedStatement(String sql,
 BatchedConnection connection,
 PreparedStatement delegate)

Method Details

getBatchedConnection

public BatchedConnection getBatchedConnection()
                                       throws SQLException

Throws:

SQLException

getExecuteImmediate

public boolean getExecuteImmediate()

setExecuteImmediate

public void setExecuteImmediate(boolean executeImmediate)

unwrap

public <T> T unwrap(Class<T> iface)
             throws SQLException

Specified by:

unwrap in interface Wrapper

Overrides:

unwrap in class DefaultStatement

Throws:

SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException

Specified by:

isWrapperFor in interface Wrapper

Overrides:

isWrapperFor in class DefaultStatement

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Specified by:

executeUpdate in interface PreparedStatement

Overrides:

executeUpdate in class DefaultPreparedStatement

Throws:

SQLException

execute

public boolean execute()
                throws SQLException

Specified by:

execute in interface PreparedStatement

Overrides:

execute in class DefaultPreparedStatement

Throws:

SQLException

getUpdateCount

public int getUpdateCount()
                   throws SQLException

Specified by:

getUpdateCount in interface Statement

Overrides:

getUpdateCount in class DefaultStatement

Throws:

SQLException

executeLargeUpdate

public long executeLargeUpdate()
                        throws SQLException

Specified by:

executeLargeUpdate in interface PreparedStatement

Overrides:

executeLargeUpdate in class DefaultPreparedStatement

Throws:

SQLException

getLargeUpdateCount

public long getLargeUpdateCount()
                         throws SQLException

Specified by:

getLargeUpdateCount in interface Statement

Overrides:

getLargeUpdateCount in class DefaultStatement

Throws:

SQLException

close

public void close()
           throws SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Statement

Overrides:

close in class DefaultStatement

Throws:

SQLException

getMoreResults

public boolean getMoreResults()
                       throws SQLException

Specified by:

getMoreResults in interface Statement

Overrides:

getMoreResults in class DefaultStatement

Throws:

SQLException

getMoreResults

public boolean getMoreResults(int current)
                       throws SQLException

Specified by:

getMoreResults in interface Statement

Overrides:

getMoreResults in class DefaultStatement

Throws:

SQLException

addBatch

public void addBatch()
              throws SQLException

Specified by:

addBatch in interface PreparedStatement

Overrides:

addBatch in class DefaultPreparedStatement

Throws:

SQLException

clearBatch

public void clearBatch()
                throws SQLException

Specified by:

clearBatch in interface Statement

Overrides:

clearBatch in class DefaultStatement

Throws:

SQLException

executeBatch

public int[] executeBatch()
                   throws SQLException

Specified by:

executeBatch in interface Statement

Overrides:

executeBatch in class DefaultStatement

Throws:

SQLException

executeLargeBatch

public long[] executeLargeBatch()
                         throws SQLException

Specified by:

executeLargeBatch in interface Statement

Overrides:

executeLargeBatch in class DefaultStatement

Throws:

SQLException

addBatch

public void addBatch(String s)
              throws SQLException

Specified by:

addBatch in interface Statement

Overrides:

addBatch in class DefaultStatement

Throws:

SQLException

execute

public boolean execute(String s)
                throws SQLException

Specified by:

execute in interface Statement

Overrides:

execute in class DefaultStatement

Throws:

SQLException

execute

public boolean execute(String s,
 int autoGeneratedKeys)
                throws SQLException

Specified by:

execute in interface Statement

Overrides:

execute in class DefaultStatement

Throws:

SQLException

execute

public boolean execute(String s,
 int[] columnIndexes)
                throws SQLException

Specified by:

execute in interface Statement

Overrides:

execute in class DefaultStatement

Throws:

SQLException

execute

public boolean execute(String sql,
 String[] columnNames)
                throws SQLException

Specified by:

execute in interface Statement

Overrides:

execute in class DefaultStatement

Throws:

SQLException

executeUpdate

public int executeUpdate(String s)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Overrides:

executeUpdate in class DefaultStatement

Throws:

SQLException

executeUpdate

public int executeUpdate(String s,
 int autoGeneratedKeys)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Overrides:

executeUpdate in class DefaultStatement

Throws:

SQLException

executeUpdate

public int executeUpdate(String s,
 int[] columnIndexes)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Overrides:

executeUpdate in class DefaultStatement

Throws:

SQLException

executeUpdate

public int executeUpdate(String s,
 String[] columnNames)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Overrides:

executeUpdate in class DefaultStatement

Throws:

SQLException

executeLargeUpdate

public long executeLargeUpdate(String s)
                        throws SQLException

Specified by:

executeLargeUpdate in interface Statement

Overrides:

executeLargeUpdate in class DefaultStatement

Throws:

SQLException

executeLargeUpdate

public long executeLargeUpdate(String s,
 int autoGeneratedKeys)
                        throws SQLException

Specified by:

executeLargeUpdate in interface Statement

Overrides:

executeLargeUpdate in class DefaultStatement

Throws:

SQLException

executeLargeUpdate

public long executeLargeUpdate(String s,
 int[] columnIndexes)
                        throws SQLException

Specified by:

executeLargeUpdate in interface Statement

Overrides:

executeLargeUpdate in class DefaultStatement

Throws:

SQLException

executeLargeUpdate

public long executeLargeUpdate(String s,
 String[] columnNames)
                        throws SQLException

Specified by:

executeLargeUpdate in interface Statement

Overrides:

executeLargeUpdate in class DefaultStatement

Throws:

SQLException

executeQuery

public ResultSet executeQuery(String s)
                       throws SQLException

Specified by:

executeQuery in interface Statement

Overrides:

executeQuery in class DefaultStatement

Throws:

SQLException

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Specified by:

executeQuery in interface PreparedStatement

Overrides:

executeQuery in class DefaultPreparedStatement

Throws:

SQLException

getResultSet

public ResultSet getResultSet()
                       throws SQLException

Specified by:

getResultSet in interface Statement

Overrides:

getResultSet in class DefaultStatement

Throws:

SQLException

getGeneratedKeys

public ResultSet getGeneratedKeys()
                           throws SQLException

Specified by:

getGeneratedKeys in interface Statement

Overrides:

getGeneratedKeys in class DefaultStatement

Throws:

SQLException