|
|||||||||||
PREV NEXT | FRAMES NO FRAMES |
ResultSet
object.
PreparedStatement
object's batch of commands.
Statement
object.
ResultSet
object, just after the last row.
getProcedures
.
getTables
in a SELECT
statement.
ResultSet
object, just before the
first row.
Statement
object if both the DBMS and
driver support aborting an SQL statement.
ResultSet
object.
Statement
object's current list of
SQL commands.
Connection
object.
ResultSet
object.
Statement
object.
Connection
object's database and JDBC resources immediately instead of
waiting for them to be automatically released.
ResultSet
object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
Statement
object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
Statement
object for sending SQL statements to the database.
Statement
object that will generate
ResultSet
objects with the given type and
concurrency.
Statement
object that will generate ResultSet
objects with
the given type, concurrency, and holdability.
ResultSet
object
and from the underlying database.
ResultSet.rowDeleted
.
getMaxRowSize
includes the SQL data types
LONGVARCHAR
and LONGVARBINARY
.
PreparedStatement
object, which may be any kind of SQL statement.
PreparedStatement
object
and returns the ResultSet
object generated by the query.
ResultSet
object.
PreparedStatement
object, which must be an SQL INSERT
,
UPDATE
or DELETE
statement; or an SQL
statement that returns nothing, such as a DDL statement.
INSERT
,
UPDATE
, or DELETE
statement or an
SQL statement that returns nothing, such as an SQL DDL statement.
Statement
object
should be made available for retrieval.
ResultSet
column name to its
ResultSet
column index.
ResultSet
object.
ARRAY
parameter as an Array
object in the Java programming
language.
ARRAY
parameter as an
Array
object in the Java programming language.
ResultSet
object as an Array
object
in the Java programming language.
ResultSet
object as an Array
object
in the Java programming language.
CLOB
value designated by this
Clob
object as an ascii stream.
ResultSet
object as
a stream of ASCII characters.
ResultSet
object as a stream of
ASCII characters.
getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName)
NUMERIC
parameter as a java.math.BigDecimal
object with as many
digits to the right of the decimal point as the value contains.
NUMERIC
parameter as a
java.math.BigDecimal
object with as many digits to the
right of the decimal point as the value contains.
ResultSet
object as a
java.math.BigDecimal
with full precision.
ResultSet
object as a
java.math.BigDecimal
with full precision.
BLOB
value designated by this
Blob
instance as a stream.
ResultSet
object as a binary stream of
uninterpreted bytes.
ResultSet
object as a stream of uninterpreted
byte
s.
BLOB
parameter as a Blob
object in the Java
programming language.
BLOB
parameter as a
Blob
object in the Java programming language.
ResultSet
object as a Blob
object
in the Java programming language.
ResultSet
object as a Blob
object
in the Java programming language.
BIT
parameter
as a boolean
in the Java programming language.
BIT
or BOOLEAN
parameter as a
boolean
in the Java programming language.
ResultSet
object as
a boolean
in the Java programming language.
ResultSet
object as
a boolean
in the Java programming language.
TINYINT
parameter as a byte
in the Java programming language.
TINYINT
parameter as a
byte
in the Java programming language.
ResultSet
object as
a byte
in the Java programming language.
ResultSet
object as
a byte
in the Java programming language.
BLOB
value that this
Blob
object represents, as an array of bytes.
BINARY
or
VARBINARY
parameter as an array of byte
values in the Java programming language.
BINARY
or
VARBINARY
parameter as an array of byte
values in the Java programming language.
ResultSet
object as
a byte
array in the Java programming language.
ResultSet
object as
a byte
array in the Java programming language.
String
that this database uses as the
separator between a catalog and table name.
CLOB
value designated by this
Clob
object as a java.io.Reader
object
(or as a stream of characters).
ResultSet
object as a
java.io.Reader
object.
ResultSet
object as a
java.io.Reader
object.
CLOB
parameter as a Clob
object in the Java programming
language.
CLOB
parameter as a
Clob
object in the Java programming language.
ResultSet
object as a Clob
object
in the Java programming language.
ResultSet
object as a Clob
object
in the Java programming language.
ResultSet.getObject
is called to retrieve a value from the column.
ResultSet
object.
ResultSet
object.
DataSource
object represents.
DataSource
object represents.
Connection
object
that produced this Statement
object.
ResultSet
object.
DATE
parameter
as a java.sql.Date
object.
DATE
parameter as a java.sql.Date
object, using
the given Calendar
object
to construct the date.
DATE
parameter as a
java.sql.Date
object.
DATE
parameter as a
java.sql.Date
object, using
the given Calendar
object
to construct the date.
ResultSet
object as a
java.sql.Date
object in the Java programming language.
ResultSet
object as a
java.sql.Date
object in the Java programming language.
ResultSet
object as a
java.sql.Date
object
in the Java programming language.
ResultSet
object as a java.sql.Date
object in the Java programming language.
DOUBLE
parameter as a double
in the Java programming language.
DOUBLE
parameter as
a double
in the Java programming language.
ResultSet
object as
a double
in the Java programming language.
ResultSet
object as
a double
in the Java programming language.
String
.
ResultSet
object.
Statement
object.
ResultSet
object.
ResultSet
objects
generated from this Statement
object.
FLOAT
parameter as a float
in the Java programming language.
FLOAT
parameter as
a float
in the Java programming language.
ResultSet
object as
a float
in the Java programming language.
ResultSet
object as
a float
in the Java programming language.
Statement
object.
ResultSet
objects created using
this Connection
object.
INTEGER
parameter as an int
in the Java programming language.
INTEGER
parameter as
an int
in the Java programming language.
ResultSet
object as
an int
in the Java programming language.
ResultSet
object as
an int
in the Java programming language.
DataSource
object.
BIGINT
parameter as a long
in the Java programming language.
BIGINT
parameter as
a long
in the Java programming language.
ResultSet
object as
a long
in the Java programming language.
ResultSet
object as
a long
in the Java programming language.
GROUP BY
clause.
ORDER BY
clause.
SELECT
list.
ResultSet
object produced by this Statement
object.
ResultSet
object produced by this
Statement
object can contain.
SELECT
statement.
ResultSetMetaData
object that contains
information about the columns of the ResultSet
object
that will be returned when this PreparedStatement
object
is executed.
ResultSet
object's columns.
Statement
object's next result, returns
true
if it is a ResultSet
object, and
implicitly closes any current ResultSet
object(s) obtained with the method getResultSet
.
Statement
object's next result, deals with
any current ResultSet
object(s) according to the instructions
specified by the given flag, and returns
true
if the next result is a ResultSet
object.
Object
in the Java programming language.
parameterIndex
and uses map
for the custom
mapping of the parameter value.
Object
in the Java
programming language.
parameterName
and uses map
for the custom
mapping of the parameter value.
ResultSet
object as
an Object
in the Java programming language.
ResultSet
object as
an Object
in the Java programming language.
ResultSet
object as an Object
in the Java programming language.
ResultSet
object as an Object
in the Java programming language.
PreparedStatement
object's parameters.
Statement
object to execute.
REF(<structured-type>)
parameter as a
Ref
object in the Java programming language.
REF(<structured-type>)
parameter as a Ref
object in the Java programming language.
ResultSet
object as a Ref
object
in the Java programming language.
ResultSet
object as a Ref
object
in the Java programming language.
ResultSet
object.
ResultSet
objects
generated by this Statement
object.
ResultSet
object.
ResultSet
objects
generated by this Statement
object.
ResultSet
objects
generated by this Statement
object.
SQLException.getSQLState
is X/Open (now known as Open Group)
SQL CLI or SQL99.
Savepoint
object represents.
Savepoint
object represents.
SMALLINT
parameter as a short
in the Java programming language.
SMALLINT
parameter as
a short
in the Java programming language.
ResultSet
object as
a short
in the Java programming language.
ResultSet
object as
a short
in the Java programming language.
Statement
object that produced this
ResultSet
object.
CHAR
,
VARCHAR
, or LONGVARCHAR
parameter as a
String
in the Java programming language.
CHAR
, VARCHAR
,
or LONGVARCHAR
parameter as a String
in
the Java programming language.
ResultSet
object as
a String
in the Java programming language.
ResultSet
object as
a String
in the Java programming language.
CLOB
value designated by this Clob
object.
TIME
parameter
as a java.sql.Time
object.
TIME
parameter as a java.sql.Time
object, using
the given Calendar
object
to construct the time.
TIME
parameter as a
java.sql.Time
object.
TIME
parameter as a
java.sql.Time
object, using
the given Calendar
object
to construct the time.
ResultSet
object as a java.sql.Time
object in the Java programming language.
ResultSet
object as a java.sql.Time
object in the Java programming language.
ResultSet
object as a java.sql.Time
object in the Java programming language.
ResultSet
object as
a java.sql.Time
object
in the Java programming language.
TIMESTAMP
parameter as a java.sql.Timestamp
object.
TIMESTAMP
parameter as a java.sql.Timestamp
object, using
the given Calendar
object to construct
the Timestamp
object.
TIMESTAMP
parameter as a
java.sql.Timestamp
object.
TIMESTAMP
parameter as a
java.sql.Timestamp
object, using
the given Calendar
object to construct
the Timestamp
object.
ResultSet
object as
a java.sql.Timestamp
object in the Java programming
language.
ResultSet
object as
a java.sql.Timestamp
object.
ResultSet
object as a
java.sql.Timestamp
object in the Java programming
anguage.
ResultSet
object as a
java.sql.Timestamp
object in the Java programming
language.
Connection
object's current transaction isolation level.
ResultSet
object.
DATALINK
parameter as a java.net.URL
object.
DATALINK
parameter as a
java.net.URL
object.
ResultSet
object as a java.net.URL
object in the Java programming language.
ResultSet
object as a java.net.URL
object in the Java programming language.
getCharacterStream
in place of
getUnicodeStream
getCharacterStream
instead
ResultSet
object or there are no more results, -1
is returned.
Connection
object.
ResultSet
object.
Statement
object.
ResultSet
object and into the database.
ResultSet.rowInserted
.
ResultSet
object.
ResultSet
object.
ResultSet
object.
ResultSet
object.
Connection
to an HSQLDB
Database
.
INTERNAL
Connection
,
using the specified Session
.
DataSource
object represents.jdbcDatasource
object instances.ResultSet
object.Connection.rollback
method.ResultSet
object.
BLOB
value
designated by this Blob
object.
CLOB
value
designated by this Clob
object.
NULL
and non-NULL
values being
NULL
.
NULL
values are sorted at the end regardless of
sort order.
NULL
values are sorted at the start regardless
of sort order.
NULL
values are sorted high.
NULL
values are sorted low.
ResultSet
object,
the result set's own updates are visible.
pattern
begins within the BLOB
value that this Blob
object represents.
BLOB
value
designated by this Blob
object at which
pattern
begins.
searchstr
appears in the SQL CLOB
value
represented by this Clob
object.
Clob
object searchstr
appears in this
Clob
object.
CallableStatement
object for calling database stored procedures.
CallableStatement
object that will generate ResultSet
objects with
the given type and concurrency.
CallableStatement
object that will generate ResultSet
objects with
the given type and concurrency.
PreparedStatement
object for sending parameterized SQL statements to the
database.
PreparedStatement
object that will
generate ResultSet
objects with the given type
and concurrency.
PreparedStatement
object that will generate ResultSet
objects with
the given type, concurrency, and holdability.
PreparedStatement
object that has the capability to retrieve auto-generated
keys.
PreparedStatement
object capable of returning the auto-generated keys designated
by the given array.
PreparedStatement
object capable of returning the auto-generated keys designated
by the given array.
ResultSet
object.
RCData
object.
parameterIndex
to the JDBC type
sqlType
.
parameterIndex
to be of JDBC type
sqlType
.
parameterName
to the JDBC type
sqlType
.
parameterName
to be of JDBC type
sqlType
.
Savepoint
object from the current transaction.
Savepoint
object was set.
Array
object.
CLOB
value that this Clob
object represents,
starting at position pos
.
java.math.BigDecimal
value.
java.math.BigDecimal
value.
BLOB
value that this Blob
object represents.
Blob
object.
boolean
value.
boolean
value.
byte
value.
byte
value.
BLOB
value that
this Blob
object represents, starting at position
pos
, and returns the number of bytes written.
byte
array to the
BLOB
value that this Blob
object represents
and returns the number of bytes written.
Reader
object, which is the given number of characters long.
CLOB
value that this Clob
object
represents, at position pos
.
Reader
object, which is the given number of characters long.
Clob
object.
String
, which
will be used by subsequent Statement
object
execute
methods.
java.sql.Date
value
using the default time zone of the virtual machine that is running
the application.
java.sql.Date
value, using the given Calendar
object.
java.sql.Date
value.
java.sql.Date
value, using the given Calendar
object.
double
value.
double
value.
ResultSet
object will be processed.
ResultSet
objects created using this Statement
object.
ResultSet
object.
float
value.
float
value.
ResultSet
objects created using this
Connection
object to the given holdability.
int
value.
int
value.
DataSource
object to the given java.io.PrintWriter
object.
long
value.
long
value.
ResultSet
column storing character or binary values to
the given number of bytes.
ResultSet
object can contain to the given number.
NULL
.
NULL
.
NULL
.
NULL
.
Statement
object to execute to the given number of seconds.
REF(<structured-type>)
value.
Savepoint
object that represents it.
Savepoint
object that represents it.
short
value.
short
value.
String
value.
String
to the CLOB
value that this Clob
object designates at the position
pos
.
len
characters of str
, starting
at character offset
, to the CLOB
value
that this Clob
represents.
String
value.
java.sql.Time
value.
java.sql.Time
value, using the given Calendar
object.
java.sql.Time
value.
java.sql.Time
value, using the given Calendar
object.
java.sql.Timestamp
value.
java.sql.Timestamp
value, using the given
Calendar
object.
java.sql.Timestamp
value.
java.sql.Timestamp
value, using the given Calendar
object.
Connection
object to the one given.
TypeMap
object as the type map for this Connection
object.
java.net.URL
object.
java.net.URL
value.
ALTER TABLE
with add column.
ALTER TABLE
with drop column.
CONVERT
function between SQL types.
CONVERT
for two given SQL types.
ORDER BY
lists.
GROUP BY
clause.
SELECT
statement in a GROUP BY
clause
provided that all of the columns in the SELECT
statement
are included in the GROUP BY
clause.
SELECT
statement in a
GROUP BY
clause.
LIKE
escape clause.
ResultSet
objects returned from a CallableStatement
object
simultaneously.
ResultSet
objects from a single call to the
method execute
.
SELECT
statement in an
ORDER BY
clause.
DELETE
statements.
UPDATE
statements.
SELECT FOR UPDATE
statements.
EXISTS
expressions.
IN
expressions.
UNION
.
UNION ALL
.
BLOB
value that this Blob
object represents to be len
bytes in length.
CLOB
value that this Clob
designates to have a length of len
characters.
java.sql.Array
value.
java.sql.Array
value.
java.math.BigDecimal
value.
java.sql.BigDecimal
value.
java.sql.Blob
value.
java.sql.Blob
value.
boolean
value.
boolean
value.
byte
value.
byte
value.
byte
array value.
java.sql.Clob
value.
java.sql.Clob
value.
java.sql.Date
value.
java.sql.Date
value.
double
value.
double
value.
float
value.
float
value.
int
value.
int
value.
long
value.
long
value.
null
value.
Object
value.
Object
value.
Object
value.
Object
value.
java.sql.Ref
value.
java.sql.Ref
value.
ResultSet
object.
short
value.
short
value.
String
value.
String
value.
java.sql.Time
value.
java.sql.Time
value.
java.sql.Timestamp
value.
java.sql.Timestamp
value.
ResultSet.rowUpdated
.
NULL
.
NULL
.
|
|||||||||||
PREV NEXT | FRAMES NO FRAMES |