SDBC Driver

From OpenOffice.org Wiki

The SDBC driver consists of seven services. Each service needs to be defined and are described in the next sections. Below is a list of all the services that define the driver:

• Driver, a singleton which creates the connection object.
• Connection, creates Statement, PreparedStatement and gives access to the DatabaseMetaData.
• DatabaseMetaData, returns information about the used database.
• Statement, creates ResultSets.
• PreparedStatement, creates ResultSets in conjunction with parameters.
• ResultSet, fetches the data returned by an SQL statement.
• ResultSetMetaData, describes the columns of a ResultSet.

The relationship between these services is depicted in the illustration below.