Using DBIntegrator Client for JDBC

[Top] [Prev][Next][Bottom]



 

Appendix A: JDBC Core API Interfaces

The standard JDBC API contains a set of interfaces for application programmers to open connections to databases and execute SQL and process results. A brief description of the interfaces and classes is given here.

For more detailed information, see the Java Development Kit (JDK) located on JavaSoft's Web site at www.javasoft.com.
 
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. 

JDBC 2.0 Optional Package Interfaces


The JDBC 2.0 Optional Package (formerly Standard Extension API) adds significant functionality for using databases and other data sources. Some of this functionality applies mainly to enterprise computing, and some of it applies more generally.
 
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.


[Top] [Prev][Next][Bottom]


csr@unify.com

Copyright © 1998-9, 2002, Unify Corporation. All rights reserved.