Represents a callable statement.
Methods |
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
int |
executeUpdate() throws SQLException
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
If another result set exists for this statement, this will be closed
(even if this statement fails).
If auto commit is on, this statement will be committed.
If the statement is a DDL statement (create, drop, alter) and does not
throw an exception, the current transaction (if any) is committed after
executing the statement.
Returns:
the update count (number of row affected by an insert, update or
delete, or 0 if no rows or the statement was a create, drop,
commit or rollback)
Throws:
SQLException - if this object is closed or invalid
|
Array |
getArray(int parameterIndex)
Returns the value of the specified column as an Array.
|
Array |
getArray(int parameterIndex) throws SQLException
Returns the value of the specified column as an Array.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Array |
getArray(String parameterName)
Returns the value of the specified column as an Array.
|
Array |
getArray(String parameterName) throws SQLException
Returns the value of the specified column as an Array.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
BigDecimal |
getBigDecimal(int parameterIndex, int scale)
Returns the value of the specified column as a BigDecimal.
|
BigDecimal |
getBigDecimal(int parameterIndex, int scale) throws SQLException
Returns the value of the specified column as a BigDecimal.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
scale - is ignored
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
BigDecimal |
getBigDecimal(int parameterIndex)
Returns the value of the specified column as a BigDecimal.
|
BigDecimal |
getBigDecimal(int parameterIndex) throws SQLException
Returns the value of the specified column as a BigDecimal.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
BigDecimal |
getBigDecimal(String parameterName)
Returns the value of the specified column as a BigDecimal.
|
BigDecimal |
getBigDecimal(String parameterName) throws SQLException
Returns the value of the specified column as a BigDecimal.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Blob |
getBlob(int parameterIndex)
Returns the value of the specified column as a Blob.
|
Blob |
getBlob(int parameterIndex) throws SQLException
Returns the value of the specified column as a Blob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Blob |
getBlob(String parameterName)
Returns the value of the specified column as a Blob.
|
Blob |
getBlob(String parameterName) throws SQLException
Returns the value of the specified column as a Blob.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
boolean |
getBoolean(int parameterIndex)
Returns the value of the specified column as a boolean.
|
boolean |
getBoolean(int parameterIndex) throws SQLException
Returns the value of the specified column as a boolean.
Parameters:
parameterIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
boolean |
getBoolean(String parameterName)
Returns the value of the specified column as a boolean.
|
boolean |
getBoolean(String parameterName) throws SQLException
Returns the value of the specified column as a boolean.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
byte |
getByte(int parameterIndex)
Returns the value of the specified column as a byte.
|
byte |
getByte(int parameterIndex) throws SQLException
Returns the value of the specified column as a byte.
Parameters:
parameterIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
byte |
getByte(String parameterName)
Returns the value of the specified column as a byte.
|
byte |
getByte(String parameterName) throws SQLException
Returns the value of the specified column as a byte.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
byte[] |
getBytes(int parameterIndex)
Returns the value of the specified column as a byte array.
|
byte[] |
getBytes(int parameterIndex) throws SQLException
Returns the value of the specified column as a byte array.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
byte[] |
getBytes(String parameterName)
Returns the value of the specified column as a byte array.
|
byte[] |
getBytes(String parameterName) throws SQLException
Returns the value of the specified column as a byte array.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Reader |
getCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
Reader |
getCharacterStream(int parameterIndex) throws SQLException
Returns the value of the specified column as a reader.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Reader |
getCharacterStream(String parameterName)
Returns the value of the specified column as a reader.
|
Reader |
getCharacterStream(String parameterName) throws SQLException
Returns the value of the specified column as a reader.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Clob |
getClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
Clob |
getClob(int parameterIndex) throws SQLException
Returns the value of the specified column as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Clob |
getClob(String parameterName)
Returns the value of the specified column as a Clob.
|
Clob |
getClob(String parameterName) throws SQLException
Returns the value of the specified column as a Clob.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Date |
getDate(int parameterIndex)
Returns the value of the specified column as a java.sql.Date.
|
Date |
getDate(int parameterIndex) throws SQLException
Returns the value of the specified column as a java.sql.Date.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Date |
getDate(int parameterIndex, Calendar cal)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
Date |
getDate(int parameterIndex, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Date |
getDate(String parameterName, Calendar cal)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
Date |
getDate(String parameterName, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
Parameters:
parameterName - the parameter name
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Date |
getDate(String parameterName)
Returns the value of the specified column as a java.sql.Date.
|
Date |
getDate(String parameterName) throws SQLException
Returns the value of the specified column as a java.sql.Date.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
double |
getDouble(int parameterIndex)
Returns the value of the specified column as a double.
|
double |
getDouble(int parameterIndex) throws SQLException
Returns the value of the specified column as a double.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
double |
getDouble(String parameterName)
Returns the value of the specified column as a double.
|
double |
getDouble(String parameterName) throws SQLException
Returns the value of the specified column as a double.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
float |
getFloat(int parameterIndex)
Returns the value of the specified column as a float.
|
float |
getFloat(int parameterIndex) throws SQLException
Returns the value of the specified column as a float.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
float |
getFloat(String parameterName)
Returns the value of the specified column as a float.
|
float |
getFloat(String parameterName) throws SQLException
Returns the value of the specified column as a float.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
int |
getInt(int parameterIndex)
Returns the value of the specified column as an int.
|
int |
getInt(int parameterIndex) throws SQLException
Returns the value of the specified column as an int.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
int |
getInt(String parameterName)
Returns the value of the specified column as an int.
|
int |
getInt(String parameterName) throws SQLException
Returns the value of the specified column as an int.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
long |
getLong(int parameterIndex)
Returns the value of the specified column as a long.
|
long |
getLong(int parameterIndex) throws SQLException
Returns the value of the specified column as a long.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
long |
getLong(String parameterName)
Returns the value of the specified column as a long.
|
long |
getLong(String parameterName) throws SQLException
Returns the value of the specified column as a long.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Reader |
getNCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
Reader |
getNCharacterStream(int parameterIndex) throws SQLException
Returns the value of the specified column as a reader.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Reader |
getNCharacterStream(String parameterName)
Returns the value of the specified column as a reader.
|
Reader |
getNCharacterStream(String parameterName) throws SQLException
Returns the value of the specified column as a reader.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
NClob |
getNClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
NClob |
getNClob(int parameterIndex) throws SQLException
Returns the value of the specified column as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
NClob |
getNClob(String parameterName)
Returns the value of the specified column as a Clob.
|
NClob |
getNClob(String parameterName) throws SQLException
Returns the value of the specified column as a Clob.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
String |
getNString(int parameterIndex)
Returns the value of the specified column as a String.
|
String |
getNString(int parameterIndex) throws SQLException
Returns the value of the specified column as a String.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
String |
getNString(String parameterName)
Returns the value of the specified column as a String.
|
String |
getNString(String parameterName) throws SQLException
Returns the value of the specified column as a String.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Object |
getObject(int parameterIndex)
Returns a column value as a Java object.
|
Object |
getObject(int parameterIndex) throws SQLException
Returns a column value as a Java object. The data is
de-serialized into a Java object (on the client side).
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value or null
Throws:
SQLException - if the column is not found or if this object is
closed
|
Object |
getObject(int parameterIndex, Map map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
Object |
getObject(int parameterIndex, Map map) throws SQLException
[Not supported] Gets a column as a object using the specified type
mapping.
|
Object |
getObject(String parameterName, Map map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
Object |
getObject(String parameterName, Map map) throws SQLException
[Not supported] Gets a column as a object using the specified type
mapping.
|
Object |
getObject(String parameterName)
Returns a column value as a Java object.
|
Object |
getObject(String parameterName) throws SQLException
Returns a column value as a Java object. The data is
de-serialized into a Java object (on the client side).
Parameters:
parameterName - the parameter name
Returns:
the value or null
Throws:
SQLException - if the column is not found or if this object is
closed
|
T |
getObject(int parameterIndex, Class type)
[Not supported]
|
T |
getObject(int parameterIndex, Class type)
[Not supported]
Parameters:
parameterIndex - the parameter index (1, 2, ...)
type - the class of the returned value
|
T |
getObject(String parameterName, Class type)
[Not supported]
|
T |
getObject(String parameterName, Class type)
[Not supported]
Parameters:
parameterName - the parameter name
type - the class of the returned value
|
Ref |
getRef(int parameterIndex)
[Not supported] Gets a column as a reference.
|
Ref |
getRef(int parameterIndex) throws SQLException
[Not supported] Gets a column as a reference.
|
Ref |
getRef(String parameterName)
[Not supported] Gets a column as a reference.
|
Ref |
getRef(String parameterName) throws SQLException
[Not supported] Gets a column as a reference.
|
RowId |
getRowId(int parameterIndex)
[Not supported] Returns the value of the specified column as a row id.
|
RowId |
getRowId(int parameterIndex) throws SQLException
[Not supported] Returns the value of the specified column as a row id.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
|
RowId |
getRowId(String parameterName)
[Not supported] Returns the value of the specified column as a row id.
|
RowId |
getRowId(String parameterName) throws SQLException
[Not supported] Returns the value of the specified column as a row id.
Parameters:
parameterName - the parameter name
|
SQLXML |
getSQLXML(int parameterIndex)
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
SQLXML |
getSQLXML(int parameterIndex) throws SQLException
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
SQLXML |
getSQLXML(String parameterName)
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
SQLXML |
getSQLXML(String parameterName) throws SQLException
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
short |
getShort(int parameterIndex)
Returns the value of the specified column as a short.
|
short |
getShort(int parameterIndex) throws SQLException
Returns the value of the specified column as a short.
Parameters:
parameterIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
short |
getShort(String parameterName)
Returns the value of the specified column as a short.
|
short |
getShort(String parameterName) throws SQLException
Returns the value of the specified column as a short.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
String |
getString(int parameterIndex)
Returns the value of the specified column as a String.
|
String |
getString(int parameterIndex) throws SQLException
Returns the value of the specified column as a String.
Parameters:
parameterIndex - (1,2,...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
String |
getString(String parameterName)
Returns the value of the specified column as a String.
|
String |
getString(String parameterName) throws SQLException
Returns the value of the specified column as a String.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Time |
getTime(int parameterIndex)
Returns the value of the specified column as a java.sql.Time.
|
Time |
getTime(int parameterIndex) throws SQLException
Returns the value of the specified column as a java.sql.Time.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Time |
getTime(int parameterIndex, Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
Time |
getTime(int parameterIndex, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Time |
getTime(String parameterName, Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
Time |
getTime(String parameterName, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
Parameters:
parameterName - the parameter name
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Time |
getTime(String parameterName)
Returns the value of the specified column as a java.sql.Time.
|
Time |
getTime(String parameterName) throws SQLException
Returns the value of the specified column as a java.sql.Time.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Timestamp |
getTimestamp(int parameterIndex)
Returns the value of the specified column as a java.sql.Timestamp.
|
Timestamp |
getTimestamp(int parameterIndex) throws SQLException
Returns the value of the specified column as a java.sql.Timestamp.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Timestamp |
getTimestamp(int parameterIndex, Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
Timestamp |
getTimestamp(int parameterIndex, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Timestamp |
getTimestamp(String parameterName, Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
Timestamp |
getTimestamp(String parameterName, Calendar cal) throws SQLException
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
Parameters:
parameterName - the parameter name
cal - the calendar
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
Timestamp |
getTimestamp(String parameterName)
Returns the value of the specified column as a java.sql.Timestamp.
|
Timestamp |
getTimestamp(String parameterName) throws SQLException
Returns the value of the specified column as a java.sql.Timestamp.
Parameters:
parameterName - the parameter name
Returns:
the value
Throws:
SQLException - if the column is not found or if this object is
closed
|
URL |
getURL(int parameterIndex)
[Not supported]
|
URL |
getURL(int parameterIndex) throws SQLException
[Not supported]
|
URL |
getURL(String parameterName)
[Not supported]
|
URL |
getURL(String parameterName) throws SQLException
[Not supported]
|
void |
registerOutParameter(int parameterIndex, int sqlType)
Registers the given OUT parameter.
|
void |
registerOutParameter(int parameterIndex, int sqlType) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
sqlType - the data type (Types.x) - ignored
|
void |
registerOutParameter(int parameterIndex, int sqlType, String typeName)
Registers the given OUT parameter.
|
void |
registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
sqlType - the data type (Types.x) - ignored
typeName - the SQL type name - ignored
|
void |
registerOutParameter(int parameterIndex, int sqlType, int scale)
Registers the given OUT parameter.
|
void |
registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
sqlType - the data type (Types.x)
scale - is ignored
|
void |
registerOutParameter(String parameterName, int sqlType, String typeName)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterName - the parameter name
sqlType - the data type (Types.x) - ignored
typeName - the SQL type name - ignored
|
void |
registerOutParameter(String parameterName, int sqlType, int scale)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterName - the parameter name
sqlType - the data type (Types.x) - ignored
scale - is ignored
|
void |
registerOutParameter(String parameterName, int sqlType)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName, int sqlType) throws SQLException
Registers the given OUT parameter.
Parameters:
parameterName - the parameter name
sqlType - the data type (Types.x) - ignored
|
void |
setAsciiStream(String parameterName, InputStream x, long length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setAsciiStream(String parameterName, InputStream x)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(String parameterName, InputStream x) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setAsciiStream(String parameterName, InputStream x, int length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBigDecimal(String parameterName, BigDecimal x)
Sets the value of a parameter.
|
void |
setBigDecimal(String parameterName, BigDecimal x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(String parameterName, InputStream x, int length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(String parameterName, InputStream x)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(String parameterName, InputStream x) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(String parameterName, InputStream x, long length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBlob(String parameterName, InputStream x, long length)
Sets the value of a parameter as a Blob.
|
void |
setBlob(String parameterName, InputStream x, long length) throws SQLException
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBlob(String parameterName, Blob x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(String parameterName, Blob x) throws SQLException
Sets the value of a parameter as a Blob.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBlob(String parameterName, InputStream x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(String parameterName, InputStream x) throws SQLException
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBoolean(String parameterName, boolean x)
Sets the value of a parameter.
|
void |
setBoolean(String parameterName, boolean x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setByte(String parameterName, byte x)
Sets the value of a parameter.
|
void |
setByte(String parameterName, byte x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBytes(String parameterName, byte[] x)
Sets the value of a parameter as a byte array.
|
void |
setBytes(String parameterName, byte[] x) throws SQLException
Sets the value of a parameter as a byte array.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(String parameterName, Reader x, int length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(String parameterName, Reader x, int length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(String parameterName, Reader x)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(String parameterName, Reader x) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(String parameterName, Reader x, long length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(String parameterName, Reader x, long length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setClob(String parameterName, Reader x, long length)
Sets the value of a parameter as a Clob.
|
void |
setClob(String parameterName, Reader x, long length) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setClob(String parameterName, Clob x)
Sets the value of a parameter as a Clob.
|
void |
setClob(String parameterName, Clob x) throws SQLException
Sets the value of a parameter as a Clob.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setClob(String parameterName, Reader x)
Sets the value of a parameter as a character stream.
|
void |
setClob(String parameterName, Reader x) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setDate(String parameterName, Date x, Calendar cal)
Sets the date using a specified time zone.
|
void |
setDate(String parameterName, Date x, Calendar cal) throws SQLException
Sets the date using a specified time zone. The value will be converted to
the local time zone.
Parameters:
parameterName - the parameter name
x - the value
cal - the calendar
Throws:
SQLException - if this object is closed
|
void |
setDate(String parameterName, Date x)
Sets the value of a parameter.
|
void |
setDate(String parameterName, Date x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setDouble(String parameterName, double x)
Sets the value of a parameter.
|
void |
setDouble(String parameterName, double x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setFloat(String parameterName, float x)
Sets the value of a parameter.
|
void |
setFloat(String parameterName, float x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setInt(String parameterName, int x)
Sets the value of a parameter.
|
void |
setInt(String parameterName, int x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setLong(String parameterName, long x)
Sets the value of a parameter.
|
void |
setLong(String parameterName, long x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNCharacterStream(String parameterName, Reader x, long length)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(String parameterName, Reader x, long length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setNCharacterStream(String parameterName, Reader x)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(String parameterName, Reader x) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNClob(String parameterName, NClob x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(String parameterName, NClob x) throws SQLException
Sets the value of a parameter as a Clob.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNClob(String parameterName, Reader x, long length)
Sets the value of a parameter as a Clob.
|
void |
setNClob(String parameterName, Reader x, long length) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setNClob(String parameterName, Reader x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(String parameterName, Reader x) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNString(String parameterName, String x)
Sets the value of a parameter.
|
void |
setNString(String parameterName, String x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNull(String parameterName, int sqlType, String typeName)
Sets a parameter to null.
|
void |
setNull(String parameterName, int sqlType, String typeName) throws SQLException
Sets a parameter to null.
Parameters:
parameterName - the parameter name
sqlType - the data type (Types.x)
typeName - this parameter is ignored
Throws:
SQLException - if this object is closed
|
void |
setNull(String parameterName, int sqlType)
Sets a parameter to null.
|
void |
setNull(String parameterName, int sqlType) throws SQLException
Sets a parameter to null.
Parameters:
parameterName - the parameter name
sqlType - the data type (Types.x)
Throws:
SQLException - if this object is closed
|
void |
setObject(String parameterName, Object x)
Sets the value of a parameter.
|
void |
setObject(String parameterName, Object x) throws SQLException
Sets the value of a parameter.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setObject(String parameterName, Object x, int targetSqlType)
Sets the value of a parameter.
|
void |
setObject(String parameterName, Object x, int targetSqlType) throws SQLException
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterName - the parameter name
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
Throws:
SQLException - if this object is closed
|
void |
setObject(String parameterName, Object x, int targetSqlType, int scale)
Sets the value of a parameter.
|
void |
setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterName - the parameter name
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
scale - is ignored
Throws:
SQLException - if this object is closed
|
void |
setRowId(String parameterName, RowId x)
[Not supported] Sets the value of a parameter as a row id.
|
void |
setRowId(String parameterName, RowId x) throws SQLException
[Not supported] Sets the value of a parameter as a row id.
|
void |
setSQLXML(String parameterName, SQLXML x)
[Not supported] Sets the value of a parameter as a SQLXML object.
|
void |
setSQLXML(String parameterName, SQLXML x) throws SQLException
[Not supported] Sets the value of a parameter as a SQLXML object.
|
void |
setShort(String parameterName, short x)
Sets the value of a parameter.
|
void |
setShort(String parameterName, short x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setString(String parameterName, String x)
Sets the value of a parameter.
|
void |
setString(String parameterName, String x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setTime(String parameterName, Time x, Calendar cal)
Sets the time using a specified time zone.
|
void |
setTime(String parameterName, Time x, Calendar cal) throws SQLException
Sets the time using a specified time zone. The value will be converted to
the local time zone.
Parameters:
parameterName - the parameter name
x - the value
cal - the calendar
Throws:
SQLException - if this object is closed
|
void |
setTime(String parameterName, Time x)
Sets the time using a specified time zone.
|
void |
setTime(String parameterName, Time x) throws SQLException
Sets the time using a specified time zone.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setTimestamp(String parameterName, Timestamp x, Calendar cal)
Sets the timestamp using a specified time zone.
|
void |
setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
Sets the timestamp using a specified time zone. The value will be
converted to the local time zone.
Parameters:
parameterName - the parameter name
x - the value
cal - the calendar
Throws:
SQLException - if this object is closed
|
void |
setTimestamp(String parameterName, Timestamp x)
Sets the value of a parameter.
|
void |
setTimestamp(String parameterName, Timestamp x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterName - the parameter name
x - the value
Throws:
SQLException - if this object is closed
|
void |
setURL(String parameterName, URL val)
[Not supported]
|
void |
setURL(String parameterName, URL val) throws SQLException
[Not supported]
|
boolean |
wasNull()
Returns whether the last column accessed was null.
|
boolean |
wasNull() throws SQLException
Returns whether the last column accessed was null.
Returns:
true if the last column accessed was null
|