Deprecated
as a consequence of DefaultStatement being deprecated. See corresponding docs for further information.
| Access | Constructor and Description |
|---|---|
| public | |
| protected | |
| protected | |
| protected | DefaultPreparedStatement(Statement delegate, Connection creator, Supplier<? extends SQLException> errorIfUnsupported)
|
| Modifier and Type | Method and Description |
|---|---|
| public void | addBatch()
Implements java. PreparedStatement
object's batch of commands.
|
| public void | clearParameters()
Implements java. |
| public boolean | execute()
Implements java. PreparedStatement object,
which may be any kind of SQL statement.
|
| public long | executeLargeUpdate()
Overrides default java. 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. PreparedStatement object
and returns the ResultSet object generated by the query.
|
| public int | executeUpdate()
Implements java. 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 PreparedStatement | |
| public final PreparedStatement | |
| public ResultSetMetaData | getMetaData()
Implements java. 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. PreparedStatement object's parameters.
|
| public void | setArray(int
the first parameter is 1, the second is 2, ... parameterIndex, Array an x)Array object that maps an SQL ARRAY valueImplements java. 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. |
| 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. |
| 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. |
| public void | setBigDecimal(int
the first parameter is 1, the second is 2, ... parameterIndex, BigDecimal the parameter value x)Implements java. 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. |
| 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. |
| 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. |
| public void | setBlob(int
the first parameter is 1, the second is 2, ... parameterIndex, Blob a x)Blob object that maps an SQL BLOB valueImplements java. 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. 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. InputStream object.
|
| public void | setBoolean(int
the first parameter is 1, the second is 2, ... parameterIndex, boolean the parameter value x)Implements java. boolean value.
|
| public void | setByte(int
the first parameter is 1, the second is 2, ... parameterIndex, byte the parameter value x)Implements java. byte value.
|
| public void | setBytes(int
the first parameter is 1, the second is 2, ... parameterIndex, byte[] the parameter value x)Implements java. |
| public void | setCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex, Reader the reader, int java.io.Reader object that contains the
Unicode datathe number of characters in the stream length)Implements java. 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 reader, long java.io.Reader object that contains the
Unicode datathe number of characters in the stream length)Implements java. 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 reader)java.io.Reader object that contains the
Unicode dataImplements java. Reader
object.
|
| public void | setClob(int
the first parameter is 1, the second is 2, ... parameterIndex, Clob a x)Clob object that maps an SQL CLOB valueImplements java. 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. 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. Reader object.
|
| public void | setDate(int
the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x)Implements java. 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 cal)Calendar object the driver will use
to construct the dateImplements java. 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. double value.
|
| public void | setFloat(int
the first parameter is 1, the second is 2, ... parameterIndex, float the parameter value x)Implements java. float value.
|
| public void | setInt(int
the first parameter is 1, the second is 2, ... parameterIndex, int the parameter value x)Implements java. int value.
|
| public void | setLong(int
the first parameter is 1, the second is 2, ... parameterIndex, long the parameter value x)Implements 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. Reader object.
|
| public void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value)Implements java. Reader object.
|
| public void | setNClob(int
of the first parameter is 1, the second is 2, ... parameterIndex, NClob the parameter value value)Implements java. 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. 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. Reader object.
|
| public void | setNString(int
of the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value value)Implements java. String object.
|
| public void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int the SQL type code defined in sqlType)java.sql.TypesImplements java. NULL.
|
| public void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or REF typeName)Implements java. NULL.
|
| 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. |
| 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. 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. The scale argument may further qualify this type. targetSqlType, int for scaleOrLength)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.Implements java. 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 scaleOrLength)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.Overrides default java. 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. |
| public void | setRef(int
the first parameter is 1, the second is 2, ... parameterIndex, Ref an SQL x)REF valueImplements java. 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. 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. short value.
|
| public void | setSQLXML(int
index of the first parameter is 1, the second is 2, ... parameterIndex, SQLXML a xmlObject)SQLXML object that maps an SQL XML valueImplements java. 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. String value.
|
| public void | setTime(int
the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x)Implements java. 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 cal)Calendar object the driver will use
to construct the timeImplements java. 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. 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 cal)Calendar object the driver will use
to construct the timestampImplements java. 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 x, int java.io.InputStream object that contains the
Unicode parameter valuethe number of bytes in the stream length)Implements java.
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 x)java.net.URL object to be setImplements java. java.net.URL value.
|