Uses of Interface
java.sql.ResultSet
| Package | Description |
|---|---|
| java.sql |
Provides the API for accessing and processing data stored in a
data source (usually a relational database) using the
Java™ programming language.
|
| javax.sql |
Provides the API for server side data source access and processing from
the Java™ 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 Modifier and Type Method Description ResultSetPreparedStatement. executeQuery()Executes the SQL query in thisPreparedStatementobject and returns theResultSetobject generated by the query.ResultSetStatement. executeQuery(String sql)Executes the given SQL statement, which returns a singleResultSetobject.ResultSetDatabaseMetaData. 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.ResultSetDatabaseMetaData. 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.ResultSetDatabaseMetaData. getCatalogs()Retrieves the catalog names available in this database.ResultSetDatabaseMetaData. getClientInfoProperties()Retrieves a list of the client info properties that the driver supports.ResultSetDatabaseMetaData. getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)Retrieves a description of the access rights for a table's columns.ResultSetDatabaseMetaData. getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)Retrieves a description of table columns available in the specified catalog.ResultSetDatabaseMetaData. 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).ResultSetDatabaseMetaData. 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).ResultSetDatabaseMetaData. 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.ResultSetDatabaseMetaData. getFunctions(String catalog, String schemaPattern, String functionNamePattern)Retrieves a description of the system and user functions available in the given catalog.ResultSetStatement. getGeneratedKeys()Retrieves any auto-generated keys created as a result of executing thisStatementobject.ResultSetDatabaseMetaData. 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).ResultSetDatabaseMetaData. getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)Retrieves a description of the given table's indices and statistics.ResultSetDatabaseMetaData. getPrimaryKeys(String catalog, String schema, String table)Retrieves a description of the given table's primary key columns.ResultSetDatabaseMetaData. getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)Retrieves a description of the given catalog's stored procedure parameter and result columns.ResultSetDatabaseMetaData. getProcedures(String catalog, String schemaPattern, String procedureNamePattern)Retrieves a description of the stored procedures available in the given catalog.ResultSetDatabaseMetaData. 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.ResultSetArray. getResultSet()Retrieves a result set that contains the elements of the SQLARRAYvalue designated by thisArrayobject.ResultSetArray. getResultSet(long index, int count)Retrieves a result set holding the elements of the subarray that starts at indexindexand contains up tocountsuccessive elements.ResultSetArray. getResultSet(long index, int count, Map<String,Class<?>> map)Retrieves a result set holding the elements of the subarray that starts at indexindexand contains up tocountsuccessive elements.ResultSetArray. getResultSet(Map<String,Class<?>> map)Retrieves a result set that contains the elements of the SQLARRAYvalue designated by thisArrayobject.ResultSetStatement. getResultSet()Retrieves the current result as aResultSetobject.ResultSetDatabaseMetaData. getSchemas()Retrieves the schema names available in this database.ResultSetDatabaseMetaData. getSchemas(String catalog, String schemaPattern)Retrieves the schema names available in this database.ResultSetDatabaseMetaData. getSuperTables(String catalog, String schemaPattern, String tableNamePattern)Retrieves a description of the table hierarchies defined in a particular schema in this database.ResultSetDatabaseMetaData. 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.ResultSetDatabaseMetaData. getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)Retrieves a description of the access rights for each table available in a catalog.ResultSetDatabaseMetaData. getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)Retrieves a description of the tables available in the given catalog.ResultSetDatabaseMetaData. getTableTypes()Retrieves the table types available in this database.ResultSetDatabaseMetaData. getTypeInfo()Retrieves a description of all the data types supported by this database.ResultSetDatabaseMetaData. getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)Retrieves a description of the user-defined types (UDTs) defined in a particular schema.ResultSetDatabaseMetaData. 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 Modifier and Type Interface Description interfaceRowSetThe interface that adds support to the JDBC API for the JavaBeans™ component model.Methods in javax.sql that return ResultSet Modifier and Type Method Description ResultSetRowSetInternal. getOriginal()Retrieves aResultSetobject containing the original value of thisRowSetobject.ResultSetRowSetInternal. getOriginalRow()Retrieves aResultSetobject containing the original value of the current row only. -
Uses of ResultSet in javax.sql.rowset
Subinterfaces of ResultSet in javax.sql.rowset Modifier and Type Interface Description interfaceCachedRowSetThe interface that all standard implementations ofCachedRowSetmust implement.interfaceFilteredRowSetThe standard interface that all standard implementations ofFilteredRowSetmust implement.interfaceJdbcRowSetThe standard interface that all standard implementations ofJdbcRowSetmust implement.interfaceJoinRowSetTheJoinRowSetinterface provides a mechanism for combining related data from differentRowSetobjects into oneJoinRowSetobject, which represents an SQLJOIN.interfaceWebRowSetThe standard interface that all implementations of aWebRowSetmust implement.Methods in javax.sql.rowset that return ResultSet Modifier and Type Method Description ResultSetCachedRowSet. getOriginal()Returns aResultSetobject containing the original value of thisCachedRowSetobject.ResultSetCachedRowSet. getOriginalRow()Returns aResultSetobject containing the original value for the current row only of thisCachedRowSetobject.Methods in javax.sql.rowset with parameters of type ResultSet Modifier and Type Method Description voidCachedRowSet. populate(ResultSet data)Populates thisCachedRowSetobject with data from the givenResultSetobject.voidCachedRowSet. populate(ResultSet rs, int startRow)Populates thisCachedRowSetobject with data from the givenResultSetobject.voidWebRowSet. writeXml(ResultSet rs, OutputStream oStream)Populates thisWebRowSetobject with the contents of the givenResultSetobject and writes its data, properties, and metadata to the givenOutputStreamobject in XML format.voidWebRowSet. writeXml(ResultSet rs, Writer writer)Populates thisWebRowSetobject with the contents of the givenResultSetobject and writes its data, properties, and metadata to the givenWriterobject in XML format. -
Uses of ResultSet in javax.sql.rowset.serial
Methods in javax.sql.rowset.serial that return ResultSet Modifier and Type Method Description ResultSetSerialArray. getResultSet()Retrieves aResultSetobject that contains all of the elements in theARRAYvalue that thisSerialArrayobject represents.ResultSetSerialArray. getResultSet(long index, int count)Retrieves aResultSetobject holding the elements of the subarray that starts at index index and contains up to count successive elements.ResultSetSerialArray. getResultSet(long index, int count, Map<String,Class<?>> map)Retrieves a result set holding the elements of the subarray that starts at Retrieves aResultSetobject that contains a subarray of the elements in thisSerialArrayobject, starting at index index and containing up to count successive elements.ResultSetSerialArray. getResultSet(Map<String,Class<?>> map)Retrieves aResultSetobject that contains all of the elements of the SQLARRAYvalue represented by thisSerialArrayobject. -
Uses of ResultSet in javax.sql.rowset.spi
Subinterfaces of ResultSet in javax.sql.rowset.spi Modifier and Type Interface Description interfaceSyncResolverDefines a framework that allows applications to use a manual decision tree to decide what should be done when a synchronization conflict occurs.