| java.lang.Object com.uwyn.rife.database.DbStatement com.uwyn.rife.database.DbPreparedStatement
Method Summary | |
public void | addBatch() Adds a set of parameters to this DbPreparedStatement
object's batch of commands. | public void | clearParameters() Clears the current parameter values immediately.
In general, parameter values remain in force for repeated use of
a statement. | public void | close() Releases this DbPreparedStatement object's database
and JDBC resources immediately instead of waiting for this to
happen when it is automatically closed. | public void | executeQuery() Executes the SQL query in this DbPreparedStatement
object. | public int | executeUpdate() Executes the SQL statement in this DbPreparedStatement
object, which must be an SQL INSERT ,
UPDATE or DELETE statement; or a SQL
statement that returns nothing, such as a DDL statement. | public ResultSetMetaData | getMetaData() Retrieves a ResultSetMetaData object that contains
information about the columns of the ResultSet object
that will be returned when this PDbreparedStatement
object is executed.
Because a DbPreparedStatement object is
precompiled, it is possible to know about the
ResultSet object that it will return without having to
execute it. | public int[] | getParameterIndices(String parameterName) Retrieves all the parameter indices that correspond to the name of
a parameter of the ParametrizedQuery object that is
used by this DbPreparedStatement instance. | public ParameterMetaData | getParameterMetaData() Retrieves the number, types and properties of this
DbPreparedStatement object's parameters. | public Query | getQuery() Returns the query builder that provides the SQL query that will be
executed by this prepared statement. | public String | getSql() Returns the SQL query that will be executed by this prepared
statement. | public Object | getVirtualParameterValue(String name) Get the value of a specific virtual parameter. | public Object | getVirtualParameterValue(int parameterIndex) Get the value of a specific virtual parameter. | public DbPreparedStatement | setArray(String parameterName, Array x) Sets the named parameters to the given Array object. | public DbPreparedStatement | setArray(int parameterIndex, Array x) Sets the designated parameter to the given Array
object. | public DbPreparedStatement | setAsciiStream(String parameterName, InputStream x, int length) Sets the named parameter to the given input stream, which will have
the specified number of bytes. | public DbPreparedStatement | setAsciiStream(int parameterIndex, InputStream x, int length) Sets the designated parameter to the given input stream, which will
have the specified number of bytes. | public DbPreparedStatement | setBean(Object bean) Automatically retrieves all the values of a bean's properties and
sets them for the parameters that have been defined by the
ParametrizedQuery object of this
DbPrepareStatement instance.
Parameters: bean - the bean whose properties should be assigned to thequery's parameters. | public DbPreparedStatement | setBigDecimal(String parameterName, BigDecimal x) Sets the named parameters to the given
java.math.BigDecimal value. | public DbPreparedStatement | setBigDecimal(int parameterIndex, BigDecimal x) Sets the designated parameter to the given
java.math.BigDecimal value. | public DbPreparedStatement | setBigDecimals(int[] parameterIndices, BigDecimal x) Sets the designated parameters to the given
java.math.BigDecimal value. | public DbPreparedStatement | setBinaryStream(String parameterName, InputStream x, int length) Sets the named parameter to the given input stream, which will have
the specified number of bytes. | public DbPreparedStatement | setBinaryStream(int parameterIndex, InputStream x, int length) Sets the designated parameter to the given input stream, which will
have the specified number of bytes. | public DbPreparedStatement | setBlob(String parameterName, Blob x) Sets the named parameter to the given Blob object. | public DbPreparedStatement | setBlob(int parameterIndex, Blob x) Sets the designated parameter to the given Blob
object. | public DbPreparedStatement | setBoolean(String parameterName, boolean x) Sets the named parameters to the given Java boolean
value. | public DbPreparedStatement | setBoolean(int parameterIndex, boolean x) Sets the designated parameter to the given Java
boolean value. | public DbPreparedStatement | setBooleans(int[] parameterIndices, boolean x) Sets the designated parameters to the given Java
boolean value. | public DbPreparedStatement | setByte(String parameterName, byte x) Sets the named parameters to the given Java byte
value. | public DbPreparedStatement | setByte(int parameterIndex, byte x) Sets the designated parameter to the given Java byte
value. | public DbPreparedStatement | setBytes(int[] parameterIndices, byte x) Sets the designated parameters to the given Java byte
value. | public DbPreparedStatement | setBytes(String parameterName, byte x) Sets the named parameters to the given Java array of bytes. | public DbPreparedStatement | setBytes(int[] parameterIndices, byte x) Sets the designated parameters to the given Java array of bytes. | public DbPreparedStatement | setBytes(int parameterIndex, byte x) Sets the designated parameter to the given Java array of bytes. | public DbPreparedStatement | setCharacterStream(String parameterName, Reader x, int length) Sets the named parameter to the given Reader object,
which is the given number of characters long. | public DbPreparedStatement | setCharacterStream(int parameterIndex, Reader x, int length) Sets the designated parameter to the given Reader
object, which is the given number of characters long. | public DbPreparedStatement | setClob(String parameterName, Clob x) Sets the named parameter to the given Clob object. | public DbPreparedStatement | setClob(int parameterIndex, Clob x) Sets the designated parameter to the given Clob
object. | public DbPreparedStatement | setDate(String parameterName, Date x) Sets the named parameters to the given java.sql.Date
value. | public DbPreparedStatement | setDate(int parameterIndex, Date x) Sets the designated parameter to the given
java.sql.Date value. | public DbPreparedStatement | setDate(String parameterName, Date x, Calendar cal) Sets the named parameters to the given java.sql.Date
value, using the given Calendar object. | public DbPreparedStatement | setDate(int parameterIndex, Date x, Calendar cal) Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object. | public DbPreparedStatement | setDates(int[] parameterIndices, Date x) Sets the designated parameters to the given
java.sql.Date value. | public DbPreparedStatement | setDates(int[] parameterIndices, Date x, Calendar cal) Sets the designated parameters to the given
java.sql.Date value, using the given
Calendar object. | public DbPreparedStatement | setDouble(String parameterName, double x) Sets the named parameters to the given Java double
value. | public DbPreparedStatement | setDouble(int parameterIndex, double x) Sets the designated parameter to the given Java double
value. | public DbPreparedStatement | setDoubles(int[] parameterIndices, double x) Sets the designated parameters to the given Java
double value. | public DbPreparedStatement | setFloat(String parameterName, float x) Sets the named parameters to the given Java float
value. | public DbPreparedStatement | setFloat(int parameterIndex, float x) Sets the designated parameter to the given Java float
value. | public DbPreparedStatement | setFloats(int[] parameterIndices, float x) Sets the designated parameters to the given Java float
value. | public DbPreparedStatement | setInt(String parameterName, int x) Sets the named parameter to the given Java int value. | public DbPreparedStatement | setInt(int parameterIndex, int x) Sets the designated parameter to the given Java int
value. | public DbPreparedStatement | setInts(int[] parameterIndices, int x) Sets the designated parameters to the given Java int
value. | public DbPreparedStatement | setLong(String parameterName, long x) Sets the named parameters to the given Java long
value. | public DbPreparedStatement | setLong(int parameterIndex, long x) Sets the designated parameter to the given Java long
value. | public DbPreparedStatement | setLongs(int[] parameterIndices, long x) Sets the designated parameters to the given Java long
value. | public DbPreparedStatement | setNull(String parameterName, int sqlType) Sets the named parameters to SQL NULL . | public DbPreparedStatement | setNull(int parameterIndex, int sqlType) Sets the designated parameter to SQL NULL . | public DbPreparedStatement | setNull(String parameterName, int sqlType, String typeName) Sets the named parameters to SQL NULL . | public DbPreparedStatement | setNull(int parameterIndex, int sqlType, String typeName) Sets the designated parameter to SQL NULL . | public DbPreparedStatement | setNulls(int[] parameterIndices, int sqlType) Sets the designated parameters to SQL NULL . | public DbPreparedStatement | setNulls(int[] parameterIndices, int sqlType, String typeName) Sets the designated parameters to SQL NULL . | public DbPreparedStatement | setObject(String parameterName, Object x, int targetSqlType, int scale) Sets the value of the named parameters with the given object. | public DbPreparedStatement | setObject(int parameterIndex, Object x, int targetSqlType, int scale) Sets the value of the designated parameter with the given object.
The second argument must be an object type; for integral values,
the java.lang equivalent objects should be used.
The given Java object will be converted to the given
targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing
the interface SQLData ), the JDBC driver should call
the method SQLData.writeSQL to write it to the SQL
data stream. | public DbPreparedStatement | setObject(String parameterName, Object x, int targetSqlType) Sets the value of the named parameters with the given object. | public DbPreparedStatement | setObject(int parameterIndex, Object x, int targetSqlType) Sets the value of the designated parameter with the given object. | public DbPreparedStatement | setObject(String parameterName, Object x) Sets the value of the named parameters using the given object. | public DbPreparedStatement | setObject(int parameterIndex, Object x) Sets the value of the designated parameter using the given object.
The second parameter must be of type Object ;
therefore, the java.lang equivalent objects should be
used for built-in types.
The JDBC specification specifies a standard mapping from Java
Object types to SQL types. | public DbPreparedStatement | setObjects(int[] parameterIndices, Object x, int targetSqlType, int scale) Sets the value of the designated parameters with the given object.
The second argument must be an object type; for integral values,
the java.lang equivalent objects should be used.
The given Java object will be converted to the given
targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing
the interface SQLData ), the JDBC driver should call
the method SQLData.writeSQL to write it to the SQL
data stream. | public DbPreparedStatement | setObjects(int[] parameterIndices, Object x, int targetSqlType) Sets the value of the designated parameters with the given object. | public DbPreparedStatement | setObjects(int[] parameterIndices, Object x) Sets the value of the designated parameters using the given object.
The second parameter must be of type Object ;
therefore, the java.lang equivalent objects should be
used for built-in types.
The JDBC specification specifies a standard mapping from Java
Object types to SQL types. | public DbPreparedStatement | setRef(String parameterName, Ref x) Sets the named parameter to the given
REF(<structured-type>) value. | public DbPreparedStatement | setRef(int parameterIndex, Ref x) Sets the designated parameter to the given
REF(<structured-type>) value. | public DbPreparedStatement | setShort(String parameterName, short x) Sets the named parameters to the given Java short
value. | public DbPreparedStatement | setShort(int parameterIndex, short x) Sets the designated parameter to the given Java short
value. | public DbPreparedStatement | setShorts(int[] parameterIndices, short x) Sets the designated parameters to the given Java short
value. | public DbPreparedStatement | setString(String parameterName, String x) Sets the named parameters to the given Java String
value. | public DbPreparedStatement | setString(int parameterIndex, String x) Sets the designated parameter to the given Java String
value. | public DbPreparedStatement | setStrings(int[] parameterIndices, String x) Sets the designated parameters to the given Java
String value. | public DbPreparedStatement | setTime(String parameterName, Time x) Sets the named parameters to the given java.sql.Time
value. | public DbPreparedStatement | setTime(int parameterIndex, Time x) Sets the designated parameter to the given
java.sql.Time value. | public DbPreparedStatement | setTime(String parameterName, Time x, Calendar cal) Sets the named parameters to the given java.sql.Time
value, using the given Calendar object. | public DbPreparedStatement | setTime(int parameterIndex, Time x, Calendar cal) Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object. | public DbPreparedStatement | setTimes(int[] parameterIndices, Time x) Sets the designated parameters to the given
java.sql.Time value. | public DbPreparedStatement | setTimes(int[] parameterIndices, Time x, Calendar cal) Sets the designated parameters to the given
java.sql.Time value, using the given
Calendar object. | public DbPreparedStatement | setTimestamp(String parameterName, Timestamp x) Sets the named parameters to the given
java.sql.Timestamp value. | public DbPreparedStatement | setTimestamp(int parameterIndex, Timestamp x) Sets the designated parameter to the given
java.sql.Timestamp value. | public DbPreparedStatement | setTimestamp(String parameterName, Timestamp x, Calendar cal) Sets the named parameters to the given
java.sql.Timestamp value, using the given
Calendar object. | public DbPreparedStatement | setTimestamp(int parameterIndex, Timestamp x, Calendar cal) Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object. | public DbPreparedStatement | setTimestamps(int[] parameterIndices, Timestamp x) Sets the designated parameters to the given
java.sql.Timestamp value. | public DbPreparedStatement | setTimestamps(int[] parameterIndices, Timestamp x, Calendar cal) Sets the designated parameters to the given
java.sql.Timestamp value, using the given
Calendar object. | public DbPreparedStatement | setURL(String parameterName, URL x) Sets the named parameters to the given java.net.URL
value. | public DbPreparedStatement | setURL(int parameterIndex, URL x) Sets the designated parameter to the given
java.net.URL value. | public DbPreparedStatement | setURLs(int[] parameterIndices, URL x) Sets the designated parameters to the given
java.net.URL value. | public void | setVirtualParameters(VirtualParameters parameters) Sets the parameters that should be handled as virtual parameters. |
DbPreparedStatement | DbPreparedStatement(DbConnection connection, String sql, PreparedStatement preparedStatement) throws DatabaseException(Code) | | Constructs a new DbStatement from a SQL query string,
a DbConnection and a PreparedStatement .
This constructor will never be called by a user of the api. The
getPreparedStatement of an existing
DbConnection instance should be used instead.
Parameters: connection - a DbConnection instance Parameters: sql - a String with the sql statement Parameters: preparedStatement - a JDBC PreparedStatement instance exception: DatabaseException - if a database access error occurs since: 1.0 |
DbPreparedStatement | DbPreparedStatement(DbConnection connection, Query query, PreparedStatement preparedStatement) throws DatabaseException(Code) | | Constructs a new DbStatement from a
ParametrizedQuery , a DbConnection and a
PreparedStatement . This constructor will never be
called by a user of the api. The getPreparedStatement
of an existing DbConnection instance should be used
instead.
Parameters: connection - a DbConnection instance Parameters: sql - a String with the sql statement Parameters: preparedStatement - a JDBC PreparedStatement instance exception: DatabaseException - if a database access error occurs since: 1.0 |
addBatch | public void addBatch() throws DatabaseException(Code) | | Adds a set of parameters to this DbPreparedStatement
object's batch of commands.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
exception: DatabaseException - if a database access error occurs See Also: com.uwyn.rife.database.DbStatement.addBatch since: 1.0 |
clearParameters | public void clearParameters() throws DatabaseException(Code) | | Clears the current parameter values immediately.
In general, parameter values remain in force for repeated use of
a statement. Setting a parameter value automatically clears its
previous value. However, in some cases it is useful to immediately
release the resources used by the current parameter values; this
can be done by calling the method clearParameters .
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
exception: DatabaseException - if a database access error occurs since: 1.0 |
close | public void close() throws DatabaseException(Code) | | Releases this DbPreparedStatement object's database
and JDBC resources immediately instead of waiting for this to
happen when it is automatically closed. It is generally good
practice to release resources as soon as you are finished with them
to avoid tying up database resources.
Calling the method close on a
DbPreparedStatement object that is already closed has
no effect.
Note: A DbPreparedStatement object is
automatically closed when it is garbage collected. When a
DbPreparedStatement object is closed, its current
ResultSet object, if one exists, is also closed.
exception: DatabaseException - if a database access error occurs since: 1.0 |
executeQuery | public void executeQuery() throws DatabaseException(Code) | | Executes the SQL query in this DbPreparedStatement
object. The ResultSet object generated by the query is
stored and can be retrieved with the getResultSet
method.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
exception: DatabaseException - if a database access error occurs orthe SQL statement does not return a ResultSet object See Also: DbPreparedStatement.getResultSet() since: 1.0 |
executeUpdate | public int executeUpdate() throws DatabaseException(Code) | | Executes the SQL statement in this DbPreparedStatement
object, which must be an SQL INSERT ,
UPDATE or DELETE statement; or a SQL
statement that returns nothing, such as a DDL statement.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
the row count for INSERT , UPDATE ,or DELETE statements; or 0 for SQL statements that return nothing exception: DatabaseException - if a database access error occurs orthe SQL statement returns a ResultSet object since: 1.0 |
getMetaData | public ResultSetMetaData getMetaData() throws DatabaseException(Code) | | Retrieves a ResultSetMetaData object that contains
information about the columns of the ResultSet object
that will be returned when this PDbreparedStatement
object is executed.
Because a DbPreparedStatement object is
precompiled, it is possible to know about the
ResultSet object that it will return without having to
execute it. Consequently, it is possible to invoke the method
getMetaData on a DbPreparedStatement
object rather than waiting to execute it and then invoking the
ResultSet.getMetaData method on the
ResultSet object that is returned.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
NOTE: Using this method may be expensive for some drivers
due to the lack of underlying DBMS support.
the description of a ResultSet object'scolumns; or null if the driver cannot return aResultSetMetaData object exception: DatabaseException - if a database access error occurs since: 1.0
|
getParameterIndices | public int[] getParameterIndices(String parameterName) throws DatabaseException(Code) | | Retrieves all the parameter indices that correspond to the name of
a parameter of the ParametrizedQuery object that is
used by this DbPreparedStatement instance.
Parameters: parameterName - the name of the parameter that should belooked up an int array with all the correspondingindices exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found. since: 1.0 |
getParameterMetaData | public ParameterMetaData getParameterMetaData() throws DatabaseException(Code) | | Retrieves the number, types and properties of this
DbPreparedStatement object's parameters.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
a ParameterMetaData object that containsinformation about the number, types and properties of thisDbPreparedStatement object's parameters. exception: DatabaseException - if a database access error occurs See Also: java.sql.ParameterMetaData since: 1.0 |
getQuery | public Query getQuery()(Code) | | Returns the query builder that provides the SQL query that will be
executed by this prepared statement.
a Query object with the query builderinstance; ornull if the prepared statement was initialized froma string SQL query since: 1.0
|
getSql | public String getSql()(Code) | | Returns the SQL query that will be executed by this prepared
statement.
a String with the SQL query of this preparedstatement since: 1.0 |
getVirtualParameterValue | public Object getVirtualParameterValue(String name) throws UndefinedVirtualParameterException(Code) | | Get the value of a specific virtual parameter.
Parameters: name - the name of the parameter whose value should beretrieved the requested value exception: DatabaseException - when an error occurred during theretrieval of the parameter's value since: 1.0 |
getVirtualParameterValue | public Object getVirtualParameterValue(int parameterIndex) throws DatabaseException(Code) | | Get the value of a specific virtual parameter.
Parameters: parameterIndex - the index of the parameter whose value shouldbe retrieved the requested value exception: DatabaseException - when an error occurred during theretrieval of the parameter's value since: 1.0 |
setArray | public DbPreparedStatement setArray(String parameterName, Array x) throws DatabaseException(Code) | | Sets the named parameters to the given Array object.
The driver converts this to a SQL ARRAY value when it
sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameter that will be set Parameters: x - an Array object that maps an SQLARRAY value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setArray(int,Array) since: 1.0 |
setArray | public DbPreparedStatement setArray(int parameterIndex, Array x) throws DatabaseException(Code) | | Sets the designated parameter to the given Array
object. The driver converts this to a SQL ARRAY value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - an Array object that maps an SQLARRAY value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setArray(String,Array) since: 1.0 |
setAsciiStream | public DbPreparedStatement setAsciiStream(String parameterName, InputStream x, int length) throws DatabaseException(Code) | | Sets the named parameter to the given input stream, which will have
the specified number of bytes. When a very large ASCII value is
input to a LONGVARCHAR parameter, it may be more
practical to send it via a java.io.InputStream . Data
will be read from the stream as needed until end-of-file is
reached. The JDBC driver will do any necessary conversion from
ASCII to the database char format.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - the Java input stream that contains the ASCII parametervalue Parameters: length - the number of bytes in the stream this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setAsciiStream(int,InputStream,int) since: 1.0 |
setAsciiStream | public DbPreparedStatement setAsciiStream(int parameterIndex, InputStream x, int length) throws DatabaseException(Code) | | Sets the designated parameter to the given input stream, which will
have the specified number of bytes. When a very large ASCII value
is input to a LONGVARCHAR parameter, it may be more
practical to send it via a java.io.InputStream . Data
will be read from the stream as needed until end-of-file is
reached. The JDBC driver will do any necessary conversion from
ASCII to the database char format.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the Java input stream that contains the ASCII parametervalue Parameters: length - the number of bytes in the stream this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setAsciiStream(String,InputStream,int) since: 1.0 |
setBean | public DbPreparedStatement setBean(Object bean) throws DatabaseException(Code) | | Automatically retrieves all the values of a bean's properties and
sets them for the parameters that have been defined by the
ParametrizedQuery object of this
DbPrepareStatement instance.
Parameters: bean - the bean whose properties should be assigned to thequery's parameters. this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if an error occurred during the manipulation of the bean'sproperties. since: 1.0 |
setBigDecimal | public DbPreparedStatement setBigDecimal(String parameterName, BigDecimal x) throws DatabaseException(Code) | | Sets the named parameters to the given
java.math.BigDecimal value. The driver converts this
to a SQL NUMERIC value when it sends it to the
database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setBigDecimal(int,BigDecimal) See Also: DbPreparedStatement.setBigDecimals(int[],BigDecimal) since: 1.0 |
setBinaryStream | public DbPreparedStatement setBinaryStream(String parameterName, InputStream x, int length) throws DatabaseException(Code) | | Sets the named parameter to the given input stream, which will have
the specified number of bytes. When a very large binary value is
input to a LONGVARBINARY parameter, it may be more
practical to send it via a java.io.InputStream object.
The data will be read from the stream as needed until end-of-file
is reached.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - the java input stream which contains the binary parametervalue Parameters: length - the number of bytes in the stream this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setBinaryStream(int,InputStream,int) since: 1.0 |
setBinaryStream | public DbPreparedStatement setBinaryStream(int parameterIndex, InputStream x, int length) throws DatabaseException(Code) | | Sets the designated parameter to the given input stream, which will
have the specified number of bytes. When a very large binary value
is input to a LONGVARBINARY parameter, it may be more
practical to send it via a java.io.InputStream object.
The data will be read from the stream as needed until end-of-file
is reached.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the java input stream which contains the binary parametervalue Parameters: length - the number of bytes in the stream this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBinaryStream(String,InputStream,int) since: 1.0 |
setBlob | public DbPreparedStatement setBlob(String parameterName, Blob x) throws DatabaseException(Code) | | Sets the named parameter to the given Blob object. The
driver converts this to a SQL BLOB value when it sends
it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - a Blob object that maps an SQLBLOB value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setBlob(String,Blob) since: 1.0 |
setBlob | public DbPreparedStatement setBlob(int parameterIndex, Blob x) throws DatabaseException(Code) | | Sets the designated parameter to the given Blob
object. The driver converts this to a SQL BLOB value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - a Blob object that maps an SQLBLOB value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBlob(String,Blob) since: 1.0 |
setBoolean | public DbPreparedStatement setBoolean(String parameterName, boolean x) throws DatabaseException(Code) | | Sets the named parameters to the given Java boolean
value. The driver converts this to a SQL BIT value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setBoolean(String,boolean) See Also: DbPreparedStatement.setBooleans(int[],boolean) since: 1.0 |
setBoolean | public DbPreparedStatement setBoolean(int parameterIndex, boolean x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java
boolean value. The driver converts this to a SQL
BIT value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBoolean(String,boolean) See Also: DbPreparedStatement.setBooleans(int[],boolean) since: 1.0 |
setBooleans | public DbPreparedStatement setBooleans(int[] parameterIndices, boolean x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java
boolean value. The driver converts this to a SQL
BIT value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBoolean(String,boolean) See Also: DbPreparedStatement.setBoolean(int,boolean) since: 1.0 |
setByte | public DbPreparedStatement setByte(String parameterName, byte x) throws DatabaseException(Code) | | Sets the named parameters to the given Java byte
value. The driver converts this to a SQL TINYINT value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setByte(int,byte) See Also: DbPreparedStatement.setBytes(int[],byte) since: 1.0 |
setByte | public DbPreparedStatement setByte(int parameterIndex, byte x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java byte
value. The driver converts this to a SQL TINYINT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setByte(String,byte) See Also: DbPreparedStatement.setBytes(int[],byte) since: 1.0 |
setBytes | public DbPreparedStatement setBytes(int[] parameterIndices, byte x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java byte
value. The driver converts this to a SQL TINYINT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setByte(String,byte) See Also: DbPreparedStatement.setByte(int,byte) since: 1.0 |
setBytes | public DbPreparedStatement setBytes(String parameterName, byte x) throws DatabaseException(Code) | | Sets the named parameters to the given Java array of bytes. The
driver converts this to a SQL VARBINARY or
LONGVARBINARY (depending on the argument's size
relative to the driver's limits on VARBINARY values)
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setBytes(int[],byte[]) See Also: DbPreparedStatement.setBytes(int,byte[]) since: 1.0 |
setBytes | public DbPreparedStatement setBytes(int[] parameterIndices, byte x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java array of bytes.
The driver converts this to a SQL VARBINARY or
LONGVARBINARY (depending on the argument's size
relative to the driver's limits on VARBINARY values)
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBytes(String,byte[]) See Also: DbPreparedStatement.setBytes(int,byte[]) since: 1.0 |
setBytes | public DbPreparedStatement setBytes(int parameterIndex, byte x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java array of bytes. The
driver converts this to a SQL VARBINARY or
LONGVARBINARY (depending on the argument's size
relative to the driver's limits on VARBINARY values)
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setBytes(String,byte[]) See Also: DbPreparedStatement.setBytes(int[],byte[]) since: 1.0 |
setCharacterStream | public DbPreparedStatement setCharacterStream(String parameterName, Reader x, int length) throws DatabaseException(Code) | | Sets the named parameter to the given Reader object,
which is the given number of characters long. When a very large
UNICODE value is input to a LONGVARCHAR parameter, it
may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until
end-of-file is reached. The JDBC driver will do any necessary
conversion from UNICODE to the database char format.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - the java.io.Reader object that containsthe Unicode data Parameters: length - the number of characters in the stream this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setCharacterStream(int,Reader,int) since: 1.0 |
setCharacterStream | public DbPreparedStatement setCharacterStream(int parameterIndex, Reader x, int length) throws DatabaseException(Code) | | Sets the designated parameter to the given Reader
object, which is the given number of characters long. When a very
large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The data will be read from the
stream as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char
format.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note: This stream object can either be a standard Java
stream object or your own subclass that implements the standard
interface.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the java.io.Reader object that containsthe Unicode data Parameters: length - the number of characters in the stream this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setCharacterStream(String,Reader,int) since: 1.0 |
setClob | public DbPreparedStatement setClob(String parameterName, Clob x) throws DatabaseException(Code) | | Sets the named parameter to the given Clob object. The
driver converts this to a SQL CLOB value when it sends
it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - a Clob object that maps an SQLCLOB value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setClob(int,Clob) since: 1.0 |
setClob | public DbPreparedStatement setClob(int parameterIndex, Clob x) throws DatabaseException(Code) | | Sets the designated parameter to the given Clob
object. The driver converts this to a SQL CLOB value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - a Clob object that maps an SQLCLOB value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setClob(String,Clob) since: 1.0 |
setDate | public DbPreparedStatement setDate(String parameterName, Date x) throws DatabaseException(Code) | | Sets the named parameters to the given java.sql.Date
value. The driver converts this to a SQL DATE value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setDates(int[],Date) See Also: DbPreparedStatement.setDate(int,Date) since: 1.0 |
setDate | public DbPreparedStatement setDate(int parameterIndex, Date x) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.sql.Date value. The driver converts this to a SQL
DATE value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDate(String,Date) See Also: DbPreparedStatement.setDates(int[],Date) since: 1.0 |
setDate | public DbPreparedStatement setDate(String parameterName, Date x, Calendar cal) throws DatabaseException(Code) | | Sets the named parameters to the given java.sql.Date
value, using the given Calendar object. The driver
uses the Calendar object to construct an SQL
DATE value, which the driver then sends to the
database. With a Calendar object, the driver can
calculate the date taking into account a custom timezone. If no
Calendar object is specified, the driver uses the
default timezone, which is that of the virtual machine running the
application.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the date this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setDates(int[],Date,Calendar) See Also: DbPreparedStatement.setDate(int,Date,Calendar) since: 1.0 |
setDate | public DbPreparedStatement setDate(int parameterIndex, Date x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL DATE
value, which the driver then sends to the database. With a
Calendar object, the driver can calculate the date
taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is
that of the virtual machine running the application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the date this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDate(String,Date,Calendar) See Also: DbPreparedStatement.setDates(int[],Date,Calendar) since: 1.0 |
setDates | public DbPreparedStatement setDates(int[] parameterIndices, Date x) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.sql.Date value. The driver converts this to a SQL
DATE value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDate(String,Date) See Also: DbPreparedStatement.setDate(int,Date) since: 1.0 |
setDates | public DbPreparedStatement setDates(int[] parameterIndices, Date x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.sql.Date value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL DATE
value, which the driver then sends to the database. With a
Calendar object, the driver can calculate the date
taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is
that of the virtual machine running the application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the date this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDate(String,Date,Calendar) See Also: DbPreparedStatement.setDate(int,Date,Calendar) since: 1.0 |
setDouble | public DbPreparedStatement setDouble(String parameterName, double x) throws DatabaseException(Code) | | Sets the named parameters to the given Java double
value. The driver converts this to a SQL DOUBLE value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setDoubles(int[],double) See Also: DbPreparedStatement.setDouble(int,double) since: 1.0 |
setDouble | public DbPreparedStatement setDouble(int parameterIndex, double x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java double
value. The driver converts this to a SQL DOUBLE value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDouble(String,double) See Also: DbPreparedStatement.setDoubles(int[],double) since: 1.0 |
setDoubles | public DbPreparedStatement setDoubles(int[] parameterIndices, double x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java
double value. The driver converts this to a SQL
DOUBLE value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setDouble(String,double) See Also: DbPreparedStatement.setDouble(int,double) since: 1.0 |
setFloat | public DbPreparedStatement setFloat(String parameterName, float x) throws DatabaseException(Code) | | Sets the named parameters to the given Java float
value. The driver converts this to a SQL FLOAT value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setFloats(int[],float) See Also: DbPreparedStatement.setFloat(int,float) since: 1.0 |
setFloat | public DbPreparedStatement setFloat(int parameterIndex, float x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java float
value. The driver converts this to a SQL FLOAT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setFloat(String,float) See Also: DbPreparedStatement.setFloats(int[],float) since: 1.0 |
setFloats | public DbPreparedStatement setFloats(int[] parameterIndices, float x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java float
value. The driver converts this to a SQL FLOAT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setFloat(String,float) See Also: DbPreparedStatement.setFloat(int,float) since: 1.0 |
setInt | public DbPreparedStatement setInt(String parameterName, int x) throws DatabaseException(Code) | | Sets the named parameter to the given Java int value.
The driver converts this to a SQL INTEGER value when
it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setInt(int,int) See Also: DbPreparedStatement.setInts(int[],int) since: 1.0 |
setInt | public DbPreparedStatement setInt(int parameterIndex, int x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java int
value. The driver converts this to a SQL INTEGER value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setInt(String,int) See Also: DbPreparedStatement.setInts(int[],int) since: 1.0 |
setInts | public DbPreparedStatement setInts(int[] parameterIndices, int x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java int
value. The driver converts this to a SQL INTEGER value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setInt(String,int) See Also: DbPreparedStatement.setInt(int,int) since: 1.0 |
setLong | public DbPreparedStatement setLong(String parameterName, long x) throws DatabaseException(Code) | | Sets the named parameters to the given Java long
value. The driver converts this to a SQL BIGINT value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setLongs(int[],long) See Also: DbPreparedStatement.setLong(int,long) since: 1.0 |
setLong | public DbPreparedStatement setLong(int parameterIndex, long x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java long
value. The driver converts this to a SQL BIGINT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setLong(String,long) See Also: DbPreparedStatement.setLongs(int[],long) since: 1.0 |
setLongs | public DbPreparedStatement setLongs(int[] parameterIndices, long x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java long
value. The driver converts this to a SQL BIGINT value
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setLong(String,long) See Also: DbPreparedStatement.setLong(int,long) since: 1.0 |
setNull | public DbPreparedStatement setNull(String parameterName, int sqlType) throws DatabaseException(Code) | | Sets the named parameters to SQL NULL .
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Note: You must specify the parameter's SQL type.
Parameters: parameterName - the name of the parameters that have to be set Parameters: sqlType - the SQL type code defined injava.sql.Types this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: java.sql.Types See Also: DbPreparedStatement.setNulls(int[],int) See Also: DbPreparedStatement.setNull(int,int) since: 1.0 |
setNull | public DbPreparedStatement setNull(String parameterName, int sqlType, String typeName) throws DatabaseException(Code) | | Sets the named parameters to SQL NULL . This version of
the method setNull should be used for user-defined
types and REF type parameters. Examples of user-defined types
include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
Note: To be portable, applications must give the SQL type
code and the fully-qualified SQL type name when specifying a NULL
user-defined or REF parameter. In the case of a user-defined type
the name is the type name of the parameter itself. For a REF
parameter, the name is the type name of the referenced type. If a
JDBC driver does not need the type code or type name information,
it may ignore it.
Although it is intended for user-defined and Ref parameters,
this method may be used to set a null parameter of any JDBC type.
If the parameter does not have a user-defined or REF type, the
given typeName is ignored.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: sqlType - a value from java.sql.Types Parameters: typeName - the fully-qualified name of an SQL user-definedtype; ignored if the parameter is not a user-defined type or REF this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: java.sql.Types See Also: DbPreparedStatement.setNulls(int[],int,String) See Also: DbPreparedStatement.setNull(int,int,String) since: 1.0 |
setNull | public DbPreparedStatement setNull(int parameterIndex, int sqlType, String typeName) throws DatabaseException(Code) | | Sets the designated parameter to SQL NULL . This
version of the method setNull should be used for
user-defined types and REF type parameters. Examples of
user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Note: To be portable, applications must give the SQL type
code and the fully-qualified SQL type name when specifying a NULL
user-defined or REF parameter. In the case of a user-defined type
the name is the type name of the parameter itself. For a REF
parameter, the name is the type name of the referenced type. If a
JDBC driver does not need the type code or type name information,
it may ignore it.
Although it is intended for user-defined and Ref parameters,
this method may be used to set a null parameter of any JDBC type.
If the parameter does not have a user-defined or REF type, the
given typeName is ignored.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: sqlType - a value from java.sql.Types Parameters: typeName - the fully-qualified name of an SQL user-definedtype; ignored if the parameter is not a user-defined type or REF this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setNull(String,int,String) See Also: DbPreparedStatement.setNulls(int[],int,String) since: 1.0 |
setNulls | public DbPreparedStatement setNulls(int[] parameterIndices, int sqlType) throws DatabaseException(Code) | | Sets the designated parameters to SQL NULL .
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note: You must specify the parameter's SQL type.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: sqlType - the SQL type code defined injava.sql.Types this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setNull(String,int) See Also: DbPreparedStatement.setNull(int,int) since: 1.0 |
setNulls | public DbPreparedStatement setNulls(int[] parameterIndices, int sqlType, String typeName) throws DatabaseException(Code) | | Sets the designated parameters to SQL NULL . This
version of the method setNull should be used for
user-defined types and REF type parameters. Examples of
user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Note: To be portable, applications must give the SQL type
code and the fully-qualified SQL type name when specifying a NULL
user-defined or REF parameter. In the case of a user-defined type
the name is the type name of the parameter itself. For a REF
parameter, the name is the type name of the referenced type. If a
JDBC driver does not need the type code or type name information,
it may ignore it.
Although it is intended for user-defined and Ref parameters,
this method may be used to set a null parameter of any JDBC type.
If the parameter does not have a user-defined or REF type, the
given typeName is ignored.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: sqlType - a value from java.sql.Types Parameters: typeName - the fully-qualified name of an SQL user-definedtype; ignored if the parameter is not a user-defined type or REF this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setNull(String,int,String) See Also: DbPreparedStatement.setNull(int,int,String) since: 1.0 |
setObject | public DbPreparedStatement setObject(String parameterName, Object x, int targetSqlType, int scale) throws DatabaseException(Code) | | Sets the value of the named parameters with the given object. The
second argument must be an object type; for integral values, the
java.lang equivalent objects should be used.
The given Java object will be converted to the given
targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing
the interface SQLData ), the JDBC driver should call
the method SQLData.writeSQL to write it to the SQL
data stream. If, on the other hand, the object is of a class
implementing Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Note that this method may be used to pass database-specific
abstract data types.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database. The scale argument may further qualifythis type. Parameters: scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERICtypes, this is the number of digits after the decimal point. Forall other types, this value will be ignored. this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: java.sql.Types See Also: DbPreparedStatement.setObjects(int[],Object,int,int) See Also: DbPreparedStatement.setObject(int,Object,int,int) since: 1.0 |
setObject | public DbPreparedStatement setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws DatabaseException(Code) | | Sets the value of the designated parameter with the given object.
The second argument must be an object type; for integral values,
the java.lang equivalent objects should be used.
The given Java object will be converted to the given
targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing
the interface SQLData ), the JDBC driver should call
the method SQLData.writeSQL to write it to the SQL
data stream. If, on the other hand, the object is of a class
implementing Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note that this method may be used to pass database-specific
abstract data types.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database. The scale argument may further qualifythis type. Parameters: scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERICtypes, this is the number of digits after the decimal point. Forall other types, this value will be ignored. this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setObject(String,Object,int,int) See Also: DbPreparedStatement.setObjects(int[],Object,int,int) since: 1.0 |
setObject | public DbPreparedStatement setObject(String parameterName, Object x, int targetSqlType) throws DatabaseException(Code) | | Sets the value of the named parameters with the given object. This
method is like the method setObject above, except that
it assumes a scale of zero.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: java.sql.Types See Also: DbPreparedStatement.setObjects(int[],Object,int) See Also: DbPreparedStatement.setObject(int,Object,int) since: 1.0 |
setObject | public DbPreparedStatement setObject(int parameterIndex, Object x, int targetSqlType) throws DatabaseException(Code) | | Sets the value of the designated parameter with the given object.
This method is like the method setObject above, except
that it assumes a scale of zero.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setObject(String,Object,int) See Also: DbPreparedStatement.setObjects(int[],Object,int) since: 1.0 |
setObject | public DbPreparedStatement setObject(String parameterName, Object x) throws DatabaseException(Code) | | Sets the value of the named parameters using the given object. The
second parameter must be of type Object ; therefore,
the java.lang equivalent objects should be used for
built-in types.
The JDBC specification specifies a standard mapping from Java
Object types to SQL types. The given argument will be
converted to the corresponding SQL type before being sent to the
database.
Note that this method may be used to pass datatabase-specific
abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interface
SQLData , the JDBC driver should call the method
SQLData.writeSQL to write it to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for
example, if the object is of a class implementing more than one of
the interfaces named above.
If such an ambiquity exception is thrown or if a database access
error occurs, this DbPreparedStatement instance is
automatically closed.
Parameters: parameterName - the name of the parameter that will be set Parameters: x - the object containing the input parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs, or if the type of the given object isambiguous. See Also: DbPreparedStatement.setObjects(int[],Object) See Also: DbPreparedStatement.setObject(int,Object) since: 1.0 |
setObject | public DbPreparedStatement setObject(int parameterIndex, Object x) throws DatabaseException(Code) | | Sets the value of the designated parameter using the given object.
The second parameter must be of type Object ;
therefore, the java.lang equivalent objects should be
used for built-in types.
The JDBC specification specifies a standard mapping from Java
Object types to SQL types. The given argument will be
converted to the corresponding SQL type before being sent to the
database.
Note that this method may be used to pass datatabase-specific
abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interface
SQLData , the JDBC driver should call the method
SQLData.writeSQL to write it to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for
example, if the object is of a class implementing more than one of
the interfaces named above.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs orthe type of the given object is ambiguous See Also: DbPreparedStatement.setObject(String,Object) See Also: DbPreparedStatement.setObjects(int[],Object) since: 1.0 |
setObjects | public DbPreparedStatement setObjects(int[] parameterIndices, Object x, int targetSqlType, int scale) throws DatabaseException(Code) | | Sets the value of the designated parameters with the given object.
The second argument must be an object type; for integral values,
the java.lang equivalent objects should be used.
The given Java object will be converted to the given
targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing
the interface SQLData ), the JDBC driver should call
the method SQLData.writeSQL to write it to the SQL
data stream. If, on the other hand, the object is of a class
implementing Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Note that this method may be used to pass database-specific
abstract data types.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database. The scale argument may further qualifythis type. Parameters: scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERICtypes, this is the number of digits after the decimal point. Forall other types, this value will be ignored. this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setObject(String,Object,int,int) See Also: DbPreparedStatement.setObject(int,Object,int,int) since: 1.0 |
setObjects | public DbPreparedStatement setObjects(int[] parameterIndices, Object x, int targetSqlType) throws DatabaseException(Code) | | Sets the value of the designated parameters with the given object.
This method is like the method setObject above, except
that it assumes a scale of zero.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value Parameters: targetSqlType - the SQL type (as defined in java.sql.Types) tobe sent to the database this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: java.sql.Types See Also: DbPreparedStatement.setObject(String,Object,int) See Also: DbPreparedStatement.setObject(int,Object,int) since: 1.0 |
setObjects | public DbPreparedStatement setObjects(int[] parameterIndices, Object x) throws DatabaseException(Code) | | Sets the value of the designated parameters using the given object.
The second parameter must be of type Object ;
therefore, the java.lang equivalent objects should be
used for built-in types.
The JDBC specification specifies a standard mapping from Java
Object types to SQL types. The given argument will be
converted to the corresponding SQL type before being sent to the
database.
Note that this method may be used to pass datatabase-specific
abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interface
SQLData , the JDBC driver should call the method
SQLData.writeSQL to write it to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref , Blob , Clob ,
Struct , or Array , the driver should pass
it to the database as a value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for
example, if the object is of a class implementing more than one of
the interfaces named above.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the object containing the input parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs orthe type of the given object is ambiguous See Also: DbPreparedStatement.setObject(String,Object) See Also: DbPreparedStatement.setObject(int,Object) since: 1.0 |
setRef | public DbPreparedStatement setRef(String parameterName, Ref x) throws DatabaseException(Code) | | Sets the named parameter to the given
REF(<structured-type>) value. The driver
converts this to a SQL REF value when it sends it to
the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameter that will be set(the first parameter with the name will be used) Parameters: x - an SQL REF value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setRef(int,Ref) since: 1.0 |
setRef | public DbPreparedStatement setRef(int parameterIndex, Ref x) throws DatabaseException(Code) | | Sets the designated parameter to the given
REF(<structured-type>) value. The driver
converts this to a SQL REF value when it sends it to
the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - an SQL REF value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setRef(String,Ref) since: 1.0 |
setShort | public DbPreparedStatement setShort(String parameterName, short x) throws DatabaseException(Code) | | Sets the named parameters to the given Java short
value. The driver converts this to a SQL SMALLINT
value when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setShorts(int[],short) See Also: DbPreparedStatement.setShort(int,short) since: 1.0 |
setShort | public DbPreparedStatement setShort(int parameterIndex, short x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java short
value. The driver converts this to a SQL SMALLINT
value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setShort(String,short) See Also: DbPreparedStatement.setShorts(int[],short) since: 1.0 |
setShorts | public DbPreparedStatement setShorts(int[] parameterIndices, short x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java short
value. The driver converts this to a SQL SMALLINT
value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setShort(String,short) See Also: DbPreparedStatement.setShort(int,short) since: 1.0 |
setString | public DbPreparedStatement setString(String parameterName, String x) throws DatabaseException(Code) | | Sets the named parameters to the given Java String
value. The driver converts this to a SQL VARCHAR or
LONGVARCHAR value (depending on the argument's size
relative to the driver's limits on VARCHAR values)
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setString(int,String) See Also: DbPreparedStatement.setStrings(int[],String) since: 1.0 |
setString | public DbPreparedStatement setString(int parameterIndex, String x) throws DatabaseException(Code) | | Sets the designated parameter to the given Java String
value. The driver converts this to a SQL VARCHAR or
LONGVARCHAR value (depending on the argument's size
relative to the driver's limits on VARCHAR values)
when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setString(String,String) See Also: DbPreparedStatement.setStrings(int[],String) since: 1.0 |
setStrings | public DbPreparedStatement setStrings(int[] parameterIndices, String x) throws DatabaseException(Code) | | Sets the designated parameters to the given Java
String value. The driver converts this to a SQL
VARCHAR or LONGVARCHAR value (depending
on the argument's size relative to the driver's limits on
VARCHAR values) when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setString(String,String) See Also: DbPreparedStatement.setString(int,String) since: 1.0 |
setTime | public DbPreparedStatement setTime(String parameterName, Time x) throws DatabaseException(Code) | | Sets the named parameters to the given java.sql.Time
value. The driver converts this to a SQL TIME value
when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setTimes(int[],Time) See Also: DbPreparedStatement.setTime(int,Time) since: 1.0 |
setTime | public DbPreparedStatement setTime(int parameterIndex, Time x) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.sql.Time value. The driver converts this to a SQL
TIME value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTime(String,Time) See Also: DbPreparedStatement.setTimes(int[],Time) since: 1.0 |
setTime | public DbPreparedStatement setTime(String parameterName, Time x, Calendar cal) throws DatabaseException(Code) | | Sets the named parameters to the given java.sql.Time
value, using the given Calendar object. The driver
uses the Calendar object to construct an SQL
TIME value, which the driver then sends to the
database. With a Calendar object, the driver can
calculate the time taking into account a custom timezone. If no
Calendar object is specified, the driver uses the
default timezone, which is that of the virtual machine running the
application.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the time this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setTimes(int[],Time,Calendar) See Also: DbPreparedStatement.setTime(int,Time,Calendar) since: 1.0 |
setTime | public DbPreparedStatement setTime(int parameterIndex, Time x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL TIME
value, which the driver then sends to the database. With a
Calendar object, the driver can calculate the time
taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is
that of the virtual machine running the application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the time this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTime(String,Time,Calendar) See Also: DbPreparedStatement.setTimes(int[],Time,Calendar) since: 1.0 |
setTimes | public DbPreparedStatement setTimes(int[] parameterIndices, Time x) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.sql.Time value. The driver converts this to a SQL
TIME value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTime(String,Time) See Also: DbPreparedStatement.setTime(int,Time) since: 1.0 |
setTimes | public DbPreparedStatement setTimes(int[] parameterIndices, Time x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.sql.Time value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL TIME
value, which the driver then sends to the database. With a
Calendar object, the driver can calculate the time
taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is
that of the virtual machine running the application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the time this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTime(String,Time,Calendar) See Also: DbPreparedStatement.setTime(int,Time,Calendar) since: 1.0 |
setTimestamp | public DbPreparedStatement setTimestamp(String parameterName, Timestamp x) throws DatabaseException(Code) | | Sets the named parameters to the given
java.sql.Timestamp value. The driver converts this to
a SQL TIMESTAMP value when it sends it to the
database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setTimestamps(int[],Timestamp) See Also: DbPreparedStatement.setTimestamp(int,Timestamp) since: 1.0 |
setTimestamp | public DbPreparedStatement setTimestamp(String parameterName, Timestamp x, Calendar cal) throws DatabaseException(Code) | | Sets the named parameters to the given
java.sql.Timestamp value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL
TIMESTAMP value, which the driver then sends to the
database. With a Calendar object, the driver can
calculate the timestamp taking into account a custom timezone. If
no Calendar object is specified, the driver uses the
default timezone, which is that of the virtual machine running the
application.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the timestamp this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setTimestamps(int[],Timestamp,Calendar) See Also: DbPreparedStatement.setTimestamp(int,Timestamp,Calendar) since: 1.0 |
setTimestamp | public DbPreparedStatement setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL
TIMESTAMP value, which the driver then sends to the
database. With a Calendar object, the driver can
calculate the timestamp taking into account a custom timezone. If
no Calendar object is specified, the driver uses the
default timezone, which is that of the virtual machine running the
application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the timestamp this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTimestamp(String,Timestamp,Calendar) See Also: DbPreparedStatement.setTimestamps(int[],Timestamp,Calendar) since: 1.0 |
setTimestamps | public DbPreparedStatement setTimestamps(int[] parameterIndices, Timestamp x, Calendar cal) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.sql.Timestamp value, using the given
Calendar object. The driver uses the
Calendar object to construct an SQL
TIMESTAMP value, which the driver then sends to the
database. With a Calendar object, the driver can
calculate the timestamp taking into account a custom timezone. If
no Calendar object is specified, the driver uses the
default timezone, which is that of the virtual machine running the
application.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will use toconstruct the timestamp this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setTimestamp(String,Timestamp,Calendar) See Also: DbPreparedStatement.setTimestamp(int,Timestamp,Calendar) since: 1.0 |
setURL | public DbPreparedStatement setURL(String parameterName, URL x) throws DatabaseException(Code) | | Sets the named parameters to the given java.net.URL
value. The driver converts this to a SQL DATALINK
value when it sends it to the database.
If a database access error occurs, this
DbPreparedStatement instance is automatically closed.
Parameters: parameterName - the name of the parameters that have to be set Parameters: x - the java.net.URL object to be set this DbPreparedStatement instance. exception: DatabaseException - when thisDbPrepareStatement instance wasn't defined by aParametrizedQuery but by a regular sql string, or ifthe ParametrizedQuery doesn't contain any parameters,or if no parameters with this name could be found, or if a databaseaccess error occurs. See Also: DbPreparedStatement.setURLs(int[],URL) See Also: DbPreparedStatement.setURL(int,URL) since: 1.0 |
setURL | public DbPreparedStatement setURL(int parameterIndex, URL x) throws DatabaseException(Code) | | Sets the designated parameter to the given
java.net.URL value. The driver converts this to a SQL
DATALINK value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the java.net.URL object to be set this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setURL(String,URL) See Also: DbPreparedStatement.setURLs(int[],URL) since: 1.0 |
setURLs | public DbPreparedStatement setURLs(int[] parameterIndices, URL x) throws DatabaseException(Code) | | Sets the designated parameters to the given
java.net.URL value. The driver converts this to a SQL
DATALINK value when it sends it to the database.
If an exception is thrown, this DbPreparedStatement
is automatically closed and an ongoing transaction will be
automatically rolled back if it belongs to the executing thread.
Parameters: parameterIndices - the first parameter is 1, the second is 2,... Parameters: x - the java.net.URL object to be set this DbPreparedStatement instance. exception: DatabaseException - if a database access error occurs See Also: DbPreparedStatement.setURL(String,URL) See Also: DbPreparedStatement.setURL(int,URL) since: 1.0 |
setVirtualParameters | public void setVirtualParameters(VirtualParameters parameters)(Code) | | Sets the parameters that should be handled as virtual parameters.
These parameters are not sent to the backend, but their values will
be stored in this DbPreparedStatement instance for
retrieval by other functionalities like capabilities.
Parameters: parameters - the VirtualParameters instance thatwill determine the virtual parameters since: 1.0 |
|
|