22.7. Summary

JDBC provides a standard way of accessing relational databases from programs written in the Java programming language. It lets you avoid vendor-specific code, thus simplifying the process of using multiple databases and switching from one database vendor to another.

Although JDBC standardizes the mechanism for connecting to the database and the data structure that represents the result, it does not standardize SQL syntax. This means that you can still use vendor-specific SQL commands if you want to; it also means that SQL queries and commands need to be built from raw strings rather than by means of SQL-related method calls.

JDBC can be used from desktop applications and applets, although with applets you are restricted to the case ...

Get Core Web Programming, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.