Index

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> java >> [ sql overview ]

PREV NEXT

A B C D E F G H I J K L M N O P R S T U V W

A

ARRAY - Static variable in class java.sql.Types
Array - interface java.sql.Array.: This interface provides methods for accessing SQL array types.
absolute(int) - Method in interface java.sql.ResultSet: This method positions the result set to the specified absolute row.
acceptsURL(String) - Method in interface java.sql.Driver: This method tests whether or not the driver believes it can connect to the specified database.
addBatch() - Method in interface java.sql.PreparedStatement: This method adds a set of parameters to the batch for JDBC 2.0.
addBatch(String) - Method in interface java.sql.Statement: This method adds a SQL statement to a SQL batch.
after(Timestamp) - Method in class java.sql.Timestamp: This methods tests whether this object is later than the specified object.
afterLast() - Method in interface java.sql.ResultSet: This method repositions the cursor to after the last row in the result set.
allProceduresAreCallable() - Method in interface java.sql.DatabaseMetaData: This method tests whether or not all the procedures returned by the getProcedures method can be called by this user.
allTablesAreSelectable() - Method in interface java.sql.DatabaseMetaData: This method tests whether or not all the table returned by the getTables method can be selected by this user.
attributeNoNulls - Static variable in interface java.sql.DatabaseMetaData: A NULL value is not allowed for this attribute.
attributeNullable - Static variable in interface java.sql.DatabaseMetaData: A NULL value is allowed for this attribute.
attributeNullableUnknown - Static variable in interface java.sql.DatabaseMetaData: It is unknown whether or not NULL values are allowed for this attribute.

B

BIGINT - Static variable in class java.sql.Types
BINARY - Static variable in class java.sql.Types
BIT - Static variable in class java.sql.Types
BLOB - Static variable in class java.sql.Types
BOOLEAN - Static variable in class java.sql.Types
BatchUpdateException - exception java.sql.BatchUpdateException.: This class extends SQLException to count the successful updates in each statement in a batch that was successfully updated prior to the error.
BatchUpdateException(String, String, int, int[]) - Constructor for class java.sql.BatchUpdateException: This method initializes a new instance of BatchUpdateException with the specified descriptive error message, SQL state, and update count information.
BatchUpdateException(String, String, int[]) - Constructor for class java.sql.BatchUpdateException: This method initializes a new instance of BatchUpdateException with the specified descriptive error message, SQL state, and update count information.
BatchUpdateException(String, int[]) - Constructor for class java.sql.BatchUpdateException: This method initializes a new instance of BatchUpdateException with the specified descriptive error message and update count information.
BatchUpdateException(int[]) - Constructor for class java.sql.BatchUpdateException: Initializes a new instance of BatchUpdateException with the specified update count information and no descriptive error message.
BatchUpdateException() - Constructor for class java.sql.BatchUpdateException: Initializes a new instance of BatchUpdateException with no descriptive error message.
Blob - interface java.sql.Blob.: This interface specified methods for accessing a SQL BLOB (Binary Large OBject) type.
before(Timestamp) - Method in class java.sql.Timestamp: This methods tests whether this object is earlier than the specified object.
beforeFirst() - Method in interface java.sql.ResultSet: This method repositions the cursor to before the first row in the result set.
bestRowNotPseudo - Static variable in interface java.sql.DatabaseMetaData: The best row identifier is not a pseudo-column.
bestRowPseudo - Static variable in interface java.sql.DatabaseMetaData: The best row identifier is a pseudo-column.
bestRowSession - Static variable in interface java.sql.DatabaseMetaData: The best row identifier is valid to the end of the session.
bestRowTemporary - Static variable in interface java.sql.DatabaseMetaData: The best row's scope is only guaranteed to be valid so long as the row is actually being used.
bestRowTransaction - Static variable in interface java.sql.DatabaseMetaData: The best row identifier is valid to the end of the transaction.
bestRowUnknown - Static variable in interface java.sql.DatabaseMetaData: The best row may or may not be a pseudo-column.

C

