JDBC Package Contents

The main package of the JBDC API is java.sql. All classes and interfaces belong to this package, which is part of the core Java. (All packages beginning with java.* are part of the core.) JDBC drivers must implement the interfaces while application developers use the interfaces. Using JDBC in your own programs doesn’t mean that you need to implement any of the JDBC interfaces yourself. It is never necessary to deal with implementation classes of specific drivers when developing with JDBC. The following are the contents of java.sql:

• The interface java.sql.Array: Handles array types in queries and result sets.

• The class java.sql.BatchUpdateException: An exception that can be thrown when doing batch updates.

• The interface java.sql.Blob: Handles binary large objects in queries and result sets.

• The interface java.sql.CallableStatement: A statement object used when making a call to a database stored procedure.

• The interface java.sql.Clob: Handles character large objects in queries and result sets.

• The interface java.sql.Connection: A connection object used to represent the state of a session or connection in the database.

• The class java.sql.DataTruncation: An exception thrown whenever data truncation happens when the driver returns results after performing a query.

• The interface java.sql.DatabaseMetaData: Obtains various information about the database engine and its capabilities.

• The class java.sql.Date: Handles date types in queries and result sets.

• The interface java.sql.Driver: A driver that implements the various database access functions for a specific database product; it also implements a particular wire protocol to communicate with the database.

• The class java.sql.DriverManager: Loads and handles drivers whenever necessary.

• The class java.sql.DriverPropertyInfo: Represents connection information that is set before a session is established.

• The interface java.sql.ParameterMetaData: Obtains information about parameter sets when calling stored procedures or dynamic statements.

• The interface java.sql.PreparedStatement: Enables the use of dynamic SQL.

• The interface java.sql.Ref: Handles the reference types of objects in queries and result sets.

• The interface java.sql.ResultSet: Holds rows of data and is typically retrieved after a query is made.

• The interface java.sql.ResultSetMetaData: Obtains information about result sets’ contents (the number of rows, column types, and so on).

• The interface java.sql.Savepoint: When dealing with transactions, enables intermediate commits and rollbacks.

• The interface java.sql.SQLData: Enables the custom mapping of SQL user-defined types.

• The class java.sql.SQLException: An exception thrown by the JDBC driver when a problem occurs in the driver itself or in the database.

• The interface java.sql.SQLInput: An input stream that contains a stream of values representing an instance of a SQL structured or distinct type.

• The interface java.sql.SQLOutput: An output stream for writing the attributes of a user-defined type back to the database.

• The interface java.sql.SQLPermission: Represents permissions to use the log writer facility; it is checked in applet environments only.

• The class java.sql.SQLWarning: A warning is thrown whenever a noncritical event happens during a query or update.

• The interface java.sql.Statement: Builds a SQL query or update before sending it for processing.

• The interface java.sql.Struct: Handles SQL structured types in queries and result sets.

• The class java.sql.Time: Handles time types in queries and result sets.

• The class java.sql.Timestamp: Handles timestamp types in queries and result sets.

• The class java.sql.Types: X/OPEN constants used to identify SQL types.