Java Database Connectivity (JDBC) Fundamentals
What is JDBC?
JDBC (Java Database Connectivity) is a set of classes and interfaces written in Java that provide a complete API for programming databases from different vendors (e.g., Microsoft SQL Server, Oracle, MySQL, Interbase, Microsoft Access, IBM DB2, PostgreSQL) using SQL (Structured Query Language).
JDBC performs several key functions:
- Connects to the database (hereafter DB), which can be local (on your PC) or remote (on another PC).
- Sends SQL statements to the database.
- Manipulates the records within the database.
- Reflects the outcome of the execution of SQL statements.
JDBC vs. ODBC: Key Differences
JDBC differs from ODBC (Open Database Connectivity), Microsoft's widely used API for accessing various database providers from multiple platforms....