Uses of Interface java.sql.ResultSet (Java Platform SE 6) - JDK 5 Documentation v6.0, Java 2 SDK 英文文档

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

Java™ Platform
Standard Ed. 6

PREV NEXT

FRAMES NO FRAMES

Uses of Interface
java.sql.ResultSet

Packages that use ResultSet
java.sql	Provides the API for accessing and processing data stored in a data source (usually a relational database) using the Java^TM programming language.
javax.sql	Provides the API for server side data source access and processing from the Java^TM 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.

Uses of ResultSet in java.sql

Methods in java.sql that return ResultSet

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 Statement.getResultSet()
          Retrieves the current result as a ResultSet object.

ResultSet Array.getResultSet()
          Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array 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.

Methods in java.sql that return ResultSet
`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`	`Statement.getResultSet()` Retrieves the current result as a `ResultSet` object.
`ResultSet`	`Array.getResultSet()` Retrieves a result set that contains the elements of the SQL `ARRAY` value designated by this `Array` 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.

Uses of ResultSet in javax.sql

Subinterfaces of ResultSet in javax.sql

interface RowSet
The interface that adds support to the JDBC API for the JavaBeans^TM component model.

Subinterfaces of ResultSet in javax.sql
`interface`	`RowSet` The interface that adds support to the JDBC API for the JavaBeans^TM component model.

Methods in javax.sql that return ResultSet

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.

Methods in javax.sql that return ResultSet
`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.

Uses of ResultSet in javax.sql.rowset

Subinterfaces of ResultSet in javax.sql.rowset

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.

Subinterfaces of ResultSet in javax.sql.rowset
`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.

Methods in javax.sql.rowset that return ResultSet

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.

Methods in javax.sql.rowset that return ResultSet
`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.

Methods in javax.sql.rowset with parameters of type ResultSet

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.

Methods in javax.sql.rowset with parameters of type ResultSet
`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.

Uses of ResultSet in javax.sql.rowset.serial

Methods in javax.sql.rowset.serial that return ResultSet

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.

Methods in javax.sql.rowset.serial that return ResultSet
`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.

Uses of ResultSet in javax.sql.rowset.spi

Subinterfaces of ResultSet in javax.sql.rowset.spi

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.

Subinterfaces of ResultSet in javax.sql.rowset.spi
`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.