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 ResultSet
PreparedStatement. executeQuery()
Executes the SQL query in thisPreparedStatement
object and returns theResultSet
object generated by the query.ResultSet
Statement. executeQuery(String sql)
Executes the given SQL statement, which returns a singleResultSet
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 thisStatement
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 SQLARRAY
value designated by thisArray
object.ResultSet
Array. getResultSet(long index, int count)
Retrieves a result set holding the elements of the subarray that starts at indexindex
and contains up tocount
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 indexindex
and contains up tocount
successive elements.ResultSet
Array. getResultSet(Map<String,Class<?>> map)
Retrieves a result set that contains the elements of the SQLARRAY
value designated by thisArray
object.ResultSet
Statement. getResultSet()
Retrieves the current result as aResultSet
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 Modifier and Type Interface Description interface
RowSet
The 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 ResultSet
RowSetInternal. getOriginal()
Retrieves aResultSet
object containing the original value of thisRowSet
object.ResultSet
RowSetInternal. getOriginalRow()
Retrieves aResultSet
object 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 interface
CachedRowSet
The interface that all standard implementations ofCachedRowSet
must implement.interface
FilteredRowSet
The standard interface that all standard implementations ofFilteredRowSet
must implement.interface
JdbcRowSet
The standard interface that all standard implementations ofJdbcRowSet
must implement.interface
JoinRowSet
TheJoinRowSet
interface provides a mechanism for combining related data from differentRowSet
objects into oneJoinRowSet
object, which represents an SQLJOIN
.interface
WebRowSet
The standard interface that all implementations of aWebRowSet
must implement.Methods in javax.sql.rowset that return ResultSet Modifier and Type Method Description ResultSet
CachedRowSet. getOriginal()
Returns aResultSet
object containing the original value of thisCachedRowSet
object.ResultSet
CachedRowSet. getOriginalRow()
Returns aResultSet
object containing the original value for the current row only of thisCachedRowSet
object.Methods in javax.sql.rowset with parameters of type ResultSet Modifier and Type Method Description void
CachedRowSet. populate(ResultSet data)
Populates thisCachedRowSet
object with data from the givenResultSet
object.void
CachedRowSet. populate(ResultSet rs, int startRow)
Populates thisCachedRowSet
object with data from the givenResultSet
object.void
WebRowSet. writeXml(ResultSet rs, OutputStream oStream)
Populates thisWebRowSet
object with the contents of the givenResultSet
object and writes its data, properties, and metadata to the givenOutputStream
object in XML format.void
WebRowSet. writeXml(ResultSet rs, Writer writer)
Populates thisWebRowSet
object with the contents of the givenResultSet
object and writes its data, properties, and metadata to the givenWriter
object 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 ResultSet
SerialArray. getResultSet()
Retrieves aResultSet
object that contains all of the elements in theARRAY
value that thisSerialArray
object represents.ResultSet
SerialArray. getResultSet(long index, int count)
Retrieves aResultSet
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 aResultSet
object that contains a subarray of the elements in thisSerialArray
object, starting at index index and containing up to count successive elements.ResultSet
SerialArray. getResultSet(Map<String,Class<?>> map)
Retrieves aResultSet
object that contains all of the elements of the SQLARRAY
value represented by thisSerialArray
object. -
Uses of ResultSet in javax.sql.rowset.spi
Subinterfaces of ResultSet in javax.sql.rowset.spi Modifier and Type Interface 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.