|
|||||||||
| Home >> All >> java >> [ sql overview ] | PREV NEXT | ||||||||
Uses of Interface
java.sql.ResultSet
| Uses of ResultSet in java.sql |
| Methods in java.sql that return ResultSet | |
ResultSet |
Statement.executeQuery(java.lang.String sql)
This method executes the specified SQL SELECT statement and returns a (possibly empty) ResultSet with the results of the query. |
ResultSet |
Statement.getResultSet()
This method returns the result set of the SQL statement that was executed. |
ResultSet |
Statement.getGeneratedKeys()
|
ResultSet |
PreparedStatement.executeQuery()
This method executes a prepared SQL query and returns its ResultSet. |
ResultSet |
DatabaseMetaData.getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern)
This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. |
ResultSet |
DatabaseMetaData.getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern,
java.lang.String columnPattern)
This method returns a list of the parameter and result columns for the requested stored procedures. |
ResultSet |
DatabaseMetaData.getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String[] types)
This method returns a list of the requested table as a ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the table is in, which may be null.
TABLE_NAME - The name of the table.
TABLE_TYPE - A string describing the table type. |
ResultSet |
DatabaseMetaData.getSchemas()
This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the
name of the schema. |
ResultSet |
DatabaseMetaData.getCatalogs()
This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the
name of the catalog. |
ResultSet |
DatabaseMetaData.getTableTypes()
This method returns the list of database table types as a ResultSet with one column - TABLE_TYPE - that is the
name of the table type. |
ResultSet |
DatabaseMetaData.getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String columnPattern)
This method returns a list of the tables columns for the requested tables. |
ResultSet |
DatabaseMetaData.getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
java.lang.String columnPattern)
This method returns the access rights that have been granted to the requested columns. |
ResultSet |
DatabaseMetaData.getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern)
This method returns the access rights that have been granted to the requested tables. |
ResultSet |
DatabaseMetaData.getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
int scope,
boolean nullable)
This method returns the best set of columns for uniquely identifying a row. |
ResultSet |
DatabaseMetaData.getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns the set of columns that are automatically updated when the row is update. |
ResultSet |
DatabaseMetaData.getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of a table's primary key columns. |
ResultSet |
DatabaseMetaData.getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of the table's foreign keys. |
ResultSet |
DatabaseMetaData.getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of the table's which use this table's primary key as a foreign key. |
ResultSet |
DatabaseMetaData.getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTableName,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTableName)
This method returns a description of how one table imports another table's primary key as a foreign key. |
ResultSet |
DatabaseMetaData.getTypeInfo()
This method returns a list of the SQL types supported by this database. |
ResultSet |
DatabaseMetaData.getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
boolean unique,
boolean approximate)
This method returns information about a tables indices and statistics. |
ResultSet |
DatabaseMetaData.getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern,
int[] types)
This method returns the list of user defined data types in use. |
ResultSet |
DatabaseMetaData.getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern)
|
ResultSet |
DatabaseMetaData.getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern)
|
ResultSet |
DatabaseMetaData.getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern,
java.lang.String attributePattern)
|
ResultSet |
Array.getResultSet()
Returns the elements in the array as a ResultSet. |
ResultSet |
Array.getResultSet(java.util.Map map)
This method returns the elements in the array as a ResultSet. |
ResultSet |
Array.getResultSet(long start,
int count)
This method returns a portion of the array as a ResultSet. |
ResultSet |
Array.getResultSet(long start,
int count,
java.util.Map map)
This method returns a portion of the array as a ResultSet. |
|
|||||||||
| Home >> All >> java >> [ sql overview ] | PREV NEXT | ||||||||