Section 15.7. Review

15.7. Review

Connecting a Java application to a database is a key step in real applications. The mechanisms for doing that are varied and can be complicated. We've picked a single approach for connecting, to keep it simple and to highlight the similarities and differences between two different database implementations.

The rest of the conversation with a database depends as much on your SQL skills as on Java skills. Java will take strings of SQL, which can be parameterized, and, via JDBC calls, send them to be executed by the database. The results are like iterators; they can be retrieved, row after row, for further processing. Updates, inserts, and deletes are also easily done, with a few simple calls to process the SQL.