How does the Java Database Connectivity (JDBC) work?
Daniel: JDBC maps a permanent storage solution’s operations under a single API (i.e. the JDBC API). Since each permanent storage solution will have a proprietary way in which to create, read, update and delete data, JDBC maps each of these proprietary calls to a single JDBC API call which performs uniformly irrespective of the permanent storage manufacturer.You can think of it in terms of crossing a bridge, with one end representing the Java application and another the permanent storage solution. To cross the first half of the bridge, you must learn the JDBC API and incorporate it with a Java application. The cross the second half of the bridge, you must rely on a JDBC driver designed for a particular permanent storage solution. The benefit is that once you know the JDBC API, you’re always half-way through communicating with any permanent storage solution that supports JDBC.