CHAR - Static variable in class java.sql.Types
CLOB - Static variable in class java.sql.Types
CLOSE_ALL_RESULTS - Static variable in interface java.sql.Statement
CLOSE_CURRENT_RESULT - Static variable in interface java.sql.Statement
CLOSE_CURSORS_AT_COMMIT - Static variable in interface java.sql.ResultSet
CONCUR_READ_ONLY - Static variable in interface java.sql.ResultSet: The concurrency mode of for the result set may not be modified.
CONCUR_UPDATABLE - Static variable in interface java.sql.ResultSet: The concurrency mode of for the result set may be modified.
CallableStatement - interface java.sql.CallableStatement.: This interface provides a mechanism for calling stored procedures.
Clob - interface java.sql.Clob.: This interface contains methods for accessing a SQL CLOB (Character Large OBject) type.
Connection - interface java.sql.Connection.: This interface provides methods for managing a connection to a database.
cancel() - Method in interface java.sql.Statement: This method cancels an outstanding statement, if the database supports that operation.
cancelRowUpdates() - Method in interface java.sql.ResultSet: This method cancels any changes that have been made to a row.
choices - Variable in class java.sql.DriverPropertyInfo: If values are restricted to certain choices, this is the list of valid ones.
clearBatch() - Method in interface java.sql.Statement: This method clears out any SQL statements that have been populated in the current batch.
clearParameters() - Method in interface java.sql.PreparedStatement: This method clears all of the input parameter that have been set on this statement.
clearWarnings() - Method in interface java.sql.Connection: This method clears all warnings that have occurred on this connection.
clearWarnings() - Method in interface java.sql.ResultSet: This method clears all warnings associated with this result set.
clearWarnings() - Method in interface java.sql.Statement: This method clears any SQL warnings that have been attached to this statement.
close() - Method in interface java.sql.Connection: This method immediately closes this database connection.
close() - Method in interface java.sql.ResultSet: This method closes the result set and frees any associated resources.
close() - Method in interface java.sql.Statement: This method closes the statement and frees any associated resources.
columnNoNulls - Static variable in interface java.sql.DatabaseMetaData: The column does not allow NULL
columnNoNulls - Static variable in interface java.sql.ResultSetMetaData: The column does not allow NULL's.
columnNullable - Static variable in interface java.sql.DatabaseMetaData: The column does allow NULL
columnNullable - Static variable in interface java.sql.ResultSetMetaData: The column allows NULL's.
columnNullableUnknown - Static variable in interface java.sql.DatabaseMetaData: It is unknown whether or not the column allows NULL
columnNullableUnknown - Static variable in interface java.sql.ResultSetMetaData: It is unknown whether or not the column allows NULL's.
commit() - Method in interface java.sql.Connection: This method commits any SQL statements executed on this connection since the last commit or rollback.
compareTo(Timestamp) - Method in class java.sql.Timestamp: Compares this Timestamp to another one.
compareTo(Object) - Method in class java.sql.Timestamp: Compares this Timestamp to another one.
connect(String, Properties) - Method in interface java.sql.Driver: This method connects to the specified database using the connection properties supplied.
createStatement() - Method in interface java.sql.Connection: This method creates a new SQL statement.
createStatement(int, int) - Method in interface java.sql.Connection: This method creates a new SQL statement with the specified type and concurrency.
createStatement(int, int, int) - Method in interface java.sql.Connection: This method creates a new SQL statement with the specified type, concurrency and holdability, instead of using the defaults.

D

DATALINK - Static variable in class java.sql.Types
DATE - Static variable in class java.sql.Types
DECIMAL - Static variable in class java.sql.Types
DISTINCT - Static variable in class java.sql.Types
DOUBLE - Static variable in class java.sql.Types
DataTruncation - exception java.sql.DataTruncation.: This exception is thrown when a piece of data is unexpectedly truncated in JDBC.
DataTruncation(int, boolean, boolean, int, int) - Constructor for class java.sql.DataTruncation: This method initializes a new instance of DataTruncation with the specified values.
DatabaseMetaData - interface java.sql.DatabaseMetaData.
Date - class java.sql.Date.: This class is a wrapper around java.util.Date to allow the JDBC driver to identify the value as a SQL Date.
Date(int, int, int) - Constructor for class java.sql.Date: Deprecated.
Date(long) - Constructor for class java.sql.Date: This method initializes a new instance of this class with the specified time value representing the number of milliseconds since Jan 1, 1970 at 12:00 midnight GMT.
Driver - interface java.sql.Driver.: This interface specifies a mechanism for accessing a JDBC database driver.
DriverManager - class java.sql.DriverManager.: This class manages the JDBC drivers in the system.
DriverManager() - Constructor for class java.sql.DriverManager: Can't be instantiated.
DriverPropertyInfo - class java.sql.DriverPropertyInfo.: This class holds a driver property that can be used for querying or setting driver configuration parameters.
DriverPropertyInfo(String, String) - Constructor for class java.sql.DriverPropertyInfo: This method initializes a new instance of DriverPropertyInfo with the specified name and value.
dataDefinitionCausesTransactionCommit() - Method in interface java.sql.DatabaseMetaData: This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.
dataDefinitionIgnoredInTransactions() - Method in interface java.sql.DatabaseMetaData: This method tests whether or not DDL statements are ignored in transactions.
dataSize - Variable in class java.sql.DataTruncation: The original size of the data.
dateFormat - Static variable in class java.sql.Timestamp: Used for parsing and formatting this date.
decimalFormat - Static variable in class java.sql.Timestamp
deleteRow() - Method in interface java.sql.ResultSet: This method deletes the current row in the database.
deletesAreDetected(int) - Method in interface java.sql.DatabaseMetaData: This method tests whether or not the specified result set type can detect a visible delete by calling the rowUpdated method.
deregisterDriver(Driver) - Static method in class java.sql.DriverManager: This method de-registers a driver from the manager.
description - Variable in class java.sql.DriverPropertyInfo: A description of the property, possibly null.
doesMaxRowSizeIncludeBlobs() - Method in interface java.sql.DatabaseMetaData: This method tests whether or not the maximum row size includes BLOB's
drivers - Static variable in class java.sql.DriverManager: This is the list of JDBC drivers that are loaded.

