| Package | Description |
|---|---|
| java.sql |
Provides the API for accessing and processing data stored in a
data source (usually a relational database) using the
JavaTM programming language.
|
| javax.sql |
Provides the API for server side data source access and processing from
the JavaTM programming language.
|
| javax.sql.rowset |
Standard interfaces and base classes for JDBC
RowSet
implementations. |
| javax.sql.rowset.serial |
Provides utility classes to allow serializable mappings between SQL types
and data types in the Java programming language.
|
| javax.sql.rowset.spi |
The standard classes and interfaces that a third party vendor has to
use in its implementation of a synchronization provider.
|
| Modifier and Type | Method and Description |
|---|---|
ResultSet |
PreparedStatement.executeQuery()
Executes the SQL query in this
PreparedStatement object
and returns the ResultSet object generated by the query. |
ResultSet |
Statement.executeQuery(String sql)
Executes the given SQL statement, which returns a single
ResultSet object. |
ResultSet |
DatabaseMetaData.getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
Retrieves a description of the given attribute of the given type
for a user-defined type (UDT) that is available in the given schema
and catalog.
|
ResultSet |
DatabaseMetaData.getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Retrieves a description of a table's optimal set of columns that
uniquely identifies a row.
|
ResultSet |
DatabaseMetaData.getCatalogs()
Retrieves the catalog names available in this database.
|
ResultSet |
DatabaseMetaData.getClientInfoProperties()
Retrieves a list of the client info properties
that the driver supports.
|
ResultSet |
DatabaseMetaData.getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Retrieves a description of the access rights for a table's columns.
|
ResultSet |
DatabaseMetaData.getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Retrieves a description of table columns available in
the specified catalog.
|
ResultSet |
DatabaseMetaData.getCrossReference(String parentCatalog,
String parentSchema,
String parentTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Retrieves a description of the foreign key columns in the given foreign key
table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
|
ResultSet |
DatabaseMetaData.getExportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the foreign key columns that reference the
given table's primary key columns (the foreign keys exported by a
table).
|
ResultSet |
DatabaseMetaData.getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's system or user
function parameters and return type.
|
ResultSet |
DatabaseMetaData.getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
Retrieves a description of the system and user functions available
in the given catalog.
|
ResultSet |
Statement.getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing this
Statement object. |
ResultSet |
DatabaseMetaData.getImportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the primary key columns that are
referenced by the given table's foreign key columns (the primary keys
imported by a table).
|
ResultSet |
DatabaseMetaData.getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Retrieves a description of the given table's indices and statistics.
|
ResultSet |
DatabaseMetaData.getPrimaryKeys(String catalog,
String schema,
String table)
Retrieves a description of the given table's primary key columns.
|
ResultSet |
DatabaseMetaData.getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's stored procedure parameter
and result columns.
|
ResultSet |
DatabaseMetaData.getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
Retrieves a description of the stored procedures available in the given
catalog.
|
ResultSet |
DatabaseMetaData.getPseudoColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Retrieves a description of the pseudo or hidden columns available
in a given table within the specified catalog and schema.
|
ResultSet |
Array.getResultSet()
Retrieves a result set that contains the elements of the SQL
ARRAY value
designated by this Array object. |
ResultSet |
Statement.getResultSet()
Retrieves the current result as a
ResultSet object. |
ResultSet |
Array.getResultSet(long index,
int count)
Retrieves a result set holding the elements of the subarray that
starts at index
index and contains up to
count successive elements. |
ResultSet |
Array.getResultSet(long index,
int count,
Map<String,Class<?>> map)
Retrieves a result set holding the elements of the subarray that
starts at index
index and contains up to
count successive elements. |
ResultSet |
Array.getResultSet(Map<String,Class<?>> map)
Retrieves a result set that contains the elements of the SQL
ARRAY value designated by this Array object. |
ResultSet |
DatabaseMetaData.getSchemas()
Retrieves the schema names available in this database.
|
ResultSet |
DatabaseMetaData.getSchemas(String catalog,
String schemaPattern)
Retrieves the schema names available in this database.
|
ResultSet |
DatabaseMetaData.getSuperTables(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular
schema in this database.
|
ResultSet |
DatabaseMetaData.getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a
particular schema in this database.
|
ResultSet |
DatabaseMetaData.getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the access rights for each table available
in a catalog.
|
ResultSet |
DatabaseMetaData.getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
Retrieves a description of the tables available in the given catalog.
|
ResultSet |
DatabaseMetaData.getTableTypes()
Retrieves the table types available in this database.
|
ResultSet |
DatabaseMetaData.getTypeInfo()
Retrieves a description of all the data types supported by
this database.
|
ResultSet |
DatabaseMetaData.getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Retrieves a description of the user-defined types (UDTs) defined
in a particular schema.
|
ResultSet |
DatabaseMetaData.getVersionColumns(String catalog,
String schema,
String table)
Retrieves a description of a table's columns that are automatically
updated when any value in a row is updated.
|
| Modifier and Type | Interface and Description |
|---|---|
interface |
RowSet
The interface that adds support to the JDBC API for the
JavaBeans™ component model.
|
| Modifier and Type | Method and Description |
|---|---|
ResultSet |
RowSetInternal.getOriginal()
Retrieves a
ResultSet object containing the original
value of this RowSet object. |
ResultSet |
RowSetInternal.getOriginalRow()
Retrieves a
ResultSet object containing the original value
of the current row only. |
| Modifier and Type | Interface and Description |
|---|---|
interface |
CachedRowSet
The interface that all standard implementations of
CachedRowSet must implement. |
interface |
FilteredRowSet
The standard interface that all standard implementations of
FilteredRowSet must implement. |
interface |
JdbcRowSet
The standard interface that all standard implementations of
JdbcRowSet must implement. |
interface |
JoinRowSet
The
JoinRowSet interface provides a mechanism for combining related
data from different RowSet objects into one JoinRowSet
object, which represents an SQL JOIN. |
interface |
WebRowSet
The standard interface that all implementations of a
WebRowSet
must implement. |
| Modifier and Type | Method and Description |
|---|---|
ResultSet |
CachedRowSet.getOriginal()
Returns a
ResultSet object containing the original value of this
CachedRowSet object. |
ResultSet |
CachedRowSet.getOriginalRow()
Returns a
ResultSet object containing the original value for the
current row only of this CachedRowSet object. |
| Modifier and Type | Method and Description |
|---|---|
void |
CachedRowSet.populate(ResultSet data)
Populates this
CachedRowSet object with data from
the given ResultSet object. |
void |
CachedRowSet.populate(ResultSet rs,
int startRow)
Populates this
CachedRowSet object with data from
the given ResultSet object. |
void |
WebRowSet.writeXml(ResultSet rs,
OutputStream oStream)
Populates this
WebRowSet object with
the contents of the given ResultSet object and writes its
data, properties, and metadata
to the given OutputStream object in XML format. |
void |
WebRowSet.writeXml(ResultSet rs,
Writer writer)
Populates this
WebRowSet object with
the contents of the given ResultSet object and writes its
data, properties, and metadata
to the given Writer object in XML format. |
| Modifier and Type | Method and Description |
|---|---|
ResultSet |
SerialArray.getResultSet()
Retrieves a
ResultSet object that contains all of
the elements in the ARRAY value that this
SerialArray object represents. |
ResultSet |
SerialArray.getResultSet(long index,
int count)
Retrieves a
ResultSet object holding the elements of
the subarray that starts at
index index and contains up to count successive elements. |
ResultSet |
SerialArray.getResultSet(long index,
int count,
Map<String,Class<?>> map)
Retrieves a result set holding the elements of the subarray that starts at
Retrieves a
ResultSet object that contains a subarray of the
elements in this SerialArray object, starting at
index index and containing up to count successive
elements. |
ResultSet |
SerialArray.getResultSet(Map<String,Class<?>> map)
Retrieves a
ResultSet object that contains all of
the elements of the SQL ARRAY
value represented by this SerialArray object. |
| Modifier and Type | Interface and Description |
|---|---|
interface |
SyncResolver
Defines a framework that allows applications to use a manual decision tree
to decide what should be done when a synchronization conflict occurs.
|
Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2022, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.