public class JdbcPreparedStatement extends JdbcStatement implements java.sql.PreparedStatement
Thread safety: the prepared statement is not thread-safe. If the same prepared statement is used by multiple threads access to it must be synchronized. The single synchronized block must include assignment of parameters, execution of the command and all operations with its result.
synchronized (prep) { prep.setInt(1, 10); try (ResultSet rs = prep.executeQuery()) { while (rs.next) { // Do something } } } synchronized (prep) { prep.setInt(1, 15); updateCount = prep.executeUpdate(); }
Modifier and Type | Field and Description |
---|---|
protected org.h2.command.CommandInterface |
command |
conn, fetchSize, generatedKeys, maxRows, resultSet, resultSetConcurrency, resultSetType, session, updateCount
Modifier and Type | Method and Description |
---|---|
void |
addBatch()
Adds the current settings to the batch.
|
void |
addBatch(java.lang.String sql)
Calling this method is not legal on a PreparedStatement.
|
void |
clearBatch()
Clears the batch.
|
void |
clearParameters()
Clears all parameters.
|
void |
close()
Closes this statement.
|
boolean |
execute()
Executes an arbitrary statement.
|
int[] |
executeBatch()
Executes the batch.
|
long[] |
executeLargeBatch()
Executes the batch.
|
long |
executeLargeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
java.sql.ResultSet |
executeQuery()
Executes a query (select statement) and returns the result set.
|
java.sql.ResultSet |
executeQuery(java.lang.String sql)
Calling this method is not legal on a PreparedStatement.
|
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
java.sql.ResultSet |
getGeneratedKeys()
Return a result set with generated keys from the latest executed command
or an empty result set if keys were not generated or were not requested
with
Statement.RETURN_GENERATED_KEYS , column indexes, or column
names. |
java.sql.ResultSetMetaData |
getMetaData()
Gets the result set metadata of the query returned when the statement is
executed.
|
java.sql.ParameterMetaData |
getParameterMetaData()
Get the parameter meta data of this prepared statement.
|
void |
setArray(int parameterIndex,
java.sql.Array x)
Sets the value of a parameter as an Array.
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as an ASCII stream.
|
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
Sets the value of a parameter.
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as an input stream.
|
void |
setBlob(int parameterIndex,
java.sql.Blob x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as a Blob.
|
void |
setBoolean(int parameterIndex,
boolean x)
Sets the value of a parameter.
|
void |
setByte(int parameterIndex,
byte x)
Sets the value of a parameter.
|
void |
setBytes(int parameterIndex,
byte[] x)
Sets the value of a parameter as a byte array.
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader x,
int length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setClob(int parameterIndex,
java.sql.Clob x)
Sets the value of a parameter as a Clob.
|
void |
setClob(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a Clob.
|
void |
setClob(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setDate(int parameterIndex,
java.sql.Date x)
Sets the value of a parameter.
|
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar calendar)
Sets the date using a specified time zone.
|
void |
setDouble(int parameterIndex,
double x)
Sets the value of a parameter.
|
void |
setFloat(int parameterIndex,
float x)
Sets the value of a parameter.
|
void |
setInt(int parameterIndex,
int x)
Sets the value of a parameter.
|
void |
setLong(int parameterIndex,
long x)
Sets the value of a parameter.
|
void |
setNCharacterStream(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setNClob(int parameterIndex,
java.sql.NClob x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setNString(int parameterIndex,
java.lang.String x)
Sets the value of a parameter.
|
void |
setNull(int parameterIndex,
int sqlType)
Sets a parameter to null.
|
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
Sets a parameter to null.
|
void |
setObject(int parameterIndex,
java.lang.Object x)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
java.sql.SQLType targetSqlType)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
java.sql.SQLType targetSqlType,
int scaleOrLength)
Sets the value of a parameter.
|
void |
setRef(int parameterIndex,
java.sql.Ref x)
[Not supported] Sets the value of a column as a reference.
|
void |
setRowId(int parameterIndex,
java.sql.RowId x)
[Not supported] Sets the value of a parameter as a row id.
|
void |
setShort(int parameterIndex,
short x)
Sets the value of a parameter.
|
void |
setSQLXML(int parameterIndex,
java.sql.SQLXML x)
Sets the value of a parameter as a SQLXML.
|
void |
setString(int parameterIndex,
java.lang.String x)
Sets the value of a parameter.
|
void |
setTime(int parameterIndex,
java.sql.Time x)
Sets the value of a parameter.
|
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar calendar)
Sets the time using a specified time zone.
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
Sets the value of a parameter.
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar calendar)
Sets the timestamp using a specified time zone.
|
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
Deprecated.
since JDBC 2.0, use setCharacterStream
|
void |
setURL(int parameterIndex,
java.net.URL x)
[Not supported]
|
java.lang.String |
toString()
INTERNAL
|
cancel, clearWarnings, closeOldResultSet, closeOnCompletion, enquoteIdentifier, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isCancelled, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
executeQuery
in interface java.sql.PreparedStatement
java.sql.SQLException
- if this object is closed or invalidpublic int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
Statement.SUCCESS_NO_INFO
if number of rows is too large for
int
data type)java.sql.SQLException
- if this object is closed or invalidexecuteLargeUpdate()
public long executeLargeUpdate() throws java.sql.SQLException
executeLargeUpdate
in interface java.sql.PreparedStatement
java.sql.SQLException
- if this object is closed or invalidpublic boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
java.sql.SQLException
- if this object is closed or invalidpublic void clearParameters() throws java.sql.SQLException
clearParameters
in interface java.sql.PreparedStatement
java.sql.SQLException
- if this object is closed or invalidpublic java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
executeQuery
in interface java.sql.Statement
executeQuery
in class JdbcStatement
sql
- ignoredjava.sql.SQLException
- Unsupported Featurepublic void addBatch(java.lang.String sql) throws java.sql.SQLException
addBatch
in interface java.sql.Statement
addBatch
in class JdbcStatement
sql
- ignoredjava.sql.SQLException
- Unsupported Featurepublic void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x)java.sql.SQLException
- if this object is closedpublic void setInt(int parameterIndex, int x) throws java.sql.SQLException
setInt
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with LocalDate
parameter instead.
setDate
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedsetObject(int, Object)
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with LocalTime
parameter instead.
setTime
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedsetObject(int, Object)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with
LocalDateTime
parameter instead.
setTimestamp
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedsetObject(int, Object)
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.Typesjava.sql.SQLException
- if this object is closedpublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.Typesscale
- is ignoredjava.sql.SQLException
- if this object is closedpublic void setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the value, null is allowedtargetSqlType
- the SQL typejava.sql.SQLException
- if this object is closedpublic void setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the value, null is allowedtargetSqlType
- the SQL typescaleOrLength
- is ignoredjava.sql.SQLException
- if this object is closedpublic void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setByte(int parameterIndex, byte x) throws java.sql.SQLException
setByte
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setShort(int parameterIndex, short x) throws java.sql.SQLException
setShort
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setLong(int parameterIndex, long x) throws java.sql.SQLException
setLong
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setFloat(int parameterIndex, float x) throws java.sql.SQLException
setFloat
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setDouble(int parameterIndex, double x) throws java.sql.SQLException
setDouble
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
setRef
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with LocalDate
parameter instead.
setDate
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuecalendar
- the calendarjava.sql.SQLException
- if this object is closedsetObject(int, Object)
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with LocalTime
parameter instead.
setTime
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuecalendar
- the calendarjava.sql.SQLException
- if this object is closedsetObject(int, Object)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar calendar) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterIndex, value)
with
LocalDateTime
parameter instead.
setTimestamp
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuecalendar
- the calendarjava.sql.SQLException
- if this object is closedsetObject(int, Object)
@Deprecated public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
setUnicodeStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x)typeName
- this parameter is ignoredjava.sql.SQLException
- if this object is closedpublic void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setBlob(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setClob(int parameterIndex, java.io.Reader x) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setArray(int parameterIndex, java.sql.Array x) throws java.sql.SQLException
setArray
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setBinaryStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setBinaryStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setCharacterStream(int parameterIndex, java.io.Reader x, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setCharacterStream(int parameterIndex, java.io.Reader x) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setCharacterStream(int parameterIndex, java.io.Reader x, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
setURL
in interface java.sql.PreparedStatement
java.sql.SQLException
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
- if this object is closedpublic void clearBatch() throws java.sql.SQLException
clearBatch
in interface java.sql.Statement
clearBatch
in class JdbcStatement
java.sql.SQLException
public void close() throws java.sql.SQLException
close
in interface java.lang.AutoCloseable
close
in interface java.sql.Statement
close
in class JdbcStatement
java.sql.SQLException
public int[] executeBatch() throws java.sql.SQLException
executeBatch
in interface java.sql.Statement
executeBatch
in class JdbcStatement
java.sql.SQLException
executeLargeBatch()
public long[] executeLargeBatch() throws java.sql.SQLException
executeLargeBatch
in interface java.sql.Statement
executeLargeBatch
in class JdbcStatement
java.sql.SQLException
public java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException
JdbcStatement
Statement.RETURN_GENERATED_KEYS
, column indexes, or column
names.
Generated keys are only returned from from INSERT
,
UPDATE
, MERGE INTO
, and MERGE INTO ... USING
commands.
If SQL command inserts or updates multiple rows with generated keys each such inserted or updated row is returned. Batch methods are also supported.
When Statement.RETURN_GENERATED_KEYS
is used H2 chooses columns
to return automatically. The following columns are chosen:
IDENTITY
columns and columns
with AUTO_INCREMENT
.DEFAULT RANDOM_UUID()
).Exact required columns for the returning result set may be specified on execution of command with names or indexes of columns.
getGeneratedKeys
in interface java.sql.Statement
getGeneratedKeys
in class JdbcStatement
java.sql.SQLException
- if this object is closedpublic void addBatch() throws java.sql.SQLException
addBatch
in interface java.sql.PreparedStatement
java.sql.SQLException
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
getParameterMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
setNString
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setNCharacterStream(int parameterIndex, java.io.Reader x, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setNCharacterStream(int parameterIndex, java.io.Reader x) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setNClob(int parameterIndex, java.sql.NClob x) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setNClob(int parameterIndex, java.io.Reader x) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic void setClob(int parameterIndex, java.io.Reader x, long length) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setBlob(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setNClob(int parameterIndex, java.io.Reader x, long length) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setSQLXML(int parameterIndex, java.sql.SQLXML x) throws java.sql.SQLException
setSQLXML
in interface java.sql.PreparedStatement
parameterIndex
- the parameter index (1, 2, ...)x
- the valuejava.sql.SQLException
- if this object is closedpublic java.lang.String toString()
toString
in class JdbcStatement