E

EXECUTE_FAILED - Static variable in interface java.sql.Statement
equals(Object) - Method in class java.sql.Timestamp: This method these the specified Object for equality against this object.
equals(Timestamp) - Method in class java.sql.Timestamp: This method tests the specified timestamp for equality against this object.
execute() - Method in interface java.sql.PreparedStatement: This method executes a prepared SQL query.
execute(String) - Method in interface java.sql.Statement: This method executes an arbitrary SQL statement of any time.
execute(String, int) - Method in interface java.sql.Statement
execute(String, int[]) - Method in interface java.sql.Statement
execute(String, String[]) - Method in interface java.sql.Statement
executeBatch() - Method in interface java.sql.Statement: This method executes the SQL batch and returns an array of update counts - one for each SQL statement in the batch - ordered in the same order the statements were added to the batch.
executeQuery() - Method in interface java.sql.PreparedStatement: This method executes a prepared SQL query and returns its ResultSet.
executeQuery(String) - Method in interface java.sql.Statement: This method executes the specified SQL SELECT statement and returns a (possibly empty) ResultSet with the results of the query.
executeUpdate() - Method in interface java.sql.PreparedStatement: This method executes an SQL INSERT, UPDATE or DELETE statement.
executeUpdate(String) - Method in interface java.sql.Statement: This method executes the specified SQL INSERT, UPDATE, or DELETE statement and returns the number of rows affected, which may be 0.
executeUpdate(String, int) - Method in interface java.sql.Statement
executeUpdate(String, int[]) - Method in interface java.sql.Statement
executeUpdate(String, String[]) - Method in interface java.sql.Statement

F

FETCH_FORWARD - Static variable in interface java.sql.ResultSet: The rows will be processed in order from first to last.
FETCH_REVERSE - Static variable in interface java.sql.ResultSet: The rows will be processed in order from last to first.
FETCH_UNKNOWN - Static variable in interface java.sql.ResultSet: The rows will be processed in an unknown order
FLOAT - Static variable in class java.sql.Types
findColumn(String) - Method in interface java.sql.ResultSet: This method returns the column index of the specified named column.
first() - Method in interface java.sql.ResultSet: This method repositions the cursor on the first row in the result set.

G

