jOOQ 3.18.7 · org.jooq.impl.SettingsEnabledPreparedStatement

Modifier and Type	Class and Description
private static enum	SettingsEnabledPreparedStatement.MethodType A descriptor for the various methods that can create a prespared statement

Modifier and Type	Field and Description
private int	autoGeneratedKeys
private int[]	columnIndexes
private String[]	columnNames
private final Connection	connection
private final SettingsEnabledPreparedStatement.MethodType	methodType
private final String	sql

Access	Constructor and Description
private	SettingsEnabledPreparedStatement(Connection connection, String sql, SettingsEnabledPreparedStatement.MethodType type, Statement statement)
private	SettingsEnabledPreparedStatement(Connection connection, String sql, SettingsEnabledPreparedStatement.MethodType type)
pack-priv	SettingsEnabledPreparedStatement(Connection connection)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql, int resultSetType, int resultSetConcurrency)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql, int autoGeneratedKeys)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql, int[] columnIndexes)
pack-priv	SettingsEnabledPreparedStatement(Connection connection, String sql, String[] columnNames)

Method Summary

Modifier and Type	Method and Description
public final void	addBatch() Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
public final void	clearParameters() Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
public final boolean	execute() Implements java.sql.PreparedStatement.execute. Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
public final ResultSet	executeQuery() Implements java.sql.PreparedStatement.executeQuery. Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
public final int	executeUpdate() Implements java.sql.PreparedStatement.executeUpdate. Executes the SQL statement in this `PreparedStatement` object, which must be an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement.
public final Connection	getConnection() Overrides org.jooq.tools.jdbc.DefaultStatement.getConnection. Implements java.sql.Statement.getConnection. Retrieves the `Connection` object that produced this `Statement` object.
public final ResultSetMetaData	getMetaData() Implements java.sql.PreparedStatement.getMetaData. Retrieves a `ResultSetMetaData` object that contains information about the columns of the `ResultSet` object that will be returned when this `PreparedStatement` object is executed.
public final ParameterMetaData	getParameterMetaData() Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
public final void	setArray(int the first parameter is 1, the second is 2, ... parameterIndex, Array an `Array` object that maps an SQL `ARRAY` value x) Implements java.sql.PreparedStatement.setArray. Sets the designated parameter to the given `java.sql.Array` object.
public final void	setAsciiStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void	setAsciiStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void	setAsciiStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream.
public final void	setBigDecimal(int the first parameter is 1, the second is 2, ... parameterIndex, BigDecimal the parameter value x) Implements java.sql.PreparedStatement.setBigDecimal. Sets the designated parameter to the given `java.math.BigDecimal` value.
public final void	setBinaryStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void	setBinaryStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void	setBinaryStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public final void	setBlob(int the first parameter is 1, the second is 2, ... parameterIndex, Blob a `Blob` object that maps an SQL `BLOB` value x) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to the given `java.sql.Blob` object.
public final void	setBlob(int index of the first parameter is 1, the second is 2, ... parameterIndex, InputStream An object that contains the data to set the parameter value to. inputStream, long the number of bytes in the parameter data. length) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public final void	setBlob(int index of the first parameter is 1, the second is 2, ... parameterIndex, InputStream An object that contains the data to set the parameter value to. inputStream) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public final void	setBoolean(int the first parameter is 1, the second is 2, ... parameterIndex, boolean the parameter value x) Implements java.sql.PreparedStatement.setBoolean. Sets the designated parameter to the given Java `boolean` value.
public final void	setByte(int the first parameter is 1, the second is 2, ... parameterIndex, byte the parameter value x) Implements java.sql.PreparedStatement.setByte. Sets the designated parameter to the given Java `byte` value.
public final void	setBytes(int the first parameter is 1, the second is 2, ... parameterIndex, byte[] the parameter value x) Implements java.sql.PreparedStatement.setBytes. Sets the designated parameter to the given Java array of bytes.
public final void	setCharacterStream(int the first parameter is 1, the second is 2, ... parameterIndex, Reader the `java.io.Reader` object that contains the Unicode data reader, int the number of characters in the stream length) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public final void	setCharacterStream(int the first parameter is 1, the second is 2, ... parameterIndex, Reader the `java.io.Reader` object that contains the Unicode data reader, long the number of characters in the stream length) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public final void	setCharacterStream(int the first parameter is 1, the second is 2, ... parameterIndex, Reader the `java.io.Reader` object that contains the Unicode data reader) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public final void	setClob(int the first parameter is 1, the second is 2, ... parameterIndex, Clob a `Clob` object that maps an SQL `CLOB` value x) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to the given `java.sql.Clob` object.
public final void	setClob(int index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public final void	setClob(int index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public final void	setDate(int the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
public final void	setDate(int the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x, Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
public final void	setDouble(int the first parameter is 1, the second is 2, ... parameterIndex, double the parameter value x) Implements java.sql.PreparedStatement.setDouble. Sets the designated parameter to the given Java `double` value.
public final void	setFloat(int the first parameter is 1, the second is 2, ... parameterIndex, float the parameter value x) Implements java.sql.PreparedStatement.setFloat. Sets the designated parameter to the given Java `float` value.
public final void	setInt(int the first parameter is 1, the second is 2, ... parameterIndex, int the parameter value x) Implements java.sql.PreparedStatement.setInt. Sets the designated parameter to the given Java `int` value.
public final void	setLong(int the first parameter is 1, the second is 2, ... parameterIndex, long the parameter value x) Implements java.sql.PreparedStatement.setLong. Sets the designated parameter to the given Java `long` value.
public final void	setNCharacterStream(int of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value, long the number of characters in the parameter data. length) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public final void	setNCharacterStream(int of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public final void	setNClob(int of the first parameter is 1, the second is 2, ... parameterIndex, NClob the parameter value value) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public final void	setNClob(int index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public final void	setNClob(int index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public final void	setNString(int of the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value value) Implements java.sql.PreparedStatement.setNString. Sets the designated parameter to the given `String` object.
public final void	setNull(int the first parameter is 1, the second is 2, ... parameterIndex, int the SQL type code defined in `java.sql.Types` sqlType) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public final void	setNull(int the first parameter is 1, the second is 2, ... parameterIndex, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF typeName) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public final void	setObject(int the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be sent to the database targetSqlType) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public final void	setObject(int the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter using the given object.
public final void	setObject(int the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type. targetSqlType, int for `java.sql.Types.DECIMAL` or `java.sql.Types.NUMERIC types`, this is the number of digits after the decimal point. For Java Object types `InputStream` and `Reader`, this is the length of the data in the stream or reader. For all other types, this value will be ignored. scaleOrLength) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public final void	setRef(int the first parameter is 1, the second is 2, ... parameterIndex, Ref an SQL `REF` value x) Implements java.sql.PreparedStatement.setRef. Sets the designated parameter to the given `REF(<structured-type>)` value.
public final void	setRowId(int the first parameter is 1, the second is 2, ... parameterIndex, RowId the parameter value x) Implements java.sql.PreparedStatement.setRowId. Sets the designated parameter to the given `java.sql.RowId` object.
public final void	setShort(int the first parameter is 1, the second is 2, ... parameterIndex, short the parameter value x) Implements java.sql.PreparedStatement.setShort. Sets the designated parameter to the given Java `short` value.
public final void	setSQLXML(int index of the first parameter is 1, the second is 2, ... parameterIndex, SQLXML a `SQLXML` object that maps an SQL `XML` value xmlObject) Implements java.sql.PreparedStatement.setSQLXML. Sets the designated parameter to the given `java.sql.SQLXML` object.
public final void	setString(int the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value x) Implements java.sql.PreparedStatement.setString. Sets the designated parameter to the given Java `String` value.
public final void	setTime(int the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value.
public final void	setTime(int the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x, Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
public final void	setTimestamp(int the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value.
public final void	setTimestamp(int the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x, Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public final void	setUnicodeStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream a `java.io.InputStream` object that contains the Unicode parameter value x, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setUnicodeStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void	setURL(int the first parameter is 1, the second is 2, ... parameterIndex, URL the `java.net.URL` object to be set x) Implements java.sql.PreparedStatement.setURL. Sets the designated parameter to the given `java.net.URL` value.

pack-priv final Class SettingsEnabledPreparedStatement

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary