Interface Name |
Description |
java.sql.Driver |
The Driver interface is responsible for creating
a connection to the data source. |
java.sql.Connection |
The Connection interface represents a connection
to the data source. It can create all types of statements as well as provide
information about the database through the java.sql.DatabaseMetaData interface. |
java.sql.DatabaseMetaData |
The DatabaseMetaData interface provides detailed
information about a data source and a database management system's (DBMS)
capabilities and requirements. |
java.sql.Statement |
The Statement interface is created from a connection.
It allows the user to execute simple SQL statements. |
java.sql.PreparedStatement |
The PreparedStatement interface is a statement
that is pre-compiled by the DBMS for higher performance. It has input parameters
that can be changed between executions. |
java.sql.CallableStatement |
The CallableStatement is much like a prepared
statement. It also allows output parameters as well as input parameters.
This interface is useful for executing stored procedures which have output
parameters. |
java.sql.ResultSet |
The ResultSet interface is returned by any of
the statement interfaces when a SQL query is executed. This interface allows
the use to retrieve the results of the query in several formats. |
java.sql.ResultSetMetaData |
The ResultSetMetaData interface describes a result
set. It provides information like how many rows there are and what data
type is in each row. |
Class Name |
Description |
java.sql.DriverManager |
The DriverManager class handles all of the JDBC
drivers. It provides functions to get connections to data sources. It decides
if any driver is appropriate for the specific connection requested and
then communicates with that driver. Any JDBC driver that may be used should
be registered with the DriverManager. |
java.sql.DriverPropertyInfo |
The DriverPropertyInfo class can be used by advanced
programmers to find out what information the driver needs to connect with
a data source. |
java.sql.Types |
The Types class is an enumeration of all of the
SQL data types. |
java.sql.Time |
The Time class represents a SQL time data type. |
java.sql.TimeStamp |
The TimeStamp class represents a SQL timestamp
data type. |
java.sql.Date |
The Date class represents a SQL date data type. |
Interface Name |
Description |
javax.sql.DataSource |
A factory for connections to the physical data source that this DataSource
object represents. An alternative to the DriverManager facility, a DataSource
object is the preferred means of getting a connection. An object that implements
the DataSource interface will typically be registered with a naming service
based on the Java Naming and Directory (JNDI) API. |
javax.sql.PooledConnection |
An object that provides hooks for connection pool
management. A PooledConnection object represents a physical connection
to a data source. The connection can be recycled rather than being closed
when an application is finished with it, thus reducing the number of connections
that need to be made. |
javax.sql.ConnectionPoolDataSource |
A factory for PooledConnection objects. An object that implements
this interface will typically be registered with a naming service that
is based on the Java Naming and Directory Interface (JNDI). |
javax.sql.RowSet |
A RowSet object contains a set of rows from a result set or some other
source of tabular data, like a file or spreadsheet. Because a RowSet object
follows the JavaBeans model for properties and event notification,
it is a JavaBeans component that can be combined with other components
in an application. |