Sets the designated parameter to the given java.sql.Date
object.
When the DBMS does not store time zone information, the driver will use
the given Calendar object to construct the SQL DATE
value to send to the database. With a
Calendar object, the driver can calculate the date
taking into account a custom time zone. If no Calendar
object is specified, the driver uses the time zone of the Virtual Machine
that is running the application.
The parameter value set by this method is stored internally and
will be supplied as the appropriate parameter in this RowSet
object's command when the method execute is called.
Methods such as execute and populate must be
provided in any class that extends this class and implements one or
more of the standard JSR-114 RowSet interfaces.
NOTE: JdbcRowSet does not require the populate method
as it is undefined in this class.
Calls made to the method getParams after this version of
setDate
has been called will return an array containing the parameter values that
have been set. In that array, the element that represents the values
set with this method will itself be an array. The first element of that array
is the given java.sql.Date object.
The second element is the value set for cal.
The parameter number is indicated by an element's position in the array
returned by the method getParams,
with the first element being the value for the first placeholder parameter, the
second element being the value for the second placeholder parameter, and so on.
In other words, if the date being set is the value for the second
placeholder parameter, the array containing it will be the second element in
the array returned by getParams.
Note that because the numbering of elements in an array starts at zero, the array element that corresponds to placeholder parameter number parameterIndex is parameterIndex -1.
parameterIndex | the ordinal number of the placeholder parameter
in this RowSet object's command that is to be set.
The first parameter is 1, the second is 2, and so on; must be
1 or greater | |
x | a java.sql.Date object representing an SQL
DATE value | |
cal | a java.util.Calendar object to use when
when constructing the date |
SQLException | if an error occurs or the parameter index is out of bounds |
getParams
Diagram: RowSet Support