JDBC驱动疑问：标准API调用与底层调用分别指什么？

Great question—this is a core concept that helps you grasp how JDBC acts as a bridge between your Java code and databases. Let's break it down clearly:

What are Standard API Calls? #

These are the vendor-agnostic methods and classes defined in the java.sql (and javax.sql) packages that every JDBC-compliant driver implements. As a developer, these are the methods you directly call in your code—they're the "common language" you use to interact with any database, regardless of whether it's MySQL, PostgreSQL, Oracle, etc.

Examples of standard API calls include:

• DriverManager.getConnection(url, username, password): To establish a connection to the database
• Connection.createStatement(): To create a SQL statement object
• Statement.executeQuery(String sql): To run a SELECT query and get results
• ResultSet.getString(String columnName): To fetch data from the result set

The key benefit here is portability—your code doesn't need to change if you switch from one database to another, as long as you use the appropriate JDBC driver.

What are Low-Level Calls? #

These are the database-specific, low-level communication protocols or native operations that the JDBC driver converts your standard API calls into. Think of them as the "native language" that the target database understands directly.

Every database has its own way of communicating over the network or via native libraries:

• For MySQL, this might involve sending formatted TCP/IP packets following the MySQL Client/Server Protocol, including commands for authentication, query execution, and result retrieval.
• For Oracle, it's using the Oracle Net protocol (formerly SQL*Net) to exchange data with the Oracle database server.
• For embedded databases like SQLite, the driver might make direct native library calls to interact with the local database file.

You never need to write these low-level calls yourself—that's the driver's job. It handles all the translation: taking your high-level, standard JDBC method calls and turning them into the exact commands the database expects, then converting the database's raw response back into ResultSet objects or other standard JDBC structures you can work with.

A Simple Analogy #

Imagine you're traveling to a foreign country. You speak English (standard API calls), but the locals only speak their native language (low-level database calls). The JDBC driver is your translator—it takes your English requests, converts them into the local language, and brings back the responses translated into English so you can understand them.

内容的提问来源于stack exchange，提问作者Mohammad Mehdi Sarfejoo