getArray() - Method in interface java.sql.Array: Returns the contents of this array.
getArray(Map) - Method in interface java.sql.Array: Returns the contents of this array.
getArray(long, int) - Method in interface java.sql.Array: Returns a portion of this array starting at start into the array and continuing for count elements.
getArray(long, int, Map) - Method in interface java.sql.Array: This method returns a portion of this array starting at start into the array and continuing for count elements.
getArray(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Array.
getArray(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Array.
getArray(int) - Method in interface java.sql.ResultSet: This method returns the specified column value as an Array.
getArray(String) - Method in interface java.sql.ResultSet: This method returns the specified column value as an Array.
getAsciiStream() - Method in interface java.sql.Clob: This method returns a byte stream that reads the contents of this Clob as a series of ASCII bytes.
getAsciiStream(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as an ASCII stream.
getAsciiStream(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as an ASCII stream.
getAttributes(String, String, String, String) - Method in interface java.sql.DatabaseMetaData
getAttributes() - Method in interface java.sql.Struct: This method returns the attributes of this SQL structured type.
getAttributes(Map) - Method in interface java.sql.Struct: This method returns the attributes of this SQL structured type.
getAutoCommit() - Method in interface java.sql.Connection: This method tests whether or not auto commit mode is currently enabled.
getBaseType() - Method in interface java.sql.Array: Returns the JDBC type identifier of the elements in this array.
getBaseTypeName() - Method in interface java.sql.Array: Returns the name of the SQL type of the elements in this array.
getBaseTypeName() - Method in interface java.sql.Ref: This method returns the fully qualified name of the SQL structured type of the referenced item.
getBestRowIdentifier(String, String, String, int, boolean) - Method in interface java.sql.DatabaseMetaData: This method returns the best set of columns for uniquely identifying a row.
getBigDecimal(int, int) - Method in interface java.sql.CallableStatement: Deprecated. Use getBigDecimal(int index) or getBigDecimal(String name) instead.
getBigDecimal(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java BigDecimal.
getBigDecimal(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java BigDecimal.
getBigDecimal(int, int) - Method in interface java.sql.ResultSet: Deprecated.
getBigDecimal(String, int) - Method in interface java.sql.ResultSet: Deprecated.
getBigDecimal(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java BigDecimal.
getBigDecimal(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java BigDecimal.
getBinaryStream() - Method in interface java.sql.Blob: This method returns a stream that will read the bytes of this Blob.
getBinaryStream(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a raw byte stream.
getBinaryStream(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a raw byte stream.
getBlob(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Blob.
getBlob(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Blob.
getBlob(int) - Method in interface java.sql.ResultSet: This method returns the specified column value as a BLOB.
getBlob(String) - Method in interface java.sql.ResultSet: This method returns the specified column value as a BLOB.
getBoolean(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java boolean.
getBoolean(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java boolean.
getBoolean(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java boolean.
getBoolean(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java boolean.
getByte(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java byte.
getByte(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java byte.
getByte(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java byte.
getByte(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java byte.
getBytes(long, int) - Method in interface java.sql.Blob: This method returns up to the requested bytes of this Blob as a byte array.
getBytes(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java byte array.
getBytes(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java byte array.
getBytes(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java byte array.
getBytes(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java byte array.
getCatalog() - Method in interface java.sql.Connection: This method returns the name of the catalog in use by this connection, if any.
getCatalogName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the catalog containing the specified column.
getCatalogSeparator() - Method in interface java.sql.DatabaseMetaData: This method returns the separator between the catalog name and the table name.
getCatalogTerm() - Method in interface java.sql.DatabaseMetaData: This method returns the vendor's term for "catalog".
getCatalogs() - Method in interface java.sql.DatabaseMetaData: This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the name of the catalog.
getCharacterStream() - Method in interface java.sql.Clob: This method returns a character stream that reads the contents of this Clob.
getCharacterStream(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a character stream.
getCharacterStream(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a character stream.
getClob(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Clob.
getClob(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Clob.
getClob(int) - Method in interface java.sql.ResultSet: This method returns the specified column value as a CLOB.
getClob(String) - Method in interface java.sql.ResultSet: This method returns the specified column value as a CLOB.
getColumnClassName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the Java class which will be used to create objects representing the data in this column.
getColumnCount() - Method in interface java.sql.ResultSetMetaData: This method returns the number of columns in the result set.
getColumnDisplaySize(int) - Method in interface java.sql.ResultSetMetaData: This method returns the maximum number of characters that can be used to display a value in this column.
getColumnLabel(int) - Method in interface java.sql.ResultSetMetaData: This method returns a string that should be used as a caption for this column for user display purposes.
getColumnName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the specified column.
getColumnPrivileges(String, String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns the access rights that have been granted to the requested columns.
getColumnType(int) - Method in interface java.sql.ResultSetMetaData: This method returns the SQL type of the specified column.
getColumnTypeName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the SQL type for this column.
getColumns(String, String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of the tables columns for the requested tables.
getConcurrency() - Method in interface java.sql.ResultSet: This method returns the concurrency type of this result set.
getConnection() - Method in interface java.sql.DatabaseMetaData: This method returns the Connection object that was used to generate the metadata in this object.
getConnection(String, Properties) - Static method in class java.sql.DriverManager: This method attempts to return a connection to the specified JDBC URL string using the specified connection properties.
getConnection(String, String, String) - Static method in class java.sql.DriverManager: This method attempts to return a connection to the specified JDBC URL string using the specified username and password.
getConnection(String) - Static method in class java.sql.DriverManager: This method attempts to return a connection to the specified JDBC URL string.
getConnection() - Method in interface java.sql.Statement: This method returns the Connection instance that was used to create this object.
getCrossReference(String, String, String, String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a description of how one table imports another table's primary key as a foreign key.
getCursorName() - Method in interface java.sql.ResultSet: This method returns the name of the database cursor used by this result set.
getDataSize() - Method in class java.sql.DataTruncation: This method returns the original size of the parameter or column that was truncated.
getDatabaseMajorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the major version number of the database.
getDatabaseMinorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the minor version number of the database.
getDatabaseProductName() - Method in interface java.sql.DatabaseMetaData: This method returns the name of the database product.
getDatabaseProductVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the version of the database product.
getDate(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Date.
getDate(int, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Date.
getDate(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Date.
getDate(String, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Date.
getDate(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Date.
getDate(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Date.
getDate(int, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Date.
getDate(String, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Date.
getDate() - Method in class java.sql.Time: Deprecated.
getDay() - Method in class java.sql.Time: Deprecated.
getDefaultTransactionIsolation() - Method in interface java.sql.DatabaseMetaData: This method returns the default transaction isolation level of the database.
getDouble(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java double.
getDouble(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java double.
getDouble(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java double.
getDouble(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java double.
getDriver(String) - Static method in class java.sql.DriverManager: This method returns a driver that can connect to the specified JDBC URL string.
getDriverMajorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the major version number of the JDBC driver.
getDriverMinorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the minor version number of the JDBC driver.
getDriverName() - Method in interface java.sql.DatabaseMetaData: This method returns the name of the JDBC driver.
getDriverVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the version of the JDBC driver.
getDrivers() - Static method in class java.sql.DriverManager: This method returns a list of all the currently registered JDBC drivers that were loaded by the current ClassLoader.
getErrorCode() - Method in class java.sql.SQLException: This method returns the vendor specific error code associated with this error.
getExportedKeys(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of the table's which use this table's primary key as a foreign key.
getExtraNameCharacters() - Method in interface java.sql.DatabaseMetaData: This methods returns non-standard characters that can appear in unquoted identifiers.
getFetchDirection() - Method in interface java.sql.ResultSet: This method returns the current fetch direction for this result set.
getFetchDirection() - Method in interface java.sql.Statement: This method returns the current direction that the driver thinks the result set will be accessed int.
getFetchSize() - Method in interface java.sql.ResultSet: This method returns the current number of rows that will be fetched from the database at a time.
getFetchSize() - Method in interface java.sql.Statement: This method returns the number of rows the driver believes should be fetched from the database at a time.
getFloat(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java float.
getFloat(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java float.
getFloat(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java float.
getFloat(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java float.
getGeneratedKeys() - Method in interface java.sql.Statement
getHoldability() - Method in interface java.sql.Connection: Gets the default holdability of ResultSetS that are created from StatementS using this Connection.
getHours() - Method in class java.sql.Date: Deprecated.
getIdentifierQuoteString() - Method in interface java.sql.DatabaseMetaData: This metohd returns the quote string for SQL identifiers.
getImportedKeys(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of the table's foreign keys.
getIndex() - Method in class java.sql.DataTruncation: This method returns the index of the column or parameter that was truncated.
getIndexInfo(String, String, String, boolean, boolean) - Method in interface java.sql.DatabaseMetaData: This method returns information about a tables indices and statistics.
getInt(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java int.
getInt(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java int.
getInt(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java int.
getInt(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java int.
getJDBCMajorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the major version number of the JDBC driver.
getJDBCMinorVersion() - Method in interface java.sql.DatabaseMetaData: This method returns the minor version number of the JDBC driver.
getLogStream() - Static method in class java.sql.DriverManager: Deprecated. Use getLogWriter() instead.
getLogWriter() - Static method in class java.sql.DriverManager: This method returns the log writer being used by all JDBC drivers.
getLoginTimeout() - Static method in class java.sql.DriverManager: This method returns the login timeout in use by JDBC drivers systemwide.
getLong(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java long.
getLong(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java long.
getLong(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java long.
getLong(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java long.
getMajorVersion() - Method in interface java.sql.Driver: This method returns the major version number of the driver.
getMaxBinaryLiteralLength() - Method in interface java.sql.DatabaseMetaData: This method returns the number of hex characters allowed in an inline binary literal.
getMaxCatalogNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a catalog name.
getMaxCharLiteralLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a character literal.
getMaxColumnNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a column name.
getMaxColumnsInGroupBy() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of columns in a GROUP BY statement.
getMaxColumnsInIndex() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of columns in an index.
getMaxColumnsInOrderBy() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of columns in an ORDER BY statement.
getMaxColumnsInSelect() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of columns in a SELECT statement.
getMaxColumnsInTable() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of columns in a table.
getMaxConnections() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of connections this client can have to the database.
getMaxCursorNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a cursor name.
getMaxFieldSize() - Method in interface java.sql.Statement: This method returns the maximum length of any column value in bytes.
getMaxIndexLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of an index.
getMaxProcedureNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a procedure name.
getMaxRowSize() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum size of a row in bytes.
getMaxRows() - Method in interface java.sql.Statement: This method returns the maximum possible number of rows in a result set.
getMaxSchemaNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a schema name.
getMaxStatementLength() - Method in interface java.sql.DatabaseMetaData: This method includes the maximum length of a SQL statement.
getMaxStatements() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of statements that can be active at any time.
getMaxTableNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a table name.
getMaxTablesInSelect() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum number of tables that may be referenced in a SELECT statement.
getMaxUserNameLength() - Method in interface java.sql.DatabaseMetaData: This method returns the maximum length of a user name.
getMetaData() - Method in interface java.sql.Connection: This method returns the meta data for this database connection.
getMetaData() - Method in interface java.sql.PreparedStatement: This method returns meta data for the result set from this statement.
getMetaData() - Method in interface java.sql.ResultSet: This method returns data about the columns returned as part of the result set as a ResultSetMetaData instance.
getMinorVersion() - Method in interface java.sql.Driver: This method returns the minor version number of the driver.
getMinutes() - Method in class java.sql.Date: Deprecated.
getMonth() - Method in class java.sql.Time: Deprecated.
getMoreResults() - Method in interface java.sql.Statement: This method advances the result set pointer to the next result set, which can then be retrieved using getResultSet
getMoreResults(int) - Method in interface java.sql.Statement
getNanos() - Method in class java.sql.Timestamp: This method returns the nanosecond value for this object.
getNextException() - Method in class java.sql.SQLException: This method returns the exception that is chained to this object.
getNextWarning() - Method in class java.sql.SQLWarning: This method returns the exception that is chained to this object.
getNumericFunctions() - Method in interface java.sql.DatabaseMetaData: This method returns a comma separated list of math functions.
getObject(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Object.
getObject(int, Map) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Object.
getObject(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Object.
getObject(String, Map) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Object using the specified mapping for conversion from SQL to Java types.
getObject(Map) - Method in interface java.sql.Ref
getObject() - Method in interface java.sql.Ref
getObject(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java Object.
getObject(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java Object.
getObject(int, Map) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
getObject(String, Map) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
getParameter() - Method in class java.sql.DataTruncation: This method determines whether or not it was a parameter that was truncated.
getParameterClassName(int) - Method in interface java.sql.ParameterMetaData
getParameterCount() - Method in interface java.sql.ParameterMetaData
getParameterMetaData() - Method in interface java.sql.PreparedStatement: Returns information about the parameters set on this PreparedStatement (see ParameterMetaData for a detailed description of the provided information).
getParameterMode(int) - Method in interface java.sql.ParameterMetaData
getParameterType(int) - Method in interface java.sql.ParameterMetaData
getParameterTypeName(int) - Method in interface java.sql.ParameterMetaData
getPrecision(int) - Method in interface java.sql.ParameterMetaData
getPrecision(int) - Method in interface java.sql.ResultSetMetaData: This method returns the precision of the specified column, which is the number of decimal digits it contains.
getPrimaryKeys(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of a table's primary key columns.
getProcedureColumns(String, String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of the parameter and result columns for the requested stored procedures.
getProcedureTerm() - Method in interface java.sql.DatabaseMetaData: This method returns the vendor's term for "procedure".
getProcedures(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog.
getPropertyInfo(String, Properties) - Method in interface java.sql.Driver: This method returns an array of possible properties that could be used to connect to the specified database.
getQueryTimeout() - Method in interface java.sql.Statement: The method returns the number of seconds a statement may be in process before timing out.
getRead() - Method in class java.sql.DataTruncation: This method determines whether or not it was a column that was truncated.
getRef(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Ref.
getRef(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java Ref.
getRef(int) - Method in interface java.sql.ResultSet: This method returns a Ref for the specified column which represents the structured type for the column.
getRef(String) - Method in interface java.sql.ResultSet: This method returns a Ref for the specified column which represents the structured type for the column.
getResultSet() - Method in interface java.sql.Array: Returns the elements in the array as a ResultSet.
getResultSet(Map) - Method in interface java.sql.Array: This method returns the elements in the array as a ResultSet.
getResultSet(long, int) - Method in interface java.sql.Array: This method returns a portion of the array as a ResultSet.
getResultSet(long, int, Map) - Method in interface java.sql.Array: This method returns a portion of the array as a ResultSet.
getResultSet() - Method in interface java.sql.Statement: This method returns the result set of the SQL statement that was executed.
getResultSetConcurrency() - Method in interface java.sql.Statement: This method returns the concurrency type of the result set for this statement.
getResultSetHoldability() - Method in interface java.sql.DatabaseMetaData: This method returns the default holdability type of ResultSetS retrieved from this database.
getResultSetHoldability() - Method in interface java.sql.Statement
getResultSetType() - Method in interface java.sql.Statement: This method returns the result set type for this statement.
getRow() - Method in interface java.sql.ResultSet: This method returns the current row number in the cursor.
getSQLKeywords() - Method in interface java.sql.DatabaseMetaData: This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.
getSQLState() - Method in class java.sql.SQLException: This method returns the SQLState information associated with this error.
getSQLStateType() - Method in interface java.sql.DatabaseMetaData
getSQLTypeName() - Method in interface java.sql.SQLData: This method returns the user defined datatype name for this object.
getSQLTypeName() - Method in interface java.sql.Struct: This method returns the name of the SQL structured type for this object.
getSavepointId() - Method in interface java.sql.Savepoint
getSavepointName() - Method in interface java.sql.Savepoint
getScale(int) - Method in interface java.sql.ParameterMetaData
getScale(int) - Method in interface java.sql.ResultSetMetaData: This method returns the scale of the specified column, which is the number of digits to the right of the decimal point.
getSchemaName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the schema that contains the specified column.
getSchemaTerm() - Method in interface java.sql.DatabaseMetaData: This method returns the vendor's term for "schema".
getSchemas() - Method in interface java.sql.DatabaseMetaData: This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the name of the schema.
getSearchStringEscape() - Method in interface java.sql.DatabaseMetaData: This method returns the string used to escape wildcards in search strings.
getSeconds() - Method in class java.sql.Date: Deprecated.
getShort(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java short.
getShort(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java short.
getShort(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java short.
getShort(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java short.
getStatement() - Method in interface java.sql.ResultSet: This method returns a the Statement that was used to produce this result set.
getString(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java String.
getString(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java String.
getString(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java String.
getString(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java String.
getStringFunctions() - Method in interface java.sql.DatabaseMetaData: This method returns a comma separated list of string functions.
getSubString(long, int) - Method in interface java.sql.Clob: This method returns the specified portion of this Clob as a String.
getSuperTables(String, String, String) - Method in interface java.sql.DatabaseMetaData
getSuperTypes(String, String, String) - Method in interface java.sql.DatabaseMetaData
getSystemFunctions() - Method in interface java.sql.DatabaseMetaData: This method returns a comma separated list of of system functions.
getTableName(int) - Method in interface java.sql.ResultSetMetaData: This method returns the name of the table containing the specified column.
getTablePrivileges(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns the access rights that have been granted to the requested tables.
getTableTypes() - Method in interface java.sql.DatabaseMetaData: 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.
getTables(String, String, String, String[]) - Method in interface java.sql.DatabaseMetaData: 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.
getTime(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Time.
getTime(int, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Time.
getTime(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Time.
getTime(String, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Time.
getTime(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Time.
getTime(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Time.
getTime(int, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Time.
getTime(String, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Time.
getTime() - Method in class java.sql.Timestamp: Return the value of this Timestamp as the number of milliseconds since Jan 1, 1970 at 12:00 midnight GMT.
getTimeDateFunctions() - Method in interface java.sql.DatabaseMetaData: This method returns comma separated list of time/date functions.
getTimestamp(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Timestamp.
getTimestamp(int, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Timestamp.
getTimestamp(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Timestamp.
getTimestamp(String, Calendar) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.sql.Timestamp.
getTimestamp(int) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Timestamp.
getTimestamp(String) - Method in interface java.sql.ResultSet: This method returns the value of the specified column as a Java java.sql.Timestamp.
getTimestamp(int, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Timestamp.
getTimestamp(String, Calendar) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.sql.Timestamp.
getTransactionIsolation() - Method in interface java.sql.Connection: This method returns the current transaction isolation mode.
getTransferSize() - Method in class java.sql.DataTruncation: This method returns the size of the parameter or column after it was truncated.
getType() - Method in interface java.sql.ResultSet: This method returns the result set type of this result set.
getTypeInfo() - Method in interface java.sql.DatabaseMetaData: This method returns a list of the SQL types supported by this database.
getTypeMap() - Method in interface java.sql.Connection: This method returns the mapping of SQL types to Java classes currently in use by this connection.
getUDTs(String, String, String, int[]) - Method in interface java.sql.DatabaseMetaData: This method returns the list of user defined data types in use.
getURL(int) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.net.URL.
getURL(String) - Method in interface java.sql.CallableStatement: This method returns the value of the specified parameter as a Java java.net.URL.
getURL() - Method in interface java.sql.DatabaseMetaData: This method returns the URL for this database.
getURL(int) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.net.URL.
getURL(String) - Method in interface java.sql.ResultSet: This method returns the specified column value as a java.net.URL.
getUnicodeStream(int) - Method in interface java.sql.ResultSet: Deprecated. Use getCharacterStream instead.
getUnicodeStream(String) - Method in interface java.sql.ResultSet: Deprecated. Use getCharacterStream instead.
getUpdateCount() - Method in interface java.sql.Statement: This method returns the update count of the SQL statement that was executed.
getUpdateCounts() - Method in class java.sql.BatchUpdateException: This method returns the update count information for this error.
getUserName() - Method in interface java.sql.DatabaseMetaData: This method returns the database username for this connection.
getVersionColumns(String, String, String) - Method in interface java.sql.DatabaseMetaData: This method returns the set of columns that are automatically updated when the row is update.
getWarnings() - Method in interface java.sql.Connection: This method returns the first warning that occurred on this connection, if any.
getWarnings() - Method in interface java.sql.ResultSet: This method returns the first SQL warning associated with this result set.
getWarnings() - Method in interface java.sql.Statement: This method returns the first SQL warning attached to this statement.
getYear() - Method in class java.sql.Time: Deprecated.

H

HOLD_CURSORS_OVER_COMMIT - Static variable in interface java.sql.ResultSet

I

INTEGER - Static variable in class java.sql.Types
importedKeyCascade - Static variable in interface java.sql.DatabaseMetaData: Foreign key changes are cascaded in updates or deletes.
importedKeyInitiallyDeferred - Static variable in interface java.sql.DatabaseMetaData: Wish I knew what this meant.
importedKeyInitiallyImmediate - Static variable in interface java.sql.DatabaseMetaData: Wish I knew what this meant.
importedKeyNoAction - Static variable in interface java.sql.DatabaseMetaData: If the primary key is a foreign key, it cannot be udpated or deleted.
importedKeyNotDeferrable - Static variable in interface java.sql.DatabaseMetaData: Wish I knew what this meant.
importedKeyRestrict - Static variable in interface java.sql.DatabaseMetaData: Column may not be updated or deleted in use as a foreign key.
importedKeySetDefault - Static variable in interface java.sql.DatabaseMetaData: If the primary key is updated or deleted, the foreign key is set to a default value.
importedKeySetNull - Static variable in interface java.sql.DatabaseMetaData: When primary key is updated or deleted, the foreign key is set to NULL.
index - Variable in class java.sql.DataTruncation: The index of the parameter or column whose value was truncated.
insertRow() - Method in interface java.sql.ResultSet: This method inserts the current row into the database.
insertsAreDetected(int) - Method in interface java.sql.DatabaseMetaData: This method tests whether or not the specified result set type can detect a visible insert by calling the rowUpdated method.
isAfterLast() - Method in interface java.sql.ResultSet: This method tests whether or not the cursor is after the last row in the result set.
isAutoIncrement(int) - Method in interface java.sql.ResultSetMetaData: This method test whether or not the column is an auto-increment column.
isBeforeFirst() - Method in interface java.sql.ResultSet: This method tests whether or not the cursor is before the first row in the result set.
isCaseSensitive(int) - Method in interface java.sql.ResultSetMetaData: This method tests whether or not a column is case sensitive in its values.
isCatalogAtStart() - Method in interface java.sql.DatabaseMetaData: This method tests whether a catalog name appears at the beginning of a fully qualified table name.