public interface PreparedStatement extends Statement
An SQL Statement is put into a PreparedStatement
and is precompiled
so that it can be executed efficiently multiple times.
Setter methods are supplied in the PreparedStatement
interface for
the setting of IN
parameters for the statement. The setter method
used for each IN
parameter must match the parameter's type.
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method and Description |
---|---|
void |
addBatch()
Add a set of parameters to the
PreparedStatement 's command batch. |
void |
clearParameters()
Clear the current parameter values.
|
boolean |
execute()
Executes the SQL statement in this
PreparedStatement . |
ResultSet |
executeQuery()
Executes the SQL query in the
PreparedStatement and returns the
ResultSet generated by the query. |
int |
executeUpdate()
Invokes the SQL command contained within the prepared statement.
|
ResultSetMetaData |
getMetaData()
Returns a
ResultSetMetaData describing the ResultSet that would be produced by execution of the PreparedStatement . |
ParameterMetaData |
getParameterMetaData()
Gets information about the parameters of the
PreparedStatement . |
void |
setArray(int parameterIndex,
Array theArray)
Sets the value of a specified parameter to the supplied
Array . |
void |
setAsciiStream(int parameterIndex,
InputStream inputStream)
Sets the value of the specified parameter to the bytes
from
inputStream . |
void |
setAsciiStream(int parameterIndex,
InputStream theInputStream,
int length)
Sets the value of a specified parameter to the content of a supplied
InputStream , which has a specified number of bytes. |
void |
setAsciiStream(int parameterIndex,
InputStream inputStream,
long length)
Sets the value of the specified parameter to the next
length bytes
from inputStream . |
void |
setBigDecimal(int parameterIndex,
BigDecimal theBigDecimal)
Sets the value of a specified parameter to a supplied
java.math.BigDecimal value. |
void |
setBinaryStream(int parameterIndex,
InputStream inputStream)
Sets the value of the specified parameter to the bytes
from
inputStream . |
void |
setBinaryStream(int parameterIndex,
InputStream theInputStream,
int length)
Sets the value of a specified parameter to the content of a supplied
binary
InputStream , which has a specified number of bytes. |
void |
setBinaryStream(int parameterIndex,
InputStream inputStream,
long length)
Sets the value of the specified parameter to the next
length bytes
from inputStream . |
void |
setBlob(int parameterIndex,
Blob theBlob)
Sets the value of a specified parameter to the given
Blob object. |
void |
setBlob(int parameterIndex,
InputStream inputStream)
Sets the value of the specified parameter to the bytes
from
inputStream . |
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length)
Sets the value of the specified parameter to the next
length bytes
from inputStream . |
void |
setBoolean(int parameterIndex,
boolean theBoolean)
Sets the value of a specified parameter to a supplied
boolean
value. |
void |
setByte(int parameterIndex,
byte theByte)
Sets the value of a specified parameter to a supplied
byte value. |
void |
setBytes(int parameterIndex,
byte[] theBytes)
Sets the value of a specified parameter to a supplied array of bytes.
|
void |
setCharacterStream(int parameterIndex,
Reader reader)
Sets the value of the specified parameter to the characters
from
reader . |
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length)
Sets the value of a specified parameter to the character content of a
Reader object, with the specified length of character data. |
void |
setCharacterStream(int parameterIndex,
Reader reader,
long length)
Sets the value of the specified parameter to the next
length characters
from reader . |
void |
setClob(int parameterIndex,
Clob theClob)
Sets the value of a specified parameter to the given
Clob object. |
void |
setClob(int parameterIndex,
Reader reader)
Sets the value of the specified parameter to the characters
from
reader . |
void |
setClob(int parameterIndex,
Reader reader,
long length)
Sets the value of the specified parameter to the next
length characters
from reader . |
void |
setDate(int parameterIndex,
Date theDate)
Sets the value of a specified parameter to a supplied
java.sql.Date value. |
void |
setDate(int parameterIndex,
Date theDate,
Calendar cal)
Sets the value of a specified parameter to a supplied
java.sql.Date value, using a supplied Calendar to map the Date. |
void |
setDouble(int parameterIndex,
double theDouble)
Sets the value of a specified parameter to a supplied
double
value. |
void |
setFloat(int parameterIndex,
float theFloat)
Sets the value of a specified parameter to to a supplied
float
value. |
void |
setInt(int parameterIndex,
int theInt)
Sets the value of a specified parameter to a supplied
int value. |
void |
setLong(int parameterIndex,
long theLong)
Sets the value of a specified parameter to a supplied
long value. |
void |
setNCharacterStream(int parameterIndex,
Reader reader)
Sets the value of the specified parameter to the characters
from
reader . |
void |
setNCharacterStream(int parameterIndex,
Reader reader,
long length)
Sets the value of the specified parameter to the next
length characters
from reader . |
void |
setNClob(int parameterIndex,
NClob value)
Sets the value of the specified parameter to
value . |
void |
setNClob(int parameterIndex,
Reader reader)
Sets the value of the specified parameter to the characters
from
reader . |
void |
setNClob(int parameterIndex,
Reader reader,
long length)
Sets the value of the specified parameter to the next
length characters
from reader . |
void |
setNString(int parameterIndex,
String theString)
Sets the value of a specified parameter to a supplied string.
|
void |
setNull(int parameterIndex,
int sqlType)
Sets the value of a specified parameter to SQL
NULL . |
void |
setNull(int paramIndex,
int sqlType,
String typeName)
Sets the value of a specified parameter to SQL
NULL . |
void |
setObject(int parameterIndex,
Object theObject)
Sets the value of a specified parameter using a supplied object.
|
void |
setObject(int parameterIndex,
Object theObject,
int targetSqlType)
Sets the value of a specified parameter using a supplied object.
|
void |
setObject(int parameterIndex,
Object theObject,
int targetSqlType,
int scale)
Sets the value of a specified parameter using a supplied object.
|
void |
setRef(int parameterIndex,
Ref theRef)
Sets the value of a specified parameter to a supplied
REF(<structured-type>) value. |
void |
setRowId(int parameterIndex,
RowId theRowId)
Sets the value of a specified parameter to a supplied
java.sql.RowId . |
void |
setShort(int parameterIndex,
short theShort)
Sets the value of a specified parameter to a supplied
short
value. |
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject)
Sets the value of the specified parameter to the value of
xmlObject . |
void |
setString(int parameterIndex,
String theString)
Sets the value of a specified parameter to a supplied string.
|
void |
setTime(int parameterIndex,
Time theTime)
Sets the value of a specified parameter to a supplied
java.sql.Time value. |
void |
setTime(int parameterIndex,
Time theTime,
Calendar cal)
Sets the value of a specified parameter to a supplied
java.sql.Time value, using a supplied Calendar . |
void |
setTimestamp(int parameterIndex,
Timestamp theTimestamp)
Sets the value of a specified parameter to a supplied java.sql.Timestamp
value.
|
void |
setTimestamp(int parameterIndex,
Timestamp theTimestamp,
Calendar cal)
Sets the value of a specified parameter to a supplied
java.sql.Timestamp value, using the supplied Calendar . |
void |
setUnicodeStream(int parameterIndex,
InputStream theInputStream,
int length)
Deprecated.
|
void |
setURL(int parameterIndex,
URL theURL)
Sets the value of a specified parameter to a supplied
java.net.URL . |
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor, unwrap
void addBatch() throws SQLException
PreparedStatement
's command batch.SQLException
- if a database error happens.void clearParameters() throws SQLException
Typically, parameter values are retained for multiple executions of the
Statement
. Setting a parameter value replaces the previous value. This
method clears the values for all parameters, releasing all resources used
by those parameters.
SQLException
- if a database error happens.boolean execute() throws SQLException
PreparedStatement
.
A PreparedStatement
may return multiple results. The execute
method executes the PreparedStatement
and returns a flag
indicating the kind of result produced by the action. The methods
getResultSet
or getUpdateCount
are used to retrieve
the first result, and the second and subsequent results are
retrieved with getMoreResults
.
true
if the result of the execution is a ResultSet
, false
if there is no result or if the result
is an update count.SQLException
- if a database error happens.ResultSet executeQuery() throws SQLException
PreparedStatement
and returns the
ResultSet
generated by the query.ResultSet
generated by the query, never null
.SQLException
- if a database error happens or if the SQL statement does not
produce a ResultSet
.int executeUpdate() throws SQLException
INSERT
, UPDATE
, DELETE
, or a command that
returns nothing.INSERT
, UPDATE
or DELETE
statements, 0
for statements that return nothing.SQLException
- if a database error happens or if the SQL statement returns a
ResultSet
.ResultSetMetaData getMetaData() throws SQLException
ResultSetMetaData
describing the ResultSet
that would be produced by execution of the PreparedStatement
.
It is possible to know the metadata for the ResultSet
without
executing the PreparedStatement
, because the PreparedStatement
is precompiled. As a result the metadata can be
queried ahead of time without actually executing the statement.
ResultSetMetaData
object with the information about the
columns of the ResultSet
, if the driver can return a
ResultSetMetaData
. null
otherwise.SQLException
- if there is a database error.ParameterMetaData getParameterMetaData() throws SQLException
PreparedStatement
.ParameterMetaData
object which holds information about
the number, type, and properties of the parameters of this PreparedStatement
.SQLException
- if a database error happens.void setArray(int parameterIndex, Array theArray) throws SQLException
Array
.parameterIndex
- the parameter number index, where the first parameter has
index 1.theArray
- a java.sql.Array
giving the new value of the parameter at parameterIndex
.SQLException
- if a database error happens.Array
void setAsciiStream(int parameterIndex, InputStream theInputStream, int length) throws SQLException
InputStream
, which has a specified number of bytes.
This is a good method for setting an SQL LONGVARCHAR
parameter
where the length of the data is large. Data is read from the InputStream
until end-of-file is reached or the specified number of
bytes is copied.
parameterIndex
- the parameter number index, where the first parameter has
index 1.theInputStream
- the ASCII InputStream
carrying the data to which the
parameter at parameterIndex
is set.length
- the number of bytes in the InputStream
to copy to the
parameter.SQLException
- if a database error happens.void setBigDecimal(int parameterIndex, BigDecimal theBigDecimal) throws SQLException
java.math.BigDecimal
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theBigDecimal
- the value to which the parameter at parameterIndex
is
set.SQLException
- if a database error happens.BigDecimal
void setBinaryStream(int parameterIndex, InputStream theInputStream, int length) throws SQLException
InputStream
, which has a specified number of bytes.
Use this method when a large amount of data needs to be set into a
LONGVARBINARY
parameter.
parameterIndex
- the parameter number index, where the first parameter has
index 1.theInputStream
- the binary InputStream
carrying the data to update the
parameter.length
- the number of bytes in the InputStream
to copy to the
parameter.SQLException
- if a database error happens.void setBlob(int parameterIndex, Blob theBlob) throws SQLException
Blob
object.parameterIndex
- the parameter number index, where the first parameter has
index 1.theBlob
- the java.sql.Blob
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.Blob
void setBoolean(int parameterIndex, boolean theBoolean) throws SQLException
boolean
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theBoolean
- the boolean value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setByte(int parameterIndex, byte theByte) throws SQLException
byte
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theByte
- the byte value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setBytes(int parameterIndex, byte[] theBytes) throws SQLException
VARBINARY
or LONGVARBINARY
in the
database.parameterIndex
- the parameter number index, where the first parameter has
index 1.theBytes
- the array of bytes to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
Reader
object, with the specified length of character data.
Data is read from the Reader
until end-of-file is reached or the specified number of
characters are copied.
parameterIndex
- the parameter number index, where the first parameter has
index 1reader
- the java.io.Reader
containing the character data.length
- the number of characters to be read.SQLException
- if a database error happens.void setClob(int parameterIndex, Clob theClob) throws SQLException
Clob
object.parameterIndex
- the parameter number index, where the first parameter has
index 1.theClob
- a java.sql.Clob
holding the data to which the
parameter at parameterIndex
is set.SQLException
- if a database error happens.void setDate(int parameterIndex, Date theDate) throws SQLException
java.sql.Date
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theDate
- a java.sql.Date
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setDate(int parameterIndex, Date theDate, Calendar cal) throws SQLException
java.sql.Date
value, using a supplied Calendar
to map the Date.
The Calendar
allows the application to control the timezone used
to compute the SQL DATE
in the database - without the supplied
Calendar
, the driver uses the VM defaults.
See "Be wary of the default locale".parameterIndex
- the parameter number index, where the first parameter has
index 1.theDate
- a java.sql.Date
to which the parameter at parameterIndex
is set.cal
- a Calendar
to use to construct the SQL DATE
value.SQLException
- if a database error happens.Date
,
Calendar
void setDouble(int parameterIndex, double theDouble) throws SQLException
double
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theDouble
- the double
value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setFloat(int parameterIndex, float theFloat) throws SQLException
float
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theFloat
- the float
value to update the parameter.SQLException
- if a database error happens.void setInt(int parameterIndex, int theInt) throws SQLException
int
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theInt
- the int
value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setLong(int parameterIndex, long theLong) throws SQLException
long
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theLong
- the long
value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setNull(int parameterIndex, int sqlType) throws SQLException
NULL
. Don't use
this version of setNull
for User Defined Types (UDT) or
for REF type parameters.parameterIndex
- the parameter number index, where the first parameter has
index 1.sqlType
- the SQL type of the parameter, as defined in java.sql.Types
.SQLException
- if a database error happens.void setNull(int paramIndex, int sqlType, String typeName) throws SQLException
NULL
. This version
of setNull
should be used for User Defined Types (UDTs)
and also REF types. UDTs can be STRUCT
, DISTINCT
, JAVA_OBJECT
and named array types.
Applications must provide the SQL type code and also a fully qualified
SQL type name when supplying a NULL
UDT or REF. For a UDT, the
type name is the type name of the parameter itself, but for a REF
parameter the type name is the type name of the referenced type.
paramIndex
- the parameter number index, where the first parameter has
index 1.sqlType
- the SQL type of the parameter, as defined in java.sql.Types
.typeName
- the fully qualified name of a UDT or REF type - ignored if the
parameter is not a UDT.SQLException
- if a database error happens.Types
void setObject(int parameterIndex, Object theObject) throws SQLException
There is a standard mapping from Java types to SQL types, defined in the
JDBC specification. The passed object is then transformed into the
appropriate SQL type, and then transferred to the database. setObject
can be used to pass abstract data types unique to the
database, by using a JDBC driver specific Java type. If the object's
class implements the interface SQLData
, the JDBC driver calls
SQLData.writeSQL
to write it to the SQL data stream. If the
object's class implements Ref
, Blob
, Clob
,
Struct
, or Array
, the driver passes it to the database as
a value of the corresponding SQL type.
parameterIndex
- the parameter number index, where the first parameter has
index 1.theObject
- the object containing the value to which the parameter at
parameterIndex
is set.SQLException
- if a database error happens.void setObject(int parameterIndex, Object theObject, int targetSqlType) throws SQLException
The object is converted to the given targetSqlType
before it is
sent to the database. If the object has a custom mapping (its class
implements the interface SQLData
), the JDBC driver will call the method
SQLData.writeSQL
to write it to the SQL data stream. If the
object's class implements Ref
, Blob
, Clob
,
Struct
, or Array
, the driver will pass it to the database
in the form of the relevant SQL type.
parameterIndex
- the parameter index, where the first parameter has index 1.theObject
- the Object containing the value to which the parameter at
parameterIndex
is set.targetSqlType
- the SQL type to send to the database, as defined in java.sql.Types
.SQLException
- if a database error happens.void setObject(int parameterIndex, Object theObject, int targetSqlType, int scale) throws SQLException
The object is converted to the given targetSqlType
before it is
sent to the database. If the object has a custom mapping (its class
implements the interface SQLData
), the JDBC driver will call the method
SQLData.writeSQL
to write it to the SQL data stream. If the
object's class implements Ref
, Blob
, Clob
,
Struct
, or Array
, the driver will pass it to the database
in the form of the relevant SQL type.
parameterIndex
- the parameter index, where the first parameter has index 1.theObject
- the Object containing the value to which the parameter at
parameterIndex
is set.targetSqlType
- the SQL type to send to the database, as defined in java.sql.Types
.scale
- the number of digits after the decimal point - only applies to
the types java.sql.Types.DECIMAL
and java.sql.Types.NUMERIC
- ignored for all other types.SQLException
- if a database error happens.void setRef(int parameterIndex, Ref theRef) throws SQLException
REF(<structured-type>)
value. This is stored as an SQL REF
.parameterIndex
- the parameter number index, where the first parameter has
index 1.theRef
- a java.sql.Ref
value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.Ref
void setShort(int parameterIndex, short theShort) throws SQLException
short
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theShort
- a short
value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setString(int parameterIndex, String theString) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has
index 1.theString
- the value to which the parameter at parameterIndex
is
set.SQLException
- if a database error happens.void setTime(int parameterIndex, Time theTime) throws SQLException
java.sql.Time
value.parameterIndex
- the parameter number index, where the first parameter has
index 1.theTime
- a java.sql.Time
value to which the parameter at
parameterIndex
is set.SQLException
- if a database error happens.void setTime(int parameterIndex, Time theTime, Calendar cal) throws SQLException
java.sql.Time
value, using a supplied Calendar
.
The driver uses the supplied Calendar
to create the SQL TIME
value, which allows it to use a custom timezone - otherwise the
driver uses the VM defaults.
See "Be wary of the default locale".
parameterIndex
- the parameter number index, where the first parameter has
index 1.theTime
- a java.sql.Time
value to which the parameter at
parameterIndex
is set.cal
- a Calendar
to use to construct the SQL TIME
value.SQLException
- if a database error happens.Time
,
Calendar
void setTimestamp(int parameterIndex, Timestamp theTimestamp) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has
index 1.theTimestamp
- the java.sql.Timestamp value to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setTimestamp(int parameterIndex, Timestamp theTimestamp, Calendar cal) throws SQLException
java.sql.Timestamp
value, using the supplied Calendar
.
The driver uses the supplied Calendar
to create the SQL TIMESTAMP
value, which allows it to use a custom timezone - otherwise
the driver uses the VM defaults.
See "Be wary of the default locale".
parameterIndex
- the parameter number index, where the first parameter has
index 1.theTimestamp
- the java.sql.Timestamp
value to which the parameter at
parameterIndex
is set.cal
- a Calendar
to use to construct the SQL TIMESTAMP
valueSQLException
- if a database error happens.Timestamp
,
Calendar
@Deprecated void setUnicodeStream(int parameterIndex, InputStream theInputStream, int length) throws SQLException
setCharacterStream(int, Reader, int)
InputStream
, with a specified number of bytes.parameterIndex
- the parameter number index, where the first parameter has
index 1.theInputStream
- the InputStream
with the character data to which the
parameter at parameterIndex
is set.length
- the number of bytes to read from the InputStream
.SQLException
- if a database error happens.void setURL(int parameterIndex, URL theURL) throws SQLException
java.net.URL
.parameterIndex
- the parameter number index, where the first parameter has
index 1.theURL
- the URL
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.URL
void setRowId(int parameterIndex, RowId theRowId) throws SQLException
java.sql.RowId
.parameterIndex
- the parameter number index, where the first parameter has
index 1.theRowId
- the RowId
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setNString(int parameterIndex, String theString) throws SQLException
parameterIndex
- the parameter number index, where the first parameter has
index 1.theString
- the String
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setNCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
length
characters
from reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
length
- character countSQLException
- if a database error happens.void setNClob(int parameterIndex, NClob value) throws SQLException
value
.parameterIndex
- the parameter number index, where the first parameter has
index 1.value
- the NClob
to which the parameter at parameterIndex
is set.SQLException
- if a database error happens.void setClob(int parameterIndex, Reader reader, long length) throws SQLException
length
characters
from reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
length
- character countSQLException
- if a database error happens.void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
length
bytes
from inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
length
- character countSQLException
- if a database error happens.void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
length
characters
from reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
length
- character countSQLException
- if a database error happens.void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
xmlObject
.parameterIndex
- the parameter number index, where the first parameter has
index 1.xmlObject
- the SQLXML
SQLException
- if a database error happens.void setAsciiStream(int parameterIndex, InputStream inputStream, long length) throws SQLException
length
bytes
from inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
length
- character countSQLException
- if a database error happens.void setBinaryStream(int parameterIndex, InputStream inputStream, long length) throws SQLException
length
bytes
from inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
length
- character countSQLException
- if a database error happens.void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
length
characters
from reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
length
- character countSQLException
- if a database error happens.void setAsciiStream(int parameterIndex, InputStream inputStream) throws SQLException
inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
SQLException
- if a database error happens.void setBinaryStream(int parameterIndex, InputStream inputStream) throws SQLException
inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
SQLException
- if a database error happens.void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
SQLException
- if a database error happens.void setNCharacterStream(int parameterIndex, Reader reader) throws SQLException
reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
SQLException
- if a database error happens.void setClob(int parameterIndex, Reader reader) throws SQLException
reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
SQLException
- if a database error happens.void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
inputStream
.parameterIndex
- the parameter number index, where the first parameter has
index 1.inputStream
- the InputStream
SQLException
- if a database error happens.void setNClob(int parameterIndex, Reader reader) throws SQLException
reader
.parameterIndex
- the parameter number index, where the first parameter has
index 1.reader
- the Reader
SQLException
- if a database error happens.