Introducing the JDBC API

JDBC supports the development of both standard Java and enterprise Java applications. The JDBC API consists of the two main packages: the java.sql package, which is part of standard Java, and the javax.sql package, which is part of enterprise Java. The following two sections will briefly discuss these two main packages.

The java.sql Package

This is a client-side API that allows making connection to a data source, handling database operations and queries, and providing security. The key interface to this package is the Connection interface, which encapsulates all the database operations in the application logic. Table 9.1 lists the JDBC interfaces and gives a brief description of each.

Table 9.1. Summary of JDBC Interfaces ...

Get Sams Teach Yourself EJB in 21 Days now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.