MySQL Connector/J 9.2.0 · com.mysql.cj.jdbc.PreparedStatementWrapper

Access	Constructor and Description
pack-priv	PreparedStatementWrapper(ConnectionWrapper c, MysqlPooledConnection conn, PreparedStatement toWrap)

Method Summary

Modifier and Type	Method and Description
public void	addBatch() Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
public void	clearParameters() Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
public void	close() Overrides com.mysql.cj.jdbc.StatementWrapper.close. Implements java.sql.Statement.close. Releases this `Statement` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
public boolean	execute() Implements java.sql.PreparedStatement.execute. Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
public long	executeLargeUpdate() Overrides default java.sql.PreparedStatement.executeLargeUpdate. 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 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 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.
protected static PreparedStatementWrapper	getInstance(ConnectionWrapper c, MysqlPooledConnection conn, PreparedStatement toWrap)
public 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 ParameterMetaData	getParameterMetaData() Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
public boolean	isWrapperFor(Class<?> a Class defining an interface. iface) Overrides com.mysql.cj.jdbc.StatementWrapper.isWrapperFor. Implements java.sql.Wrapper.isWrapperFor. Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
public 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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. scale) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(int the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database targetSqlType) Overrides default java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(int the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database. The scale argument may further qualify this type. targetSqlType, int for `java.sql.JDBCType.DECIMAL` or `java.sql.JDBCType.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) Overrides default java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public 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 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 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 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 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 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 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 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 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 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. Deprecated Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public 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.
public String	toString() Overrides java.lang.Object.toString. Returns a string representation of the object.
public <T> T	unwrap(Class<T> A Class defining an interface that the result must implement. iface) Overrides com.mysql.cj.jdbc.StatementWrapper.unwrap. Implements java.sql.Wrapper.unwrap. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public Class PreparedStatementWrapper

Field Summary

Constructor Summary

Method Summary